9645 REGEX replacements made. Nice.
-----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 07 September 2004 15:27 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned] 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] -- 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]
