Re: Preview a query string

2003-01-08 Thread Paul Giesenhagen
Remove the cfquery /cfquery tags and put an output around it... Paul Giesenhagen QuillDesign - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 2:32 PM Subject: Preview a query string I am building a dynamic query

Re: Preview a query string

2003-01-08 Thread Jeff Garza
Comment out your CFQUERY/CFQUERY tags and replace with CFOUTPUT/CFOUTPUT HTH, Jeff - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 1:32 PM Subject: Preview a query string I am building a dynamic query that looks

RE: Preview a query string

2003-01-08 Thread Everett, Al
Build the whole thing first: cfsavecontent variable=myquery 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

RE: Preview a query string

2003-01-08 Thread Everett, Al
Remove the cfquery /cfquery tags and put an output around it... Or, you know, like, take the easy route. (Too much blood in my caffeine stream I guess.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: Preview a query string

2003-01-08 Thread John Paul Ashenfelter
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

RE: Preview a query string

2003-01-08 Thread Luis Lebron
Thanks, this works. Luis -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 2:45 PM To: CF-Talk Subject: RE: Preview a query string Build the whole thing first: cfsavecontent variable=myquery Select * from contacts where 1