cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wm. G. Urquhart" <will...@devnet-uk.net>
Subject Re: SQL and XSP!!!!
Date Wed, 31 May 2000 15:23:58 GMT
mohamed ramzy wrote:
> 
> hi
> i want to make a dynamic query by useing XSP with SQL,
> i did a simple Query but it didn't work ..which is
> 
> <xsp:logic>
> String[] tst=request.getParametersValues("type");
> </xsp:logic>
> <query connection="first">
> select * from pet
> where species= "<xsp:expr>tst[0]</xsp:expr>"
> </query>
> 
> where "type" holds the name of a species.....
> it didn't work///
> 
> does anyone has an idea!!!!!
> 
> Thanx in Advance
> 
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org

Use:

String tst = request.getParameter("type") ;

...
select * from pet where species= '<xsp:expr>tst</xsp:expr>'
...

William.

Mime
View raw message