<cfquery ...>
select
whateveryouwanttoselect
from
tablename
where
idnumber = #whatever#
</cfqury>
-----Original Message-----
From: Joby Bednar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 3:13 PM
To: CF-Talk
Subject: CFQUERY question
I've got a field in a database that is a list of id numbers. When creating
a query how do I say pull all records that have an id of "whatever" in that
list? I don't want to use CONTAINS since the id could be "1" and any number
with "1" in it could return the record like "142,3,8,76".
Any thoughts?
Joby Bednar
Director of Internet Design
iNEOgroup.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists