or you could use the IN keyword.
WHERE
EmployeeID IN (#FORM.EmployeeID#)
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 5:28 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Select List
On 8/2/00, Olson, Kelly penned:
>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in =
>query expression 'EmployeeID=3D107,24'.
I'm not sure if that 3D is part of the value you inputted from the
form or mime output from your e-mail.
But, if your EmployeeID field is an integer, you'll get that error if
any non numeric characters are in there, including the comma. Not
that that matters, you can't query with a list like that anyway.
You'll need to loop through it.
WHERE EmployeeID = #mylist#
or 0=1
Which would basically write:
WHERE EmployeeID = 107
or EmployeeID = 24
or 0=1
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
