RE: [ cf-dev ] CONTAINS

[Snake Hollywood]

Title: Message

on the other hand, perhaps u mean, you are passing a list of ID's on the URL and want tot select all records where the ID is in that list... in which case it is   select * from table where IDCOLUMN in (#URL.ID#)     -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 12:00 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CONTAINS 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   I am using access *run* any help would be muchly appriciated    Thanks    Matt   |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|