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 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
