We had the same problems in CF5 / Linux (Suse).
CF and Linux would not let you write a � into the db (or many other less usual
characters).
Always gave unclosed quotation error.
<CFQUERY>
INSERT INTO table
(column)
VALUES
('�')
</CFQUERY>
MM would or could not solve it there was only a workaround using <CFQUERYPARAM> (which
is not supported by all db's but thankfully ours does)
Allan
----- Original Message -----
From: Tim Blair
To: [EMAIL PROTECTED]
Sent: Wednesday, October 30, 2002 6:51 PM
Subject: [ cf-dev ] MX/Linux character query
Morning all,
We've just had a problem with a site we're moving for a client from
CF5/Windows -> CFMX/Linux (developed by A.N. Other). One of the scripts
just wasn't playing ball and we were getting tag validation errors,
saying that a <CFIF> tag had not been closed.
If turned out that this script sends a mail containing a UK pound (=A3)
sign and for some reason that symbol was making CF bomb out. It must be
something to do with the linux implementation because it's been working
fine on Windows. Problem was solved by using a chr() call instead of
actually printing the symbol.
Anyone else found anything like this?
Tim.
-------------------------------------------------------
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
-------------------------------------------------------
rawnet ltd
Atrium Court
Bracknell [EMAIL PROTECTED]
Berkshire Tel : +44 (0) 1344 393 040
RG12 1BW, UK http://www.rawnet.com
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
