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
[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
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 -
3 matches
Mail list logo