Return to Answer

Post Timeline

Expanded cf. Added link to ColdFusion [Wikipedia]. Minor edit: grammar/spelling/case/punctation/etc.

Source Link

edited Jan 23, 2010 at 16:53

31.2k
22
110
134

in cfIn ColdFusion we just do:

<cfset myvalues = "ruby|rails|scruffy|rubyonrails">
    <cfquery name="q">
        select * from sometable where values in <cfqueryparam value="#myvalues#" list="true">
    </cfquery>

in cf we just do:

<cfset myvalues = "ruby|rails|scruffy|rubyonrails">
<cfquery name="q">
select * from sometable where values in <cfqueryparam value="#myvalues#" list="true">
</cfquery>

In ColdFusion we just do:

<cfset myvalues = "ruby|rails|scruffy|rubyonrails">
    <cfquery name="q">
        select * from sometable where values in <cfqueryparam value="#myvalues#" list="true">
    </cfquery>

Source Link

answered Dec 10, 2008 at 21:54

rip747

9.4k
8
41
49

in cf we just do:

<cfset myvalues = "ruby|rails|scruffy|rubyonrails">
<cfquery name="q">
select * from sometable where values in <cfqueryparam value="#myvalues#" list="true">
</cfquery>

Collectives™ on Stack Overflow