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]
