Re: Building and saving a query string

Remove ALL extra characters using cfsetting enablecfoutputonly=yes and then put cfoutput/cfoutput around all characters you want to keep, like this... cfsetting enablecfoutputonly=yes cfsavecontent variable=myquery cfoutputSelect * from contacts where 1 /cfoutput cfif Form.company IS NOT

RE: Building and saving a query string

[mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 4:20 PM To: CF-Talk Subject: Re: Building and saving a query string Lots of options: 1) StripCR() CF function 2) Regex for stripping extra CR/LF/spaces 3) database functions for text processing 4) search/replace in either cf or db. I'd try

Building and saving a query string

I'm using the following code to build and display a query string:\ cfsavecontent variable=myquery Select * from contacts where 1 cfif Form.company IS NOT Alland company like '%cfoutput#Form.company#/cfoutput%'/cfif cfif Form.title IS NOT Alland title like '%cfoutput#Form.title#/cfoutput%'/cfif

Re: Building and saving a query string

: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 4:49 PM Subject: Building and saving a query string I'm using the following code to build and display a query string:\ cfsavecontent variable=myquery Select * from contacts where 1 cfif Form.company