I have an array containing alphanumeric user ID's. I am trying to build a query that
will select data if the user ID is in the array, i.e.
select * from employee where userid in ('userid1','userid2',...,'useridn')
I used and
select * from employee where userid in ('#tempList#')
This resolved to
select * from employee where userid in ('userid1'',''userid2') which failed.
I then built a string tempList = 'userid1','userid2' and used
select * from employee where userid in (#tempList#)
This resolved to
select * from employee where userid in (''userid1'',''userid2'') which failed.
I've tried building the whole SQL string in a variable with the same results.
I tried using double quotes as well.
I am using CF5 and SQL Server 6.5.
Any Help would be appreciated.
TIA,
Sam
------------------------------------------------
Can a Web portal forever change your life?
Win up to $25 Million on iWon - click here!
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
