Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 43807 invoked from network); 1 Aug 2000 22:43:54 -0000
Received: from balld-0.dsl.speakeasy.net (HELO localhost.localdomain)
 (@216.254.77.75)
  by locus.apache.org with SMTP; 1 Aug 2000 22:43:54 -0000
Received: by localhost.localdomain (Postfix, from userid 501)
	id B09BE4810; Tue,  1 Aug 2000 18:47:00 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by localhost.localdomain (Postfix) with ESMTP
	id 97B686029; Tue,  1 Aug 2000 18:47:00 -0400 (EDT)
Date: Tue, 1 Aug 2000 18:47:00 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: cocoon-dev@xml.apache.org, knyasa@efavorites.com
Subject: Re: Its Urgent! Please..
In-Reply-To: <000401bffc0e$31d30d40$a000a8c0@corp.efavorites.com>
Message-ID: <Pine.LNX.4.21.0008011845260.1535-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

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