Don't forget to make a back up before you try it... ;o)
Rich Wild wrote:
Good.
Ta.
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 15:27
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned]
No, the Native format attribute works across both datatypes. (and
others)..it should be fine....give it a test....go on ... ;-)
-----Original Message-----
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 15:22
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned]
Possibly - depends.
Some columns are nvarchar and some are normal varchar.
If I regex every instance of
<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR".....
To
N'#myVariable#'
Will be standard (non multilingual) content blow up?
Ie, will a normal varchar column blow up when a N'' command is used?
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 15:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned]
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]
