RE: [sqr-users] how to pass multiple query parameters to the WHEREclaus e

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Make it:

WHERE leave_type IN [$leave_type]

-----Original Message-----
From: Pruszkowski, Roman [mailto:pruszkowskir@aecl.ca]
Sent: Wednesday, March 10, 2004 1:09 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] how to pass multiple query parameters to the
WHEREclaus e 


Hi all,

I am having this kind of problem - hopefully ,the last piece of the puzzle:
I have to pass parameters to the WHERE clause and I must use IN
like this:

WHERE leave_type IN ('VACATION','SICK 100%','BANKED TIME')

Currently, I have a variable $leave_type that holds this string.
Unfortunately, when I write it like this:

WHERE leave_type IN $leave_type

the report comes out empty. Is there a different syntax for this kind of
problem?

Any comments will be appreciated.
Thank you

Roman

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users