What database are you using?
Teddy
On 2/2/07, Anthony Mathis <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------
--
Teddy R. Payne
G-Talk: [EMAIL PROTECTED]
Adobe Certified ColdFusion MX 7 Developer
Atlanta ColdFusion User Group (ACFUG)
Atlanta Flash & Flex User Group (AFFUG)
-------------------------------------------------------------
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
-------------------------------------------------------------