Anthony: If you have three columns that you want to query on you, can do the following:
<cfcomponent>
<cffunction name="myFunction" access="public" returntype="string">
<cfargument name="myArgument1" type="string" required="yes">
<cfargument name="myArgument2" type="string" required="yes">
<cfargument name="myArgument3" type="string" required="yes">
<cfset myResult="foo">
<cfquery name="qFoo" datasource="datasource">
select *
from fooTable
where 1=1
and column1 = '%myArgument1%'
and column2 = '%myArgument2%'
and column3 = '%myArgument3%'
</cfquery>
<!--- or you could do: (this avoids wild cards) --->
<cfquery name="qFoo" datasource="datasource">
select *
from fooTable
where 1=1
<cfif len(trim(myArgument1))> and column1 = 'myArgument1'</cfif>
<cfif len(trim(myArgument2))> and column2 = 'myArgument2'</cfif>
<cfif len(trim(myArgument3))> and column3 = 'myArgument3'</cfif>
</cfquery>
<cfreturn myResult>
</cffunction>
</cfcomponent>
Sincerely,
Brooks Wilson
Try not to become a man of success but rather to become a man of value. -
Albert Einstein (1879-1955)
Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta
Georgia 30309-4470
404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED]
Anthony Mathis <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/02/2007 11:39 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
[ACFUG Discuss] CFC and reuse query
I'm looking for a solution to reusing a query in a cfc where the "where
clause needs to change.
example:
<cfquery name="qry" datasource="#APPLICATION.dsn#">
select * from table
where #field# = #value#
</cfquery>
How would I pass the info from my cfm to the cfc and continue to run the
same query from the same cfm using different values for #field# and
#value#? Can this be done?
thanks,
Anthony
-------------------------------------------------------------
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
------------------------------------
gifiw2BpMaG9m.gif
Description: GIF image
