if memory serves, you'll want a query param for each of the values in the
in statement, something like:
<cfset list = "203,1967">
SELECT *
FROM table
WHERE VALUE IN (
<cfloop index="i" list="#theList#">
<cfqueryparam value="i" cfsqltype="CF_SQL_INTEGER">,
</cfloop>
)
At 03:15 PM 11/1/2002 -0500, you wrote:
>I have a query that I had been just comparing one value so I could use a
>cfqueryparam of varchar, now that same variables may be passing something
>like 203,197 meaning that a sales rep belongs to each of those groups. So I
>need to change my query to something IN ('203','197') , but cfqueryparam
>doesn't let me do this. Do I need to use something else besides cfqueryparam
>or is there a setting I am not seeing that will allow me to use cfqueryparam
>and this?
>
>Robert Everland III
>Web Developer Extraordinaire
>Dixon Ticonderoga Company
>http://www.dixonusa.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
