|
I'm with you Neil... change the code through
the life saver that is Regex:)
----- Original Message -----
Sent: Tuesday, September 07, 2004 3:16
PM
Subject: RE: [ cf-dev ] CFQUERYPARAM and
multilingual sites
Sounds like a job for a RegEx GREP....
-----Original Message-----
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 07 September 2004
15:12
To: [EMAIL PROTECTED]
Subject:
[ cf-dev ] CFQUERYPARAM and multilingual sites
Hello all.
Ok,
this harks back to the thread we had a while back about using the N
prefix
in front of nvarchar, nchar or ntext columns in SQL statements to
insert
special language characters such as umlauts etc.
That's all great, but
now joy of joys I've inherited another site that
is supposed to be
multilingual (and hence has to support special
characters) but which uses
<CFQUERYPARAM> all the way through the site.
Now as far as I can
see, <CFQUERYPARAM> doesn't have nvarchar settings.
So, I thinks,
this should be easy to fix still. In my sql code in CF,
I'll just replace
every instance of:
<CFQUERYPARAM
CFSQLTYPE="CF_SQL_VARCHAR".....
Etc to the
following:
N<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"....
(ie
just with a preceeding N)
Does this work?
Do you really think
things would be so easy? Good grief man! Are you not
a CF developer? Do
things ever work easily?
No, it appears that <CFQUERYPARAM>
inserts a space just before the
'VARCHAR DATA' it creates, so my resulting
T-SQL is:
N 'VARCHAR DATA' and not N'VARCHAR DATA' as it should
be.
Deep sigh...
Can anyone figure out a fudge for this, or do I
have to replace every
instance of cfqueryparam in the site? It's a massive
sprawling site and
it'll take me completely ages. DAYS.
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive:
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper
Sponsors and contributors:-
*Hosting and support provided by
CFMXhosting.co.uk* :: *ActivePDF provided
by
activepdf.com*
*Forums provided by
fusetalk.com* :: *ProWorkFlow provided
by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted
by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
This
e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond,
Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered
in England, Number 678540. It contains information which
is
confidential and may also be privileged. It is for the exclusive
use of the
intended recipient(s). If you are not the intended
recipient(s) please note
that any form of distribution, copying or use of
this communication or the
information in it is strictly prohibited and may
be unlawful. If you have
received this communication in error please
return it to the sender or call
our switchboard on +44 (0) 20
89107910. The opinions expressed within this
communication are not
necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
--
These
lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive:
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper
Sponsors and contributors:-
*Hosting and support provided by
CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by
fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
|
