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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4