The solution should still work with the latest version of mySQL. mySQL ahs
support for stored procedures and the coalesce function.
You will need however, CF 7 with the Hot Fix 1 that re-enables the use of
directly mapping stored procedure named paramaters.
Teddy
On 2/2/07, Anthony Mathis <[EMAIL PROTECTED]> wrote:
mysql
On Fri, 2007-02-02 at 11:57 -0500, Teddy Payne wrote:
> 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 FusionLink
> -------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------