I have a table with column containing a LIST of ID's
and I want to write a query that will return all records where the passed
ID is in the list
something like
select stuff from table where URL.ID in (IDlist)
here's one way...
SELECT stuff FROM table
WHERE ',' + IDlist + ',' LIKE '%,#url.id#,%'
Mark
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
