Re: Building and saving a query string

2003-01-10 Thread Jann VanOver
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

2003-01-09 Thread Luis Lebron
[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

Re: Building and saving a query string

2003-01-08 Thread John Paul Ashenfelter
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 StripCR as a start. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message -