cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: Its Urgent! Please..
Date Tue, 01 Aug 2000 22:47:00 GMT
On Tue, 1 Aug 2000, K N Yasa wrote:

> Hi Folks,
> 
> Environment: Weblogic,cocoon, java 1.2,Oracle8i,NT
> 
> 1.  if I use SQLprocessor in writing in XSP,  does it causes to any
> traffic??? how does it handle the http request.

you probably don't want to mix sql processor and xsp. use the sql
logicsheet.

> here I have enclosed an example xsp which we are expecting to write:
> 
> <?xml version="1.0"?>
> <?cocoon-process type="xsp"?>
> <?cocoon-process type="sql"?>
> <?cocoon-process type="xslt"?>
> <?xml-stylesheet href="xsl/favsearch.xsl" type="text/xsl"?>
> 
> <xsp:page
>   language="java"
>   xmlns:sql="http://www.apache.org/1999/SQL"
>   xmlns:xsp="http://www.apache.org/1999/XSP/Core">
> 
>   <page title="SQL Search Results">
>   <sql:execute-query>
>   <sql:driver>weblogic.jdbc.oci.Driver</sql:driver>
>   <sql:dburl>jdbc:weblogic:oracle:xxxxl:dburl>
>      <sql:username> scott</sql:username>
>      <sql:password>password</sql:password>
>   <sql:tag-case>lower</sql:tag-case>
>   <sql:null-indicator>yes</sql:null-indicator>
>   <sql:doc-element>ROWSET</sql:doc-element>
>   <sql:id-attribute-column>none</sql:id-attribute-column>
>   <sql:query>select member_first_name from member where member_first_name
> like '<xsp:expr>request.getParameter("search")</xsp:expr>%'</sql:query>
>   <sql:count-attribute>nome</sql:count-attribute>
>   </sql:execute-query>
>   </page>
> </xsp:page>

ah, you're using the sql logicsheet - strip the call to the sql processor
- it's just a waste of cycles.

- donald


Mime
View raw message