Dave:
You can put whatever you like into an Access Memo field with CFQUERY. It's
very simple: do NOT use preservesinglequotes() on the text you want to
insert.
Explanation: single quotes will automatically be escaped (that is, replaced
inline by two single quotes) by CFQUERY -- you don't have to do anything.
If you must wrap your data values in something, use the CFQUERYPARAM tag.
Never use preservesinglequotes() on the VALUE of a database text field
inside CFQUERY -- use it only to protect single quotes in lines of SQL code.
In my experience, special characters (single & double quotes, curly quotes,
accented characters, & / \ < > etc.) often cause trouble elsewhere in
applications, but inserting / updating / selecting text fields containing
these characters from an Access database is the easy part.
-- Laurence
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dave Boehm
Sent: Wednesday, May 15, 2002 8:50 AM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] More on the memo field problem
OK. Now I'm more confused but somewhat enlightened. Over the past couple of
days I've posted a few questions about being unable to save a memo field
without being truncated at 255 characters. A number of people have said I
can't use special characters in the field (what good is it if you can't save
single and double quotes and other punctuation in the memo field). I have
the sql enclosed in a preservesinglequotes function and it still won't work.
Here is something interesting that I've found.
I changed the contents of the memo field to be straight text without any
quotes (or so I thought) and it worked! Then I looked more closely and found
that I had left one single quote in. So I added some more single quotes and
it stopped working again. I then noticed that the single quote that worked
was actually a curly quote (ALT-0146) and the quotes that killed it were the
"foot marks" quotes.
So I am a little closer but still not a happy camper. If I can't save foot
or inch marks in a memo field, the field type is pretty much useless. I know
the Access field can accept these marks but somewhere between ColdFusion and
the database something is not right.
Anyone with any further thoughts on this please respond, especially if you
are from Macromedia. If you need to see the previous posts where I include
the code, respond to me and I will send them off to you.
Thanks to everyone who has tried to help so far.
David Boehm
M&T Printing Group
907 Frederick St.
Kitchener, ON
N2B 2B9
(519) 571-0101
[EMAIL PROTECTED]
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Laurence Middleton" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
