Re: esql not working at all, no connection ever created!

2003-04-02 Thread Christopher Painter-Wakefield
! | --| On 01.Apr.2003 -- 01:48 PM, Christopher Painter-Wakefield wrote: Is this the whole XSP program? If so, the problem is that you don't have the required single non-xsp child node of xsp:page. E.g., you have: xsp:page ... esql:connection

Re: esql not working at all, no connection ever created!

2003-04-01 Thread Christopher Painter-Wakefield
usermyusername/user passwordmypassword/password /jdbc Here is my pipeline for testing: map:pipeline map:match pattern=content/*.xml map:generate type=xsp src=content/{1}.xsp/ map:serialize type=xml/ /map:match /map:pipeline Thanks again Christopher Painter-Wakefield

Re: mail function

2003-03-17 Thread Christopher Painter-Wakefield
There is a sendmail logicsheet, not documented on the website. To use it is pretty simple, here's an example of what you might do with a POST from a message form: xsp:page xmlns:xsp=http://apache.org/xsp; xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0; page xsp:logic

Re: ESQL Woes in XSP

2002-11-26 Thread Christopher Painter-Wakefield
Not true, you definitely can wrap logic, including while statements around esql code. (Remember, it just turns into more Java code, so...) You can even extract your esql and put it into a separate function, as long as you don't have any XML output from it (you can still do it, but you have to

Re: ESQL Woes in XSP

2002-11-26 Thread Christopher Painter-Wakefield
As someone else mentioned, change class1 = esql:get-string column=CLASS/; to class1 = esql:get-string column=CLASS/; Also, you might run into trouble with ...where SELECTION = 'xsp:exprcurrentSelection/xsp:expr'/esql:query , as the XSP compiler might put the quotes and the content

Re: XSP Logicsheet Questions...

2002-11-11 Thread Christopher Painter-Wakefield
FWIW, we are using relative file paths for our logicsheets, and this is supposed to cause pages to be recompiled if we modify the logicsheet. Be warned, though, that it seems to be somewhat flaky; it often works as expected, but sometimes not. In those cases, you have to touch the main XSP

Re: AW: url rewriting

2002-10-23 Thread Christopher Painter-Wakefield
Painter-Wakefield [mailto:paint007;mc.duke.edu] Gesendet: Dienstag, 22. Oktober 2002 19:34 An: [EMAIL PROTECTED] Betreff: Re: url rewriting Chris, I don't know much about actions, so I can't help you too much with that. However, I can offer some hints on the EncodeURLTransformer. Basically, it has

Re: url rewriting

2002-10-22 Thread Christopher Painter-Wakefield
Chris, I don't know much about actions, so I can't help you too much with that. However, I can offer some hints on the EncodeURLTransformer. Basically, it has a bug. The first time you hit a page, it fails to rewrite the URLs. This works for some frameworks, in which the first page is a login

Re: xsp:logic how to ???

2002-09-26 Thread Christopher Painter-Wakefield
I'll take a stab at it... You don't need java for looping over the rows, that is already done by the esql logicsheet when you use esql:row-results. You can mix xsp:logic and ESQL tags as needed however. Here's some code (below) that might be close to what you want to do. Note I wasn't sure

Re: Sun vs. PC

2002-09-24 Thread Christopher Painter-Wakefield
The most obvious thing that jumps out here other than raw MHz is that you are running C2.1-dev on the Sun and C2.0.3 on the PC, so you aren't really comparing apples to apples. Maybe that isn't a factor, but I would certainly want to check it out before anything else. Especially with that -dev

Re: C2.0.3 silently ignoring exceptions

2002-09-04 Thread Christopher Painter-Wakefield
Christopher Painter-Wakefield wrote: Did any of the Cocoon developers read this thread? Should I post it to cocoon-dev? I want to make sure these bugs get addressed. I am a Cocoon dev (I also wrote the error handling code, but it's not a compliment ATM I guess), but I have limited time ATM

Re: C2.0.3 silently ignoring exceptions

2002-09-03 Thread Christopher Painter-Wakefield
Did any of the Cocoon developers read this thread? Should I post it to cocoon-dev? I want to make sure these bugs get addressed. Thanks, Christopher Christopher Painter-Wakefield wrote: Thanks for the reply. I've attached some sample code that exhibits the problem, and a sitemap, xconf

Re: C2.0.3 silently ignoring exceptions

2002-08-30 Thread Christopher Painter-Wakefield
snip BTW, are you using the compiled sitemap or the interpreted TreeProcessor one? The interpreted one. BTW, does the same error happen in 2.1? I don't know; we've been working solely with the released code. snip -Christopher

Re: C2.0.3 silently ignoring exceptions

2002-08-29 Thread Christopher Painter-Wakefield
. -Christopher On Wednesday, August 28, 2002, at 05:57 , Christopher Painter-Wakefield wrote: This problem (I won't say bug, in case it is something we've done!) is very detrimental to development, since we have to go look in the logs to find out we got an exception. Any help would be appreciated

Re: C2.0.3 silently ignoring exceptions

2002-08-29 Thread Christopher Painter-Wakefield
aggh! The listserv host rejected my mail as too large. Okay, I'll try it again without the xconf and web.xml. If these seem relevant, I'll send them separately. - Forwarded by Christopher Painter-Wakefield/mcis/mc/Duke on 08/29/2002 03:06 PM - Thanks for the reply. I've attached

Re: C2.0.3 silently ignoring exceptions

2002-08-29 Thread Christopher Painter-Wakefield
did anyone get the mail with the attachments? I had to resend it with fewer attachments because it was rejected as too large the first time. The second time it seemed to go through (I received it from cocoon-users), but I got a different message complaining about the size, plus a separate

RE: C2.0.3 silently ignoring exceptions

2002-08-29 Thread Christopher Painter-Wakefield
thank you. I got it. -Original Message- From: Christopher Painter-Wakefield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:14 PM To: [EMAIL PROTECTED] Subject: Re: C2.0.3 silently ignoring exceptions did anyone get the mail with the attachments?  I had to resend

C2.0.3 silently ignoring exceptions

2002-08-28 Thread Christopher Painter-Wakefield
Since we upgraded to Cocoon 2.0.3, we've been experiencing a very annoying problem, which is that Cocoon seems to silently handle all exceptions. I've tested it now with a couple of exceptions types: RuntimeExceptions (thrown by the ESQL logicsheet) and NullPointerExceptions. The behavior is

Re: How to send redirect from an XSP?

2002-08-21 Thread Christopher Painter-Wakefield
You shouldn't do it. Use an action for this. There are already a number of actions that perform this job. Use one of them, modify one of them, write a new one, or write an XSP action that does it. What is an XSP action? Can we now use XSP to write Actions? Is there any documentation on it?

RE: Cocoon bug ? XSLT transform before SQL transform

2002-06-20 Thread Christopher Painter-Wakefield
Konstantin, we've experienced a similar problem, too. We had input XML that used the SQL transformer namespace, transformed with an XSLT stylesheet, and fed into SQL transformer, with the same error. We had a template that created the SQL query tags for the transformer, and the namespace was

[C2] XSLT transform error messages

2002-06-12 Thread Christopher Painter-Wakefield
A request for the C2 developers: *Please* find a way to send back a reasonable error message when there is a problem with a stylesheet. The generic Exception in creating Transform Handler (below) is so unhelpful. It doesn't give any clue as to the nature of the problem, which is often

RE: [C2] bug: still have to touch XSP file after changing logicsheet

2002-06-11 Thread Christopher Painter-Wakefield
Vadim, thanks, that is illuminating. We are using context://... to reference our logicsheets, for portability. Is there a way to use the file reference relative to the context root (instead of an absolute path)? -Christopher From: Christopher Painter-Wakefield [mailto:[EMAIL PROTECTED

RE: [C2] bug: still have to touch XSP file after changing logicsheet

2002-06-11 Thread Christopher Painter-Wakefield
Thanks, we'll give it a try. -Christopher From: Christopher Painter-Wakefield [mailto:[EMAIL PROTECTED]] Vadim, thanks, that is illuminating. We are using context://... to reference our logicsheets, for portability. Is there a way to use the file reference relative to the context

RE: [C2] bug: still have to touch XSP file after changing logicsheet

2002-06-03 Thread Christopher Painter-Wakefield
. -Christopher From: Christopher Painter-Wakefield [mailto:[EMAIL PROTECTED]] Cocoon doesn't recognize the dependencies of XSP files on the logicsheet they use. Changing a logicsheet does not force a recompile of the dependent XSP pages. Instead we must manually touch each XSP page using

[C2] bug: still have to touch XSP file after changing logicsheet

2002-05-31 Thread Christopher Painter-Wakefield
Cocoon doesn't recognize the dependencies of XSP files on the logicsheet they use. Changing a logicsheet does not force a recompile of the dependent XSP pages. Instead we must manually touch each XSP page using the logicsheet. I know this has been reported in the past, but it is a constant

Re: how do I redirect in an Action?

2002-05-23 Thread Christopher Painter-Wakefield
suggestions? -Christopher From: Christopher Painter-Wakefield [EMAIL PROTECTED] What is the proper way to redirect in an Action? Why do you have to redirect in an action? I would not suggest it. Redirect instead in the sitemap based on the results of the Action. -- Nicola Ken Barozzi

RE: how do I redirect in an Action?

2002-05-23 Thread Christopher Painter-Wakefield
Thanks for all the suggestions. I'm pretty confused at this point, as I haven't used map:resource or map:select previously, so I need to spend some time understanding the code you've offered. One thing in particular I don't see is where I should put my normal generate, transform, and serialize

Re: how do I redirect in an Action?

2002-05-23 Thread Christopher Painter-Wakefield
Chris, if I do a redirect in an Action, does that effectively terminate the pipeline also? Also, is my understanding correct that if I create an Action that merely returns a new Map, this is essentially a no-action and will leave the pipeline unaffected? -Christopher On 23.May.2002 --

C2: how do I redirect in an Action?

2002-05-22 Thread Christopher Painter-Wakefield
What is the proper way to redirect in an Action? I presume we are supposed to use the Redirector object, since nothing else seems able. I've looked at the Redirector interface, but the API docs have zero explanation (g!) of the methods. If this is the right object, then: 1) what is the

Re: JConnect / Sybase + Cocoon

2002-01-22 Thread Christopher Painter-Wakefield
Have you set up your Sybase for JDBC? We were having similar problems until we had our DBA run a script (provided with jConnect in the sp subdirectory) to set up a bunch of stored procedures that jConnect needs. See

Re: [c2] q: howto use ESQL inside own logicsheets?

2001-12-04 Thread Christopher Painter-Wakefield
Obviously the ESQL logicsheet is not being applied. In Cocoon 1 this would imply that you had removed the declaration of the esql logicsheet from cocoon.properties, or that your namespace declaration URI didn't match the one in the logicsheet. I don't know how this works in Cocoon 2; maybe the

RE: How do I use logicsheets parameters

2001-11-30 Thread Christopher Painter-Wakefield
Christopher, you're welcome; I'm glad it was helpful. Good luck to you. -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: RE: How do I use logicsheets parameters Christopher, Many thanks for a model answer, The missing penny has dropped because

Re: How do I use logicsheets parameters

2001-11-29 Thread Christopher Painter-Wakefield
Christopher, first, may I suggest some general strategies for developing logicsheets? - start simple and extend by small increments, e.g., instead of trying to get this working by passing either an attribute or a child element, get it working one way, then get it working *seperately* the other

Re: what is wrong?

2001-11-28 Thread Christopher Painter-Wakefield
Move this line: ?cocoon-process type=xsp? above this line: ?cocoon-process type=xslt? You are currently running your xml through the stylesheet processor before the XSP processor. -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: what is wrong? I

Re: [C2] using HTML nowrap in a TD

2001-10-26 Thread Christopher Painter-Wakefield
With Cocoon, you write XHTML and not HTML. The main difference is that XHTML is well-formed like XML, which is why you write e.g., br/ instead of br by itself. Also, all attributes must have a value. See http://www.w3.org/TR/xhtml1/#diffs for more info. (This document, btw, suggests that td

Re: [C1] Cocoon SQL vs ESQL

2001-10-19 Thread Christopher Painter-Wakefield
You don't say in what way the code is not working; do you get an exception, other error message, or just no data? If the latter, are you sure your XSL stylesheet matches the structure of the XML you are creating? -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:

Re: esql nested query not working - 1.8.2

2001-09-19 Thread Christopher Painter-Wakefield
: Christopher Painter-Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 9:41 AM Subject: Re: esql nested query not working - 1.8.2 Try removing the single quotes around esql:parameter type =stringesql:get-string ancestor=1 column=rid//esql:parameter I think

Re: esql nested query not working - 1.8.2

2001-09-18 Thread Christopher Painter-Wakefield
Try removing the single quotes around esql:parameter type =stringesql:get-string ancestor=1 column=rid//esql:parameter I think by including the single quotes you are making a query that doesn't use parameters (your where clause looks like ... Main.rid = '?' , e.g., the literal string '?').

Re: To those who are experts in using fop

2001-09-10 Thread Christopher Painter-Wakefield
I think you can just set the page-width and page-height attributes in your page master element, e.g., fo:layout-master-set fo:simple-page-master page-master-name=pmaster page-width=11in page-height=8.5in ... /fo:simple-page-master /fo:layout-master-set However,

Re: Nobody Knows HOW TO SAVE STREAM ON DISK!!

2001-09-10 Thread Christopher Painter-Wakefield
I think the reason nobody is answering is that nobody on this list knows offhand how to do it. They would have to spend time looking up the appropriate Java references, etc., for your benefit. I would suggest that what you are trying to do is not basic xsp but very advanced, and therefore

Re: Building 1.8.2

2001-09-06 Thread Christopher Painter-Wakefield
try http://xml.apache.org/dist/xalan-j/old/ Although I don't see a 1.2.3 - the closest seems to be 1.2.2. -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Building 1.8.2 hi, it says I need xalan 1.2.3 which isn't available anymore, so which one do

Re: Publishing Engine could not be initialized.

2001-09-05 Thread Christopher Painter-Wakefield
I'm sorry, I don't know the source of your problem, but I can help a little bit. My setup is mostly like yours. The symbolic links shouldn't be a problem (I assume you are on some kind of *nix). My setup uses symlinks as well, and I've done that successfully on both Solaris and Linux. When

Re: Dynamic XSP

2001-09-05 Thread Christopher Painter-Wakefield
This approach is strongly discouraged. If you try to do it this way, your pages will take a long time to load, every time, because your second XSP program will have to be recompiled every single time. So, even if you can make it work, you won't *want* to. Is there some reason you are trying

Re: mod_Jk

2001-09-04 Thread Christopher Painter-Wakefield
I think you'll have to go to a jakarta mailing list for this one - this isn't a Cocoon issue. As I remember, when I installed Tomcat, the mod_jk source was in the Tomcat source in the download, and I had to build it. It wouldn't be real surprising if you have to rebuild it for a new version of

Re: XSP code reuse problems

2001-09-04 Thread Christopher Painter-Wakefield
Alexandru, look at your generated code, and I think you'll see why this doesn't work. ESQL creates a number of local variables inside the populateDocument() method, which it needs for its tags. These local variables obviously aren't available to other methods in the class. -Christopher

Re: Apache/Tomcat/mod_jk/C1 ?

2001-08-27 Thread Christopher Painter-Wakefield
RTFM. Specifically, http://xml.apache.org/cocoon/install.html -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Apache/Tomcat/mod_jk/C1 ? Hi, Is it possible to install Cocoon 1.8.x on Apache/Tomcat/mod_jk. If yes, where could i find some

Re: C2 error in the page Session Logicsheet

2001-08-22 Thread Christopher Painter-Wakefield
How about copying the existing one into the Cocoon 1 documentation before changing it? It would also be nice for the original Request logicsheet docs to be copied into the Cocoon 1 docs (they were originally for Cocoon 1, too). There are still a lot of folks working with Cocoon 1 and asking

Re: [C2b2] document() function not working?

2001-08-22 Thread Christopher Painter-Wakefield
If you are getting nothing back when you use the document() function, make sure the file you are opening with document() is valid XML. I found out the hard way that document() fails silently (at least in Cocoon 1.8.2) when the XML is bad. Try opening the XML document in IE or something like

Re: Naming folders...bug or what?? (1.8.2)

2001-08-22 Thread Christopher Painter-Wakefield
There shouldn't be any issues with folder naming; I use this pattern all the time. I believe the particular error you mention occurs when you try to put text in the output at the root level (e.g., not inside an enclosing element). For example, xsl:template match=/ Hello, World!

Re: Dynamic stylesheets (Newbie question)

2001-08-22 Thread Christopher Painter-Wakefield
Kevin, there are many ways of doing what you want to do, outside of modifying your code as has already been suggested. You can generate Cocoon processing instructions dynamically in your XML, using the xsp:pi tag (see http://xml.apache.org/cocoon/xsp.html for instructions on this.) You can

Re: What's wrong?

2001-08-21 Thread Christopher Painter-Wakefield
It sounds like you have a configuration file that is pointing to [dir-to-cocoon]/conf/cocoon.properties instead of to a valid path. If you were using Tomcat, the file to edit would be web.xml in your WEB-INF directory, which comes with a similar bogus setting in the download package. Look for

Re: XSP: Type and Identifier errors

2001-08-20 Thread Christopher Painter-Wakefield
Bobo, the line numbers actually refer to the generated Java code, which is in a repository directory as defined by your cocoon.properties file. I think your first error here is missing semicolons on the lines String fname = request.getParameter(fname) ...//some more request.getParameter()

Re: [c1]esql:get-int ... as param for xsl:call-template ...

2001-08-16 Thread Christopher Painter-Wakefield
Hubert, you are mixing two different things. Keep in mind that when you are writing a logicsheet, you are writing an XSLT stylesheet that will transform based only on what is available to it in your XML file. This happens once and only once, statically, to generate Java code which will then

Re: Java variable inside of document() function?

2001-08-16 Thread Christopher Painter-Wakefield
Martin, first, are you trying to do this in a logicsheet or in a stylesheet? In a logicsheet, this won't work because your logicsheet exists to generate Java code. The Java code doesn't exist and hasn't been compiled and can't run yet. Only your XSL transformations are being applied. The

Re: transfering variable values from the java side to the xsl side

2001-08-16 Thread Christopher Painter-Wakefield
See my reply to Martin. You have the same problem: you can't mix XSP and XSL. You can use XSL in a logicsheet to generate XSP code, or you can run XSP code to generate XML and then transform the output with XSL. -Christopher Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: xml/xsl/xsp

2001-08-15 Thread Christopher Painter-Wakefield
Arif, you aren't doing anything to obtain the user's input. Are you familiar with HTML forms in CGI or Servlet programming or anything like that? If not, you might want to get a book on Servlets or some such. Anyway, try modifying your XML to something like this: ?xml version=1.0?

Re: request taglib + query

2001-08-14 Thread Christopher Painter-Wakefield
Anne Marie, this may sound completely stupid, but remove the semicolon at the end of your query. I copied your XML into a new file in my project and edited it to make the query match tables in my database and changed the pool to one of my own pools. I also removed your stylesheets and used a

Re: I can't make XSL to work for cocoon1.8.2

2001-08-14 Thread Christopher Painter-Wakefield
Could you be more specific as to what is different in your output from Cocoon that with Xalan? The code you put in your e-mail does have a typo: xsl:processin-instruction - processing is missing its 'g'. -Christopher Please respond to [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL

Re: HTTP request parameter

2001-08-09 Thread Christopher Painter-Wakefield
Anne Marie, try esql:query select name as reg_name, deviceID as reg_deviceID, description as reg_description, startTime as reg_startTime, endTime as reg_endTime from user, terminal, deviceType, registration where

Re: Replacing \n with BR - cocoon pb ?

2001-08-09 Thread Christopher Painter-Wakefield
What about doing the replacements in your SELECT statement to create well-formed XML, then using the esql:get-xml ... to retrieve it? In Oracle, it would look like: SELECT 'mytext' || REPLACE(mytextfield, CHR(10), 'BR/') || '/mytext FROM I would guess most RDBMS have a similar

Re: [c1] xsp:logic compiling

2001-08-07 Thread Christopher Painter-Wakefield
Brent, it sounds like you are getting there, maybe a few hints will close the gap for you. First off, you *can* apply multiple logicsheets to an XML document. Use the ?xml-logicsheet href=...? processing instruction multiple times for logicsheets that aren't associated with a namespace in the

Re: [c1] xsp:logic compiling

2001-08-03 Thread Christopher Painter-Wakefield
Brent, is the code you've submitted from a logicsheet? What does your XML file look like? If you are trying to run your XML through a stylesheet, and then through the XSP processor, as it appears you might be doing, then you need to rethink your approach. For more info on logicsheets and how

RE: AW: [C2] Redirects

2001-07-11 Thread Christopher Painter-Wakefield
I agree. It is fine to discourage use of redirects, but dictating it to everyone by arbitrarily removing it from the framework is, in my opinion, a poor choice. Trust us to make mature choices about what constitutes good design, even while educating us on a better way. I think the point is

Re: cocoon2 + logicsheet

2001-06-25 Thread Christopher Painter-Wakefield
Kester, sorry about that. I wrote that particular document, but I intended it for the Cocoon 1 site. It was added to the Cocoon 2 docs, but I didn't say anything because I thought perhaps it was applicable to both. (I have no experience with Cocoon 2.) It sounds like it isn't a good match

Re: generate dinamic page from a single index.xml

2001-06-15 Thread Christopher Painter-Wakefield
Simone, this is very easy to do, and Cocoon provides many different ways you can do it. Here's a simple example using only XML and XSLT: index.xml: ?xml version=1.0? ?cocoon-process type=xslt? ?xml-stylesheet type=text/xsl href=index.xsl? items itemone/item

Re: xml page1 calls xml page2

2001-06-14 Thread Christopher Painter-Wakefield
Simone, I think you'll need to be more specific. From what you've described, a simple hyperlink does what you are looking for, e.g. a href =page2.xmlNext/a. -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: xml page1 calls xml page2 My situation

RE: (urgent)ESQL question

2001-06-13 Thread Christopher Painter-Wakefield
Without looking at all of your code, it is hard to be sure what the problem might be. For instance, how is username declared in your program? The best way to debug these problems is to look at the generated Java code, so that you can easily see where variables are being declared and set and so

Re: rendering PDF only

2001-06-13 Thread Christopher Painter-Wakefield
FOP is a separate project from Cocoon, just used by Cocoon (just as you want to do). Go to the xml.apache.org site and click on the FOP links. Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: rendering PDF only Hi all, I would like to take advantage of cocoon

Re: PDF generation

2001-06-13 Thread Christopher Painter-Wakefield
Are you using IE, by any chance? Try Netscape. If it comes up fine in Netscape, then read the FAQ entry about IE and PDF. -Christopher I have tried all cocoon samples . it generated pdf format but no data in it. Pls explain me the reason i am using weblogic 5.1 janesh Wed Jun 13

Re: rendering PDF only

2001-06-13 Thread Christopher Painter-Wakefield
Adel, sorry, I don't know Cocoon at the level you want. Best I can offer is you can start by looking at the Javadocs for the Cocoon project (there's a link on the Cocoon docs pages). Good luck. -Christopher Hi Cristopher, I know that fop is responsible of rendering PDF but what I want

Re: Problem with my query

2001-06-13 Thread Christopher Painter-Wakefield
Gustavo, try this: esql:queryselect * from employee where empno= esql:parameterMY_VARIABLE/esql:parameter /esql:query You may need to specify a type, such as esql:parameter type=int, otherwise it will assume a String. -Christopher Thanks, I chanche my code to: ?xml version=1.0?

Re: Problem with my query

2001-06-13 Thread Christopher Painter-Wakefield
Gustavo, you want to use the request taglib, for which there isn't any documentation (hopefully soon there will be). Anyway, try this: esql:query select * from employee where empno= esql:parameter request:get-parameter name=VAR/ /esql:parameter /esql:query You'll need to add a