Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
zoeski80 #1
Re: Variable double quoting in SQL query when should besingle quote
Hi Anna
Try using the PreseveSingleQuotes function.
ie. WHERE Town in ('#PreseveSingleQuotes(TownList)#')
HTH
Zoe
zoeski80 Guest
-
MX7 Double Quote
I just upgraded to MX7. CFQUERY using where x = "sam" used to work & now the double quotes are being treated as escape characters. I don't want... -
CF double quoting my single quotes in query string
I'm building my query string on the fly. So I have something like this: <cfset szQuery = "SELECT id FROM tblFoo WHERE id=' " &... -
Variable doube quoting in SQL query when should besingle quote
I have a list I created and keep as a variable. This list is dynamic so there is no way I can hard code this. So, the variable MUST work in my... -
INSERT with double quote?
If I wanted to insert/update a field with data like this: "This is my data" How would I go about doing that? I have found that I can escape... -
Double quote issue.
change execute.program = "c:\run.bat -var1='"& var1 &"' -var2='"& var2 &"'" to execute.program="c:\run.bat -var1=""" & var1 & """ -var2=""" &... -
annamjmi #2 Re: Variable double quoting in SQL query when should besingle quote
Thank you so much!!!!
annamjmi Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
