Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 19904 invoked from network); 14 Apr 2000 13:14:27 -0000 Received: from gate-isdn.imsport.co.uk (194.152.72.121) by locus.apache.org with SMTP; 14 Apr 2000 13:14:27 -0000 Received: from [192.168.2.191] (helo=ims10800) by gate-isdn.imsport.co.uk with smtp (Exim 2.12 #1) id 12g5yW-0005uW-00 for cocoon-users@xml.apache.org; Fri, 14 Apr 2000 14:17:32 +0100 Message-ID: <007b01bfa613$b72a10c0$bf02a8c0@localnet> From: "Yann" To: Subject: SQL taglib and Parameterized Stored Queries Date: Fri, 14 Apr 2000 14:16:59 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0078_01BFA61C.189D7290" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0078_01BFA61C.189D7290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What is the right SQL taglib syntax to call a stored query (or view)? Ideally, I'd like something like: The value of the = parameter Although I use Access for prototyping, I'd ideally want my XSP not to = change if I was then switching to SQL Server 7 (but then again Access = isn't ANSI-92 compliant, is it?). Donald, do you see what I'd like to achieve? I haven't involved much = with JDBC (I have done a lot of ADO stuff though). I don't want any = embedded SQL in my XSP really. Thanks for any help Yann. P.S. BTW Donald, what's your view on select (returning resultset) vs = action (not returning resultset) queries taglib strategy? ------=_NextPart_000_0078_01BFA61C.189D7290 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

What is the right SQL taglib syntax to = call a=20 stored query (or view)?

Ideally, I'd like something = like:

<sql:query = name=3D"thequeryname">

=20 <sql:parameters>

=20 <sql:arameter type=3D"varchar2">The value of=20 the parameter</sql:parameter>

=20 <sql:parameters>

</sql:query>

Although I use Access for prototyping, = I'd ideally=20 want my XSP not to change if I was then switching to SQL Server 7 (but = then=20 again Access isn't ANSI-92 compliant, is it?).

Donald, do you see what I'd like to = achieve? I=20 haven't involved much with JDBC (I have done a lot of ADO stuff though). = I don't=20 want any embedded SQL in my XSP really.

Thanks for any help

Yann.

P.S. BTW Donald, what's your view on = select=20 (returning resultset) vs action (not returning resultset) queries taglib = strategy?

------=_NextPart_000_0078_01BFA61C.189D7290--