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 terminal.userID =
<esql:parameter type="int">
<request:get-parameter name="userID"/>
</esql:parameter>
and user.userID = terminal.userID
and deviceType.deviceType = terminal.deviceType
and registration.terminalID = terminal.terminalID;
</esql:query>
Replace "int" with "long" or "string", as necessary to match your field
type.
-Christopher
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: HTTP request parameter
Hi,
what is required to get the http request parameter to work? I have
----------------------------
[...]
<xsp:page language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:request="http://www.apache.org/1999/XSP/Request"; <<---HERE
>
[...]
<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 terminal.userID = <request:get-parameter name="userID"/>
<<---HERE
and user.userID = terminal.userID
and deviceType.deviceType = terminal.deviceType
and registration.terminalID = terminal.terminalID;
</esql:query>
[...]
As far as I have understood, I can then put
------------
?userID=123456
------------
at the end of the url, e.g.
-------------
http://localhost/welcome.xml?userID=123456
and 123456 will be used. But it's not working, so I guess I'll have to add
something somewhere? I don't get any error messages, but I don't get any
data from the query either. The query works when I use
---
<!ENTITY userID "123456"> //(in the DTD)
[...]
and terminal.userID = &userID; //(in the query)
-------
I'm using Cocoon 1.8.2
/Anne Marie
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
