Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
annamjmi #1
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 query.
Anyways the variable I have for TownList =
'Williamstown','Clarksburg','Florida','North Adams' I have a query that I wish
to pull all the data out, but what is happening is that my single quote is
double once I enter the code in my query. I know there is some quick fix, but I
can't remember what it is. Any suggestions.
Here is my query:
<cfquery name="GetForeclosures" datasource="#request.Datasource#">
SELECT *
FROM #request.HomeTable#
WHERE Town in ('#TownList#')
</cfquery>
What my query outputs when run looks like this:
SELECT *
FROM tbl_homes
WHERE City in (''Williamstown'',''Clarksburg'',''Florida'',''Nor th Adams'')
See my single quotes are now double.
annamjmi Guest
-
PARSING A QUERY OF QUERY WITH A VARIABLE VALUE
On my first page the user selects a project. I am using the variable SelectedProject: <cfset SelectedProject =... -
CF7 query update with single quote
Hi i'm migrating an application from CF5 to CF7 (hotfix3) and have the following problem: the query <cfquery...> UPDATE t1 SET f1 = '#var1#'... -
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=' " &... -
Query of Query with single quote (')
I have a query object with a last name column. We use query of query against the object. When there's a record with a last name that has a... -
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 #2 Re: Variable double quoting in SQL query when should besingle quote
Sorry, typo
PreserveSingleQuotes - missed an R
ie. WHERE Town in (#PreserveSingleQuotes(TownList)#)
Zoe
zoeski80 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
