Try this: SELECT Subscribers.SubscriberID, Subscribers.EMail FROM (Subscribers INNER JOIN SubscriberAddress ON (Subscribers.SubscriberID = SubscriberAddress.ASubscriberID)) WHERE SubscriberAddress.state IN (<cfqueryparam value="#FORM.EmailState#" cfsqltype="CF_SQL_VARCHAR" separator="," list="Yes">)
> -----Original Message----- > From: Tony Gruen [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 1:50 AM > To: CF-Talk > Subject: Use a list in where clause? > > > Dear listmembers, > Help. Sorry for the possible OT (it's a CF site) but I'm > really stuck. I > have an issue between SQL syntax and whether or not to use a list or > straight form value in the query. I have not been able to get > it working > either way so far. > > I have a form that submits to an action page. the form has a multiple > select for states. The value carried when multiple are > selected is like > this CA,AR,AK etc. This field is named 'EmailState' on the > form. On the > action page I want to select entries from tables where > addresses are in > the states selected. > > My membership (IN) filter is not returning the desired values...but I > was certain it was correct (below). Also, should I put this > into a list > before using it in the query? I would greatly appreciate any fresh > thoughts or input. Here is my query, the database is SQL > Server 2000 and > CF5. > > SELECT Subscribers.SubscriberID, Subscribers.EMail > FROM (Subscribers INNER JOIN SubscriberAddress ON > (Subscribers.SubscriberID = SubscriberAddress.ASubscriberID)) > WHERE SubscriberAddress.state IN ('#FORM.EmailState#') > > Best Regards, > Tony Gruen > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
