I'd vote for avoiding any rewriting of code and enabling query output in the debugging information. You can see the text of the query that was dynamicallay created if you select Show Query Information (plus the time, etc) -- that's what that part of the debugging info is for! :)
Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Luis Lebron" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 3:32 PM Subject: Preview a query string > I am building a dynamic query that looks like this: > > <cfquery name= "GetList" datasource=#DataSource#> > Select * from contacts where 1 > > <cfif Form.company IS NOT "All"> > and company like '%#Form.company#%' > </cfif> > > <cfif Form.city IS NOT "All"> > and city like '%#Form.city#%' > </cfif> > > <cfif Form.state IS NOT "All"> > and state like '%#Form.state#%' > </cfif> > > </cfquery> > > > How can I print the actual query string so that I can check it's syntax? > > > > thanks, > > > Luis > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
