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
-------------------------------------------------------------

Reply via email to