When you get to your where clause you can do something like a loop over
parameters if you need to...let's say for instance you have something like this:
<cfset aStruct = StructNew()>
<cfset aStruct.columnNameA = "100">
<cfset aStruct.columnNameB = "SomeValue">
<cfquery ...>
SELECT * FROM Blah
WHERE
<cfloop collection="#aStruct#" item="key">
#key# = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#aStruct[key]#">
</cfloop>
</cfquery>
Granted, this is just a sample...
Allen
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Stell
Sent: Wednesday, August 01, 2007 11:18 AM
To: [email protected]
Subject: [ACFUG Discuss] CFQueryParam
Does anyone know if CFQueryParam is offered in a function version?
Im trying to build out a dynamic query string and then use that for the where
clause...
Thanks!
Charlie
-------------------------------------------------------------
Annual Sponsor - Figleaf Software <http://www.figleaf.com>
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
