Ask a Question related to Coldfusion Database Access, Design and Development.
-
DGH #1
Re: MS Access driver not escaping single quotes?
I was eventually able to 'solve' this problem by breaking my complicated page
into several simpler ones. Even removing chunks of cf tags _after_ the query
helped. Somehow, it was related to the sheer amount of parsable crap on the
page. I could just remove code starting at the bottom of the page, line by
line, until, miraculously, the query ( in its isolated loop far above) started
inserting correctly. I'd then add the code back, or add unrelated code to the
end of the template, and the insert would bomb again. Indicates some kind of
parsing problem to my mind, but I don't have the time or know-how to analyze it
further. Perhaps this will provide someone else a clue to a seemingly
unrelated problem.
DGH Guest
-
Bug: Escaping of single-quotes in cfQuery !
Attached code for better layout: CF automatically escapes single-quotes when outputtting values in queries. (Reason: Preventing of... -
cfquery not escaping single quotes correctly
It seems as if two single quotes together do not get escaped. <!--- This code works in CF5 with the proper Data OK message. It does not work on... -
Escaping nasty quotes
I have this: $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; $result... -
[PHP] Escaping nasty quotes
$query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; {/snip] try ... ... -
Escaping single quotes
"Bruce A. Black" <bruceablk@ida.net> wrote in message news:3f2603af_2@newsfeed... Use stripslashes() on your text field before submitting....



Reply With Quote

