RE: [ cf-dev ] CONTAINS

Tue, 18 May 2004 04:15:18 -0700

Some kind of crazy Query of Queries?
 
 
 
niklas richardson
managing director
prismix ltd
t +44 (0) 870 749 1100
f +44 (0) 870 749 1200
w www.prismix.com






 

From: Matt Horn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 12:00 PM
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]
|\--------------------/|

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.241 / Virus Database: 262.10.1 - Release Date: 16/05/2004

<<logo_small_t.gif>>

Reply via email to