Matt Horn wrote:
Hi
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)
that obviously doesnt work
In mySQL you have LOCATE(substr,string) and |FIND_IN_SET(str,strlist)|
||
|I doubt they'll work against access, but worth a try. Otherwise you're left with shooting the db developer, getting all the records and looping through them all in cf. |
||
|||Might be as well to write the code to loop through the records and rebuild your table while you're at it, so you can just query a "link" table.
Stephen |
-- 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]
