Hi all,
I do not know what keywords I could use to investigate this in the archives, so
I'll describe the issue and hopefully you'll be able to tell be if this topic
has been covered before.
I'm querying a DB and, if a record is found, I'm inserting that information
(slightly edited) as a new record. For the insert part, I have this:
INSERT INTO TableName_tb
(memo)
VALUES
('#getRecord_qry.memo#')
....where getRecord_qry is the name of the initial query where I got the record
from.
My issue is the following: if that memo field includes an apostrophe, that will
confuse CF during the INSERT process and I get this error: "Syntax error
(missing operator) in query expression" and then it quotes the first 255
characters in my memo field, including the offending quote. The error message
disappears if I get rid of the apostrophe manually.
I have used SELECT before to get that same record from that same table and
display it on the screen, and that works fine (apostrophe included). I can use
an input box and type single quotes as I enter information, and that works fine
too. But when the result of the query is placed directly in an INSERT
statement, the apostrophe seems to be a problem (and I'm wondering now how many
other characters could also throw a similar error).
Except using a replace function to get rid of the apostrophes (I'd need to copy
the memo field as is, apostrophes and all), what else could I do to maybe
format the "memo" string, encode it, whatever, to be used in an INSERT
statement?
Thanks in advance,
Roberto
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308261
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
