Do a SELECT first to get the value in a previous <CFQUERY> then put that
value in the SQL. JET is interpreting that field in the query as one value,
not a CSV list. This is the same issue as passing a comma delimited list
into a SP and trying to do the same thing as below.
hth...
David L. Penton, MCP
Consultant
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dave Cahall
Sent: Thursday, February 08, 2001 10:53 AM
I have a record that has a field of comma separated values. The field is
set up as a text field and I want to use that field to pull multiple
records from a linked table like:
WHERE CID IN (table.field)
Since CID is a numeric field in database, I keep getting type mismatch
errors (using MS Access 2000).
Any suggestions???
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
