cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicki Møller <>
Subject Re: AW: Wildcard in a SQL-query??
Date Mon, 24 Jul 2000 09:16:51 GMT
Hi Henning,

True sorry but the examples was only to give an Idea
of what I was searching for. I guess I didn't do that
very well. So here I go again 

I'm looking for a way to refere to the variable that I
create exactly like this 

 String day = request.getParameter ("day");
 day = "'" + day + "%'";

In my query I'd like to use the day-var like this. 

SELECT Event_Id, Body, Starttime, Endtime FROM Events
WHERE Starttime LIKE day ORDER BY Starttime Desc

Can anyone help me with this 

(Sorry the former ambiguous question)


--- Henning von Bargen
<> skrev: > But if you
test with non-valid SQL syntax as in the
> examples you gave 
> then you cannot expect variables to work.
> Henning

Do You Yahoo!?
Få en gratis på

View raw message