Well that's another great thing about SQL server, UDF's, makes generating dynamic SQL in an SP much easier, just write a UDF to do it.
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 07 September 2004 16:18 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned] > > Better security, faster processing to name but a few ;-) but > yeah I see your point...never liked Dynamic SQL in an SP. > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 07 September 2004 15:52 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned] > > No. dynamic SQL (column names, table owners etc). > > Can be done, but sod that. Why make life difficult? > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 07 September 2004 15:44 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned] > > Yeah and go full hog....rewrite the whole thing in SP's.... > > > > -----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] > 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] > > > > > -- > 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] > > -- 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]
