cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans-Guenter Stein <Hans-Guenter.St...@siteos.de>
Subject Re: built sql query
Date Mon, 10 Jul 2000 16:52:03 GMT
try something like:

...
xmlns:request="http://www.apache.org/1999/XSP/Request"
...
<xsp:logic>
String theID[] = <request:get-parameter-values name="id"/>;
QueryString = "select * from sometable where tableid=" + theID[0];
result = myDBMethod.execQuery(QueryString);
...
</xsp:logic>


Torsten Curdt wrote:

> I know now how to do and display a sql query with cocoon.
> But can anyone show me a good way to do a built query?
>
> I mean a query that is modified by the parameters passed
> to the page (a very common task)
>
> something like:
>
> show.xml?id=50 -> select * from sometable where tableid=50
>
> actually the question is: how can I pass my java built
> sql string to the sql processor?
> --
> Torsten
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message