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]
