[ cf-dev ] umlauts and cfmx
Hmm, me again with my multilingual stuff, its tedious I know, sorry. Im having a problem with umlauts ΓΌ I have a form field that I insert foreign characters into. Now into this I can insert anything. On my action page in my SQL statements Im using the N prefix around my columns to protect these characters from being translated and it all works fine, the doppel-S symbol, accented chars, even Chinese all go through fine but for some reason, everytime I try and umlauted u, it saves it as ue, no matter what I try. Any ideas?
RE: [ cf-dev ] umlauts and cfmx[Scanned]
I'm going to take a stick to your head. Any ideas? Get a real database like mySQL, rather than these cheap solutions like MS SQL Server. Never had any bother with mySQL ;oD -- 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]
RE: [ cf-dev ] umlauts and cfmx[Scanned]
Bit of clarification on this - this is NOT a database issue. I'm dumping the variable *before* it gets to the database and its already been converted to 'ue'. Now, I've tried cfset setEncoding(form, utf-8) to no avail. If it helps, the update is being performed by a CFC (shouldn't make any difference though...) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 10:56 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] umlauts and cfmx[Scanned] I'm going to take a stick to your head. Any ideas? Get a real database like mySQL, rather than these cheap solutions like MS SQL Server. Never had any bother with mySQL ;oD -- 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]
RE: [ cf-dev ] umlauts and cfmx[Scanned]
Interestingly, the debug info from the cf server displays the character properly, but a cfdump shows that the char has been converted. Hm. Something fishy is afoot here -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 11:08 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] umlauts and cfmx[Scanned] Rich Wild wrote: Bit of clarification on this - this is NOT a database issue. I'm dumping the variable *before* it gets to the database and its already been converted to 'ue'. Now, I've tried cfset setEncoding(form, utf-8) to no avail. If it helps, the update is being performed by a CFC (shouldn't make any difference though...) heh - sorry about before. Its not browser/os related is it? I can't see it being CF, as I'm pretty certain the app I've got international characters going through doesn't do anything special and has umlauts dotted about. -- 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]
RE: [ cf-dev ] umlauts and cfmx[Scanned]
No - it's a simple type an umlaut into a form field, display on next page. I'm checking to see if some complete bozo has edited formurl2attributes.cfm to do something crazy, but its only happening on umlauts. Every other special char is absolutely fine. Its bizarre... -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 11:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] umlauts and cfmx[Scanned] Hm. Something fishy is afoot here You're not doing anything like writing the text to file and then reading it back in again are you? CFMX has real issues writing out UTF-8 encoded text files (i.e. it can't do it). -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- 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]
RE: [ cf-dev ] umlauts and cfmx[Scanned]
Hmmm. It appears is *is* formurl2attributes.cfm that's the culprit, but I can't see where in the code its doing it. It appears to be a standard copy. The pre-existing code was referencing attributes.myVar, which came back with the umlaut replaced. Switching to just form.myVar gave me the proper version. Does anyone know where it would be doing this? Fusebox + Wild = not see eye to eye. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 11:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] umlauts and cfmx[Scanned] No - it's a simple type an umlaut into a form field, display on next page. I'm checking to see if some complete bozo has edited formurl2attributes.cfm to do something crazy, but its only happening on umlauts. Every other special char is absolutely fine. Its bizarre... -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 11:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] umlauts and cfmx[Scanned] Hm. Something fishy is afoot here You're not doing anything like writing the text to file and then reading it back in again are you? CFMX has real issues writing out UTF-8 encoded text files (i.e. it can't do it). -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- 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] -- 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]
[ 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: NCFQUERYPARAM 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]
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: NCFQUERYPARAM 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]
RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned]
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 finegive it a testgo 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: NCFQUERYPARAM 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
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 hogrewrite 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 finegive it a testgo 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: NCFQUERYPARAM 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
RE: [ cf-dev ] CFQUERYPARAM and multilingual sites[Scanned]
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 finegive it a testgo 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: NCFQUERYPARAM 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]
RE: [ cf-dev ] OT: JS Bold first letter[Scanned]
You can't have more than one style on the contents of a form field.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 17 August 2004 11:58
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] OT: JS Bold first letter[Scanned]
Erm, don't think so, it's in a form field (more than one on the page)
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: 17 August 2004 11:52
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] OT: JS Bold first letter
Can you use css?
E.g.
style
p:first-letter {font-weight: bold;}
/style
/head
body
p
This is a test
/p
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 17 August 2004 11:47
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] OT: JS Bold first letter
Got a bit of a brain fuzz, anyone got any JS which will embolden the
first
letter of a string being typed into a text field?
N
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]
[ cf-dev ] Realchat and CFMX
I have a requirement to integrate the java-based Realchat chat server with CF. Has anyone done this before? Is it a case of issuing HTTP commands or is there an API I can hook into via createobject() etc Ta Rich
RE: [ cf-dev ] OT: Amazon affiliates[Scanned]
Yay - funjunkie-21 please. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 13:56 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Amazon affiliates[Scanned] Anyone here have an Amazon.co.uk affiliates account? I've got one on a personal site, and used to use it to put through my own transactions, bumping up my commissions. But they seem to have cottoned on to this and are now deducting the amount from my own sales. So does anyone else want to make a few pennies on their account? Gimme a URL or your affiliate ID and I'll go buy a couple CD's... -- 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]
RE: [ cf-dev ] OT: Amazon affiliates[Scanned]
Aye - will do - I post affiliate ids all the time in my forums - I'll add yours! Ta Duncan! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 14:15 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Amazon affiliates[Scanned] nice one, expect the monies in your affiliate account any time now. duncancumming-21 if you want to return the favour. Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: RE: [ cf-dev ] OT: Amazon affiliates[Scanned] 03/08/2004 13:58 Please respond to dev Yay - funjunkie-21 please. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 13:56 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Amazon affiliates[Scanned] Anyone here have an Amazon.co.uk affiliates account? I've got one on a personal site, and used to use it to put through my own transactions, bumping up my commissions. But they seem to have cottoned on to this and are now deducting the amount from my own sales. So does anyone else want to make a few pennies on their account? Gimme a URL or your affiliate ID and I'll go buy a couple CD's... -- 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] -- 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]
RE: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned]
I guess that shows the table generation script for that table? If so, you can generate scripts from enterprise manager. -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 17:15 To: [EMAIL PROTECTED] Subject: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned] mySQL has a great little SQL command SHOW CREATE TABLE 'tablename' Does SQL Server have an equivalent? Regards Stephen -- 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]
RE: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned]
Hmmm - not sure about that - but I do know that you can run various system stored procs against a table to retrieve the info There are loads like sp_help 'tablename' sp_helpconstraint 'tablename' sp_helpindex 'tablename' that return the kind of info you're requiring. -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 17:23 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned] Rich Wild wrote: I guess that shows the table generation script for that table? If so, you can generate scripts from enterprise manager. Yeah sorry - thats what it does. Unfortunately, I don't have access to the database from Enterprise manager, but I do have admin access via CF/ODBC, which is why I'm looking at SQL ways to get the info I need. I need to get the information about a table and any constraints that may be applied to that table, so that I can create a script to suck the structure and data out and then create a SQL script that can be applied to another server. Regards Stephen -- 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]
RE: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned]
Oops! - sp_help returns pretty much everything you need on its own. -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 17:23 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned] Rich Wild wrote: I guess that shows the table generation script for that table? If so, you can generate scripts from enterprise manager. Yeah sorry - thats what it does. Unfortunately, I don't have access to the database from Enterprise manager, but I do have admin access via CF/ODBC, which is why I'm looking at SQL ways to get the info I need. I need to get the information about a table and any constraints that may be applied to that table, so that I can create a script to suck the structure and data out and then create a SQL script that can be applied to another server. Regards Stephen -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Cheers Gene, yea that works for me too.
Problem is, I'm worried about having Polish as the database default when I'm not just
storing Polish content, I'm storing X number of other languages as well.
Its strange we have a database containing Chinese characters using a Latin collation,
both as database default AND column collation.
I can't figure it out.
-Original Message-
From: Gene Brown [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:52
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Rich,
What collation did you select when creating the database?
I have just been through your process, selecting polish_CS_AS_KS_WS as the
collation for the database.
The queries then work with the correct characters being added and retrieved
from the db.
Cheers
Gene
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:03
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Ok - I did the following:
New database
New table ('test' - columns: line_id NUMERIC IDENTITY, content NTEXT)
INSERT INTO test(content)
VALUES('Znajd Pastwo Zachcamy')
SELECT content FROM test
Results: ' Znajda Panstwo Zachecamy ' (ie, lost all the special chars.)
This was all in Query Analyser.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:44
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Have u tried, make a new database, create a new table, set the coalition and
ntext, try the insert..
At least u will know if it's just that database being silly then.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:31
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Via query analyzer I can insert Chinese text into the first
table, but not the second (well, it goes in, but it doesn't
come out chinese)
Both columns are ntext, default collation
Both collations are the same for both databases.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:27
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Can u insert the same text into both database via query
analyser? Or does it only fail on the polish one.
Check the coalition setting of the DATABASE properties for
both databases (not just the tables) and see what the default
is set to.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - more information.
I have 2 databases on the *same* sql server.
One has a table with an ntext column, default collation,
that contains
Chinese characters
The other has a table with an ntext column, default collation. Ie
identical.
How come one can contain Chinese characters, but when (in Query
Analyser, so not through CF at all) I insert those
characters (through
a cut and pasting from a select on the chinese table) into my other
column, and then select, I get nothing out but gibberish characters?
I'm very confused. They *can't* be identical! There must be
something
different between the two.
Just what the hell is it?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:42
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Thanks Mark.
Nothing really there that's resolved the issue, but I
appreciate it,
ta.
This is weird. I've discovered another app here developed before I
arrived that sends out Chinese character emails. The
collation on that
table is the default (latin), but the datasource is configured for
non-western alphabet. I've restored the collation on my
table to the
same (database default - latin) but still no dice.
It'd be fine if I wasn't racing deadlines. Gah.
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:28
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Weird
The only other time I have had trouble with SQl Server and
languages
is when character sets used within SQL Server were playing up.
This caused me a big problem a couple of years ago with SQL
Server 7,
but I thought it was resolved with 2000.
That's the only other thing which springs to mind Mark
http://www.databasejournal.com/features/mssql/article.phpr/1587631
This article talks about the problem I encountered, but
also mentions
collation at column level
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:20
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
You'll all be overjoyed no doubt to learn that I've discovered the problem.
So for those of you interested:
On my insert, in the SQL syntax, rather than
INSERT INTO dbTable(content)
VALUES('#content#')
It should be:
INSERT INTO dbTable(content)
VALUES(N'#content#')
(Note the N)
I can't find any SQL BOL info on that - can anyone find it? I presume it tells SQL
Server to expect Unicode data and so not to perform any translation on the characters?
This means that the collation on the column and database can remain on my default
Latin (western European) and I can store whatever character set I like in there,
confusingly.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 09:36
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Cheers Gene, yea that works for me too.
Problem is, I'm worried about having Polish as the database default when I'm not just
storing Polish content, I'm storing X number of other languages as well.
Its strange we have a database containing Chinese characters using a Latin collation,
both as database default AND column collation.
I can't figure it out.
-Original Message-
From: Gene Brown [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:52
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Rich,
What collation did you select when creating the database?
I have just been through your process, selecting polish_CS_AS_KS_WS as the
collation for the database.
The queries then work with the correct characters being added and retrieved
from the db.
Cheers
Gene
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:03
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Ok - I did the following:
New database
New table ('test' - columns: line_id NUMERIC IDENTITY, content NTEXT)
INSERT INTO test(content)
VALUES('Znajd Pastwo Zachcamy')
SELECT content FROM test
Results: ' Znajda Panstwo Zachecamy ' (ie, lost all the special chars.)
This was all in Query Analyser.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:44
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Have u tried, make a new database, create a new table, set the coalition and
ntext, try the insert..
At least u will know if it's just that database being silly then.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:31
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Via query analyzer I can insert Chinese text into the first
table, but not the second (well, it goes in, but it doesn't
come out chinese)
Both columns are ntext, default collation
Both collations are the same for both databases.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:27
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Can u insert the same text into both database via query
analyser? Or does it only fail on the polish one.
Check the coalition setting of the DATABASE properties for
both databases (not just the tables) and see what the default
is set to.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - more information.
I have 2 databases on the *same* sql server.
One has a table with an ntext column, default collation,
that contains
Chinese characters
The other has a table with an ntext column, default collation. Ie
identical.
How come one can contain Chinese characters, but when (in Query
Analyser, so not through CF at all) I insert those
characters (through
a cut and pasting from a select on the chinese table) into my other
column, and then select, I get nothing out but gibberish characters?
I'm very confused. They *can't* be identical! There must be
something
different between the two.
Just what the hell is it?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:42
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Thanks Mark.
Nothing really there that's resolved the issue, but I
appreciate it,
ta.
This is weird. I've discovered another app here developed before I
arrived that sends out Chinese character emails. The
collation on that
table is the default (latin), but the datasource is configured for
non-western alphabet. I've restored the collation on my
table to the
same (database default - latin) but still no dice.
It'd be fine if I wasn't racing deadlines. Gah.
-Original Message-
From: Mark Smyth
[ cf-dev ] activedit and polish chars
Hi Guys, I've got a problem inputting polish characters into an activedit form. I have my application encoding set to utf-8, as well as the charset in HTML, but whenever I save the content to the database (ntext column type), all the special characters are replaces with standard european ones not sure if this will work, but here's an attempt at an example: for instance, 'Zachcamy' becomes 'Zachecamy' can anyone shed any light on this for me? Ta. Rich -- 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]
RE: [ cf-dev ] (not) activedit and polish chars
Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 13:57 To: [EMAIL PROTECTED] Subject: [ cf-dev ] activedit and polish chars[Scanned] Hi Guys, I've got a problem inputting polish characters into an activedit form. I have my application encoding set to utf-8, as well as the charset in HTML, but whenever I save the content to the database (ntext column type), all the special characters are replaces with standard european ones not sure if this will work, but here's an attempt at an example: for instance, 'Zachcamy' becomes 'Zachecamy' can anyone shed any light on this for me? Ta. Rich -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz Stephen -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - I think it may be the collection on that ntext column. The problem is that I need to store western European AND polish chars in the same column. Can I do this when using the polish collation? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz Stephen -- 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] -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - I think it may be the collection on that ntext column. Sorry, collation, not collection. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. The problem is that I need to store western European AND polish chars in the same column. Can I do this when using the polish collation? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz Stephen -- 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] -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - as a test I changed the collation on that column to SQL_polish_SP1250_CS_AS and to SQL_polish_SP1250_IS_AS Both failed to save the characters again... hmmm.. stumped... -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:45 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. Sorry, collation, not collection. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. The problem is that I need to store western European AND polish chars in the same column. Can I do this when using the polish collation? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz Stephen -- 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] -- 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] -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Discovered an option in the datasource in CFMX admin to Enable Unicode for data sources configured for non-Latin characters Did it work on my now polish collated columns? Nope. This is beginning to try my patience. I bet its something simple. Someone else out there must be storing non-western alphabet in sql server? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - as a test I changed the collation on that column to SQL_polish_SP1250_CS_AS and to SQL_polish_SP1250_IS_AS Both failed to save the characters again... hmmm.. stumped... -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:45 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. Sorry, collation, not collection. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. The problem is that I need to store western European AND polish chars in the same column. Can I do this when using the polish collation? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has cfset setEncoding(form, utf-8) in the application.cfm Hmmm. Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz Stephen -- 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] -- 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] -- 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
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
But I'm just using a simple cfquery to insert straight into the table and the column is ntext and the collation is now polish, and the datasource has been configured to use Unicode. I'm utterly stumped! -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] I've had this problem with chinese and sql server. It was the tmp table used in a stored procedure, the column in the tmp table was not ntext (so it was losing the formatting) within the stored procedure It's worth a look... Mark -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Someone else out there must be storing non-western alphabet in sql server? I do just not in SQL Server - it was dead simple with mySQL. All I had to do was add the following to the connection string. useUnicode=truecharacterEncoding=ISO8859_1 Everything worked without additional help after that. Stephen -- 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] -- 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]
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Thanks Mark. Nothing really there that's resolved the issue, but I appreciate it, ta. This is weird. I've discovered another app here developed before I arrived that sends out Chinese character emails. The collation on that table is the default (latin), but the datasource is configured for non-western alphabet. I've restored the collation on my table to the same (database default - latin) but still no dice. It'd be fine if I wasn't racing deadlines. Gah. -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Weird The only other time I have had trouble with SQl Server and languages is when character sets used within SQL Server were playing up. This caused me a big problem a couple of years ago with SQL Server 7, but I thought it was resolved with 2000. That's the only other thing which springs to mind Mark http://www.databasejournal.com/features/mssql/article.phpr/1587631 This article talks about the problem I encountered, but also mentions collation at column level -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] But I'm just using a simple cfquery to insert straight into the table and the column is ntext and the collation is now polish, and the datasource has been configured to use Unicode. I'm utterly stumped! -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] I've had this problem with chinese and sql server. It was the tmp table used in a stored procedure, the column in the tmp table was not ntext (so it was losing the formatting) within the stored procedure It's worth a look... Mark -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Someone else out there must be storing non-western alphabet in sql server? I do just not in SQL Server - it was dead simple with mySQL. All I had to do was add the following to the connection string. useUnicode=truecharacterEncoding=ISO8859_1 Everything worked without additional help after that. Stephen -- 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] -- 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] -- 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
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - more information. I have 2 databases on the *same* sql server. One has a table with an ntext column, default collation, that contains Chinese characters The other has a table with an ntext column, default collation. Ie identical. How come one can contain Chinese characters, but when (in Query Analyser, so not through CF at all) I insert those characters (through a cut and pasting from a select on the chinese table) into my other column, and then select, I get nothing out but gibberish characters? I'm very confused. They *can't* be identical! There must be something different between the two. Just what the hell is it? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:42 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Thanks Mark. Nothing really there that's resolved the issue, but I appreciate it, ta. This is weird. I've discovered another app here developed before I arrived that sends out Chinese character emails. The collation on that table is the default (latin), but the datasource is configured for non-western alphabet. I've restored the collation on my table to the same (database default - latin) but still no dice. It'd be fine if I wasn't racing deadlines. Gah. -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Weird The only other time I have had trouble with SQl Server and languages is when character sets used within SQL Server were playing up. This caused me a big problem a couple of years ago with SQL Server 7, but I thought it was resolved with 2000. That's the only other thing which springs to mind Mark http://www.databasejournal.com/features/mssql/article.phpr/1587631 This article talks about the problem I encountered, but also mentions collation at column level -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] But I'm just using a simple cfquery to insert straight into the table and the column is ntext and the collation is now polish, and the datasource has been configured to use Unicode. I'm utterly stumped! -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] I've had this problem with chinese and sql server. It was the tmp table used in a stored procedure, the column in the tmp table was not ntext (so it was losing the formatting) within the stored procedure It's worth a look... Mark -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Someone else out there must be storing non-western alphabet in sql server? I do just not in SQL Server - it was dead simple with mySQL. All I had to do was add the following to the connection string. useUnicode=truecharacterEncoding=ISO8859_1 Everything worked without additional help after that. Stephen -- 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] -- 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
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Via query analyzer I can insert Chinese text into the first table, but not the second (well, it goes in, but it doesn't come out chinese) Both columns are ntext, default collation Both collations are the same for both databases. -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:27 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Can u insert the same text into both database via query analyser? Or does it only fail on the polish one. Check the coalition setting of the DATABASE properties for both databases (not just the tables) and see what the default is set to. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - more information. I have 2 databases on the *same* sql server. One has a table with an ntext column, default collation, that contains Chinese characters The other has a table with an ntext column, default collation. Ie identical. How come one can contain Chinese characters, but when (in Query Analyser, so not through CF at all) I insert those characters (through a cut and pasting from a select on the chinese table) into my other column, and then select, I get nothing out but gibberish characters? I'm very confused. They *can't* be identical! There must be something different between the two. Just what the hell is it? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:42 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Thanks Mark. Nothing really there that's resolved the issue, but I appreciate it, ta. This is weird. I've discovered another app here developed before I arrived that sends out Chinese character emails. The collation on that table is the default (latin), but the datasource is configured for non-western alphabet. I've restored the collation on my table to the same (database default - latin) but still no dice. It'd be fine if I wasn't racing deadlines. Gah. -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Weird The only other time I have had trouble with SQl Server and languages is when character sets used within SQL Server were playing up. This caused me a big problem a couple of years ago with SQL Server 7, but I thought it was resolved with 2000. That's the only other thing which springs to mind Mark http://www.databasejournal.com/features/mssql/article.phpr/1587631 This article talks about the problem I encountered, but also mentions collation at column level -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] But I'm just using a simple cfquery to insert straight into the table and the column is ntext and the collation is now polish, and the datasource has been configured to use Unicode. I'm utterly stumped! -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] I've had this problem with chinese and sql server. It was the tmp table used in a stored procedure, the column in the tmp table was not ntext (so it was losing the formatting) within the stored procedure It's worth a look... Mark -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Someone else out there must be storing non-western alphabet in sql server? I do just not in SQL Server - it was dead simple with mySQL. All I had to do was add the following to the connection string. useUnicode=truecharacterEncoding=ISO8859_1 Everything worked without additional help after that. Stephen -- 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
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Ok - I did the following:
New database
New table ('test' - columns: line_id NUMERIC IDENTITY, content NTEXT)
INSERT INTO test(content)
VALUES('Znajd Pastwo Zachcamy')
SELECT content FROM test
Results: ' Znajda Panstwo Zachecamy ' (ie, lost all the special chars.)
This was all in Query Analyser.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:44
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Have u tried, make a new database, create a new table, set the coalition and
ntext, try the insert..
At least u will know if it's just that database being silly then.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:31
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Via query analyzer I can insert Chinese text into the first
table, but not the second (well, it goes in, but it doesn't
come out chinese)
Both columns are ntext, default collation
Both collations are the same for both databases.
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:27
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Can u insert the same text into both database via query
analyser? Or does it only fail on the polish one.
Check the coalition setting of the DATABASE properties for
both databases (not just the tables) and see what the default
is set to.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Hmmm - more information.
I have 2 databases on the *same* sql server.
One has a table with an ntext column, default collation,
that contains
Chinese characters
The other has a table with an ntext column, default collation. Ie
identical.
How come one can contain Chinese characters, but when (in Query
Analyser, so not through CF at all) I insert those
characters (through
a cut and pasting from a select on the chinese table) into my other
column, and then select, I get nothing out but gibberish characters?
I'm very confused. They *can't* be identical! There must be
something
different between the two.
Just what the hell is it?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:42
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Thanks Mark.
Nothing really there that's resolved the issue, but I
appreciate it,
ta.
This is weird. I've discovered another app here developed before I
arrived that sends out Chinese character emails. The
collation on that
table is the default (latin), but the datasource is configured for
non-western alphabet. I've restored the collation on my
table to the
same (database default - latin) but still no dice.
It'd be fine if I wasn't racing deadlines. Gah.
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:28
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
Weird
The only other time I have had trouble with SQl Server and
languages
is when character sets used within SQL Server were playing up.
This caused me a big problem a couple of years ago with SQL
Server 7,
but I thought it was resolved with 2000.
That's the only other thing which springs to mind Mark
http://www.databasejournal.com/features/mssql/article.phpr/1587631
This article talks about the problem I encountered, but
also mentions
collation at column level
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:20
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
But I'm just using a simple cfquery to insert straight into
the table
and the column is ntext and the collation is now polish, and the
datasource has been configured to use Unicode.
I'm utterly stumped!
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:16
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
I've had this problem with chinese and sql server.
It was the tmp table used in a stored procedure, the column
in the tmp
table was not ntext (so it was losing the formatting) within the
stored procedure
It's worth a look...
Mark
-Original Message-
From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:00
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned]
Someone else out there must be storing non-western alphabet in sql
RE: [ cf-dev ] cfform[Scanned]
Yup.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:56
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cfform[Scanned]
Are you sure you've got the fields 'revision' and 'EditComments' in your
form, with the same-case spelling?
Your bit of script chkRevision should ideally be in the head of your
document, not just above the form.
Rich Wild
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
group.com cc:
Subject: [
cf-dev ] cfform
29/06/2004 14:47
Please respond to dev
Yuck. I've inherited code which I'm debugging and it all uses cfform, a
personal peeve of mine.
Now, perhaps its because I came back from Glastonbury yesterday and so
am a
little bit mental, but I'm trying to get this cfform to fire off a
validation script on submit.
So I've added the onsubmit parameter to the cfform call like thus:
cfform action=index.cfm?fuseaction=act_itemstepsstep=1 method=POST
name=itemFrm enctype=multipart/form-data onsubmit=return
chkRevision
();
And I have the following function declared just above it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure
that
you have completed the \'Edit Comments\' field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a Object Not Found
error
when run at the browser on this line (which is obviously created by
cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title,
_CF_this.title.value, Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would* dearly love to turn the whole form into a normal form,
but
there's a lot of work required (large form) to do that and this is a
quick
fix, very unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
--
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]
RE: [ cf-dev ] cfform[Scanned]
Your bit of script chkRevision should ideally be in the head of your
document, not just above the form.
Why? I've never experienced this before. You can have a script wherever
you like.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:57
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] cfform[Scanned]
Yup.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:56
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cfform[Scanned]
Are you sure you've got the fields 'revision' and 'EditComments' in your
form, with the same-case spelling?
Your bit of script chkRevision should ideally be in the head of your
document, not just above the form.
Rich Wild
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
group.com cc:
Subject: [
cf-dev ] cfform
29/06/2004 14:47
Please respond to dev
Yuck. I've inherited code which I'm debugging and it all uses cfform, a
personal peeve of mine.
Now, perhaps its because I came back from Glastonbury yesterday and so
am a
little bit mental, but I'm trying to get this cfform to fire off a
validation script on submit.
So I've added the onsubmit parameter to the cfform call like thus:
cfform action=index.cfm?fuseaction=act_itemstepsstep=1 method=POST
name=itemFrm enctype=multipart/form-data onsubmit=return
chkRevision
();
And I have the following function declared just above it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure
that
you have completed the \'Edit Comments\' field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a Object Not Found
error
when run at the browser on this line (which is obviously created by
cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title,
_CF_this.title.value, Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would* dearly love to turn the whole form into a normal form,
but
there's a lot of work required (large form) to do that and this is a
quick
fix, very unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
--
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]
--
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]
RE: [ cf-dev ] cfform[Scanned]
Title: Message
Thanks Mark, I agree but how can I
stop this happening and actually get cfform to kick off an extra custom
validation (ie mine) after *its*
finished?
From: Mark Smyth
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:10
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
I think its the onsubmit Rich
When cfform creates the _javascript_
isinitiates the validation by dynamically adding an onsubmit
so what you'd end up with in the browser
is something like
FORM NAME=itemFrm
ACTION=""
METHOD=POST _CF_checkitemFrm(this)
ENCTYPE=multipart/form-data
its basically overwritting your onsubmit, or it
sounds like they might even be conflicting
hth
mark
-Original Message-----
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:48
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] cfform
Yuck. I've inherited code which I'm debugging and it
all uses cfform, a personal peeve of mine.
Now, perhaps its because I came back from Glastonbury
yesterday and so am a little bit mental, but I'm trying to get this cfform to
fire off a validation script on submit.
So I've added the onsubmit parameter to the cfform
call like thus:
cfform
action=""
method=POST name=itemFrm
enctype=multipart/form-data
chkRevision();
And I have the following function declared just above
it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure that you have completed the \'Edit Comments\'
field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a
Object Not Found error when run at the browser on this line (which is obviously
created by cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title, _CF_this.title.value,
Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would*
dearly love to turn the whole form into a normal form, but there's a lot of
work required (large form) to do that and this is a quick fix, very
unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
RE: [ cf-dev ] cfform[Scanned]
Ok, you're talking stylistic sense and I agree, but with respect, it's a
bit academic in this instance, and nothing to do with why the JS is
kicking off an Object Expected error.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:12
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] cfform[Scanned]
you're usually better to have Javascript functions in the head of your
document, so that they load in before the page starts to render. If
it's
stuff where you actually want to use Javascript to render the content
(e.g.
with some document.writeln commands), then obviously that should be in
the
document body.
Rich Wild
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
group.com cc:
Subject: RE: [
cf-dev ] cfform[Scanned]
29/06/2004 14:59
Please respond to dev
Your bit of script chkRevision should ideally be in the head of your
document, not just above the form.
Why? I've never experienced this before. You can have a script wherever
you like.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:57
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] cfform[Scanned]
Yup.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:56
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cfform[Scanned]
Are you sure you've got the fields 'revision' and 'EditComments' in your
form, with the same-case spelling?
Your bit of script chkRevision should ideally be in the head of your
document, not just above the form.
Rich Wild
[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
group.com cc:
Subject: [
cf-dev ] cfform
29/06/2004 14:47
Please respond to dev
Yuck. I've inherited code which I'm debugging and it all uses cfform, a
personal peeve of mine.
Now, perhaps its because I came back from Glastonbury yesterday and so
am a
little bit mental, but I'm trying to get this cfform to fire off a
validation script on submit.
So I've added the onsubmit parameter to the cfform call like thus:
cfform action=index.cfm?fuseaction=act_itemstepsstep=1 method=POST
name=itemFrm enctype=multipart/form-data onsubmit=return
chkRevision
();
And I have the following function declared just above it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure
that
you have completed the \'Edit Comments\' field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a Object Not Found
error
when run at the browser on this line (which is obviously created by
cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title,
_CF_this.title.value, Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would* dearly love to turn the whole form into a normal form,
but
there's a lot of work required (large form) to do that and this is a
quick
fix, very unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
--
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]
--
These lists are syncronised with the CFDeveloper forum at
http
RE: [ cf-dev ] cfform[Scanned]
Title: Message
Robin thats a great idea
and works fine. Thanks for helping a poor mud-addled fool out of a pickle.
Ta.
(stupid CFFORM I groan whenever I
inherit code with it in. I just *know*
Im dealing with a lazy coder and Im gonna have other problems
elsewhere, and Im 9 out of 10 times correct)
From: Robin Griffiths
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:22
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
Use the submit button
have your validation script return true or false for passed and failed
respectively which it looks like youve got already, then have something
like this
input
type=submit value=Submit >return
chkRevision();
If validation fails, the
button never triggers, if it passes, it triggers and invokes the forms
onSubmit handler .
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:14
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
Thanks Mark, I agree but how can I
stop this happening and actually get cfform to kick off an extra custom
validation (ie mine) after *its*
finished?
From: Mark Smyth
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:10
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
I think its the onsubmit Rich
When cfform creates the _javascript_
isinitiates the validation by dynamically adding an onsubmit
so what you'd end up with in the browser
is something like
FORM NAME=itemFrm
ACTION=""
METHOD=POST _CF_checkitemFrm(this)
ENCTYPE=multipart/form-data
its basically overwritting your onsubmit, or it
sounds like they might even be conflicting
hth
mark
-Original Message-----
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:48
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] cfform
Yuck. I've inherited code which I'm debugging and it
all uses cfform, a personal peeve of mine.
Now, perhaps its because I came back from Glastonbury
yesterday and so am a little bit mental, but I'm trying to get this cfform to
fire off a validation script on submit.
So I've added the onsubmit parameter to the cfform
call like thus:
cfform
action=""
method=POST name=itemFrm
enctype=multipart/form-data
chkRevision();
And I have the following function declared just above
it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure that you have completed the \'Edit Comments\'
field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a
Object Not Found error when run at the browser on this line (which is obviously
created by cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title, _CF_this.title.value,
Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would*
dearly love to turn the whole form into a normal form, but there's a lot of
work required (large form) to do that and this is a quick fix, very
unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
RE: [ cf-dev ] cfform[Scanned]
Title: Message
Thanks for the idea Mark, and ordinarily
that would work, but Im dealing with a lot of dynamically created stuff,
and so cant just copy the flat JS.
Thanks for your help anyway, and Duncan as
well.
From: Mark Smyth
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:25
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ]
cfform[Scanned]
Robin might have hit the nail on the head,
butif you have problems with that youcould get thecfform
generated code and copy it into a cfml template and it'll still work,
cause itsjust html and _javascript_.
This way you still have all the _javascript_ from
CFFORM, then you'll be able to append your own custom validation into cfforms
_javascript_.
Might take a bit of playing with, but it'll
definetely work.
Mark
-Original Message-
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:14
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
Thanks Mark, I agree - but how can I stop
this happening and actually get cfform to kick off an extra custom validation
(ie mine) after *its* finished?
From: Mark Smyth
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 15:10
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
cfform[Scanned]
I think its the onsubmit Rich
When cfform creates the _javascript_
isinitiates the validation by dynamically adding an onsubmit
so what you'd end up with in the browser
is something like
FORM NAME=itemFrm
ACTION="" METHOD=POST
_CF_checkitemFrm(this)
ENCTYPE=multipart/form-data
its basically overwritting your onsubmit, or it
sounds like they might even be conflicting
hth
mark
-Original Message-----
From: Rich Wild
[mailto:[EMAIL PROTECTED]
Sent: 29 June 2004 14:48
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] cfform
Yuck. I've inherited code which I'm debugging and it
all uses cfform, a personal peeve of mine.
Now, perhaps its because I came back from Glastonbury
yesterday and so am a little bit mental, but I'm trying to get this cfform to
fire off a validation script on submit.
So I've added the onsubmit parameter to the cfform
call like thus:
cfform
action=""
method=POST name=itemFrm
enctype=multipart/form-data
chkRevision();
And I have the following function declared just above
it like thus:
script
function chkRevision() {
if (document.itemFrm.revision.value
!document.itemFrm.EditComments.value.length) {
alert('Warning!\n\nPlease ensure that you have completed the \'Edit Comments\'
field.');
return false
} else {
return true
}
}
/script
That should work yea? So why does the JS give me a
Object Not Found error when run at the browser on this line (which is obviously
created by cfform)
function _CF_checkitemFrm(_CF_this)
{
if (!_CF_hasValue(_CF_this.title, TEXT ))
{
if (!_CF_onError(_CF_this, _CF_this.title, _CF_this.title.value,
Please enter Title))
{
return false;
}
}
return chkRevision();
return true;
}
p.s. I *would*
dearly love to turn the whole form into a normal form, but there's a lot of
work required (large form) to do that and this is a quick fix, very
unfortunately.
I think I've left my mind in a field.
Ta everyone.
Rich
RE: [ cf-dev ] Looping through a list[Scanned]
Remember that if a checkbox isn't ticked, it won't be sent, and won't exist. So you can kill the whole eq 1 bit, you just need isDefined(form.tick#i#) So you have: CFLOOP FROM=1 TO=#listlen(form.id_list)# INDEX=i cfif isDefined(form.tick#i#) Do your shiznit here /cfif /cfloop You could also guarantee that all the tickboxes exist by using cfparam to set them up if they don't exist at the start. -Original Message- From: Gene Brown [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 15:29 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Looping through a list[Scanned] James, I think this should do it... cfif form[#tick1#] eq 1 Cheers Gene From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 15:07 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Looping through a list Hi guys, I've got a form with X number of tick boxes on it (the number being controlled by the number of records pulled from the DB). Each tick box is given the name 'Tick' followed by the ID from the database record. So say I had 5 records, the tick box names would be Tick1,Tick2,Tick3,Tick4,Tick5. The user ticks the boxes they want to delete from the database and then submits the form. The form sends through the tick box values and also a hidden variable with a list of all the ID's that where on the form. The idea being that I use the list to a) tell how many tick boxes there were and b) what the ID's of the records/tick boxes are. This might be a long way of doing this (so correct me if there is an easier way) but what I want to do is loop through each tick box and find out if it has been ticked. If it has I want to run a query to delete that record. Here's my code so far: CFSET last= listLen(#form.id_list#, ,) CFLOOP FROM=1 TO=#last# INDEX=i CFIF form.tick#id# eq 1 CFQUERY . .. DELETE RECORD /CFQUERY !--- display test data //-- CFOUTPUT #listGetAt(form.id_list, i)# /CFOUTPUT /CFIF /CFLOOP My problem is how do I say in Cold Fusion CFIF #form.tick1# eq 1, CFIF #form.tick2# eq 1, CFIF #form.tick3# eq 1, where I have the static wording 'form.tick' and attach the ID from the list to the end of the wording. I've tried a few combinations but it's not budging for me L Cheers, JamesB -- 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]
[ cf-dev ] homesite+ CFML docs
Hi guys. Sorry about this, I know this question comes up all the time, but Im scratching my head trying to find the CFML docs updater for homesite+ - anyone know where they are on MM site? Ive tried, believe me Ive tried. Ta Rich
RE: [ cf-dev ] homesite+ CFML docs[Scanned]
Thanks, but no - I need the actual CFML docs for it, not an updater. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 10:30 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] homesite+ CFML docs[Scanned] this any use? http://www.macromedia.com/software/homesite/download/update/ Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: [ cf-dev ] homesite+ CFML docs 11/06/2004 10:18 Please respond to dev Hi guys. Sorry about this, I know this question comes up all the time, but I'm scratching my head trying to find the CFML docs updater for homesite+ - anyone know where they are on MM site? I've tried, believe me I've tried. Ta Rich -- 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]
RE: [ cf-dev ] homesite+ CFML docs[Scanned]
You sir, are a gentleman. I am thanking you please come again. -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 10:43 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] homesite+ CFML docs[Scanned] Rich, Try here mate: http://www.macromedia.com/software/coldfusion/downloads/ it's on this page:) Cheers, Tom - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 11, 2004 10:18 AM Subject: [ cf-dev ] homesite+ CFML docs Hi guys. Sorry about this, I know this question comes up all the time, but I'm scratching my head trying to find the CFML docs updater for homesite+ - anyone know where they are on MM site? I've tried, believe me I've tried. Ta Rich -- 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]
RE: [ cf-dev ] OT - The going rate[Scanned]
I usually work into the early hours and see how long I can go without sleep (normal life of a developer I guess) you won't catch me doing that in a million years. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 12:46 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT - The going rate[Scanned] Hmm - Your scaring me now .. Maybe I should be charging more. Were all skinflints up here in Brum though you know. I guess the worst thing that could happen is that this client (a friend of a mates uncles brothers cousins mate) gets this business up running and makes a million. I get Β£650.00 for making that happen lol I have emailed the client with a few costs and estimated times but stated that there would be other costs (graphics for example - 100 products = 100 detailed pics + 100 thumb nails) I can bump the price up a bit here ;-) The night working is normal for me. I usually work into the early hours and see how long I can go without sleep (normal life of a developer I guess) As for life.. Coldfusion IS life ... (I can't believe I typed that. Where's my medication) Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- 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]
RE: [ cf-dev ] OT - The going rate[Scanned]
Yup. Beats coding at night. -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 12:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - The going rate[Scanned] Usually too busy sleeping in gutters with pizza in your pockets huh -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 12:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - The going rate[Scanned] I usually work into the early hours and see how long I can go without sleep (normal life of a developer I guess) you won't catch me doing that in a million years. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 12:46 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT - The going rate[Scanned] Hmm - Your scaring me now .. Maybe I should be charging more. Were all skinflints up here in Brum though you know. I guess the worst thing that could happen is that this client (a friend of a mates uncles brothers cousins mate) gets this business up running and makes a million. I get Β£650.00 for making that happen lol I have emailed the client with a few costs and estimated times but stated that there would be other costs (graphics for example - 100 products = 100 detailed pics + 100 thumb nails) I can bump the price up a bit here ;-) The night working is normal for me. I usually work into the early hours and see how long I can go without sleep (normal life of a developer I guess) As for life.. Coldfusion IS life ... (I can't believe I typed that. Where's my medication) Regards - Paul ** *** The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. ** *** -- 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] -- 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]
RE: [ cf-dev ] OT - The going rate[Scanned]
I found that one before you! -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 13:29 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT - The going rate[Scanned] Anyone found them yet? Yeah. The Coldfusion service has stopped responding Makes me laugh every time! Taz -- 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]
RE: [ cf-dev ] coldfusion.org.uk and GoogleBomb!
That's why the amazon api is good. It means you don't have to scrape. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] k] On Behalf Of Snake Hollywood Sent: 22 April 2004 12:10 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] coldfusion.org.uk and GoogleBomb! There was a cf_amazon tag, but the guy gave up on it becaise he had to change it so often because amazon kept changing their code. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 20 April 2004 12:04 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] coldfusion.org.uk and GoogleBomb! Duncan, [EMAIL PROTECTED] wrote: suggestion: add a CF Books section, possibly with the ability to add a review. if you setup with an Amazon account you could make commission of any sales these would generate... Sounds a good plan... is there nothing around already that does this? If not, give me a day or so, and I'll set it up! also: _PJ Net Solutions Regular Expressions Tutorial_ http://www.pjnetsolutions.com/regex Goes through from simple to complex Regular Expressions using ColdFusion (link submitted by: _Paul Johnston_ mailto:paulAT%20NOSPAMpjnetsolutions.com) - Shouldn't that say goes from simple to, er, simple?! ;-) been waiting since 2002 for the medium and complex bits to be completed on this tutorial... Well at least someone's looking at it! One day (one day...) I'll finish it! Paul -- 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] -- 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]
RE: [ cf-dev ] recruitment companies
Thanks Adam --- Adam Reynolds [EMAIL PROTECTED] wrote: Ok your best bet is www.jobserve.com You can also check out www.cwjobs.co.uk www.jobstats.co.uk is also a very very good source of various job sites. I would not recommend one agency over another. As long as they only take 12-20% then they are ok. Adam sorry for the OT, but I've got wombats to feed. Anyone know of any good recruitment companies for to get me a CF job in London village? You can reply to me offlist if you like - richwild AT funjunkie DOT co DOT uk muchas gracias -- 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] -- 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]
RE: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error)
its only the best thing since sliced bread ah, no, wait - that's David Hasselhoff. Oh well, Firefox is pretty cool anyway - its a great browser. Used to be called Firebird. All the cool kids are using it. . tabbed browsing. yummy. --- Snake Hollywood [EMAIL PROTECTED] wrote: I was thinking more of [EMAIL PROTECTED] What is firefox anyway -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 09:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) hell that's a good idea... cf-browser, I can see it now:) - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:39 AM Subject: RE: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) Erm, do I need to setup another list ? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 07 April 2004 17:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) [EMAIL PROTECTED] wrote: don't know that one, but will have to get it. http://texturizer.net/firefox/extensions/#webdeveloper Also, came across a calender extension. http://ftp.mozilla.org/pub/mozilla.org/calendar/xpi/windows/ca lendar_windows _nightly.xpi i'm a big fan of the Adblock extension. hmmm might have to have a look at that one, but have to say the ads don't bother me nearly so much as they used to with IE. Anyway. better stop this before we upset Russ. ;) Stephen -- 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] -- 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] -- 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]
RE: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error)
IE compatibility? Whatchoo talking bout Willis? --- Paolo Piponi [EMAIL PROTECTED] wrote: I know this is all OT but what is FireFox like for IE compatability? Paolo -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 11:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) its only the best thing since sliced bread ah, no, wait - that's David Hasselhoff. Oh well, Firefox is pretty cool anyway - its a great browser. Used to be called Firebird. All the cool kids are using it. . tabbed browsing. yummy. --- Snake Hollywood [EMAIL PROTECTED] wrote: I was thinking more of [EMAIL PROTECTED] What is firefox anyway -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 09:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) hell that's a good idea... cf-browser, I can see it now:) - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:39 AM Subject: RE: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) Erm, do I need to setup another list ? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 07 April 2004 17:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Firefox - WAS (Re: [ cf-dev ] 404 error) [EMAIL PROTECTED] wrote: don't know that one, but will have to get it. http://texturizer.net/firefox/extensions/#webdeveloper Also, came across a calender extension. http://ftp.mozilla.org/pub/mozilla.org/calendar/xpi/windows/ca lendar_windows _nightly.xpi i'm a big fan of the Adblock extension. hmmm might have to have a look at that one, but have to say the ads don't bother me nearly so much as they used to with IE. Anyway. better stop this before we upset Russ. ;) Stephen -- 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] -- 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] -- 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
[ cf-dev ] recruitment companies
sorry for the OT, but I've got wombats to feed. Anyone know of any good recruitment companies for to get me a CF job in London village? You can reply to me offlist if you like - richwild AT funjunkie DOT co DOT uk muchas gracias -- 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]
RE: [ cf-dev ] ukcfug site - browsing jobs?
oo, thanks Steven, I should have mentioned that I'm looking in London though, much as I'd like to move back up north. Russ, will mail you offlist. -Original Message- From: Steven Harper [mailto:[EMAIL PROTECTED] Sent: 24 March 2004 15:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] ukcfug site - browsing jobs? We have a Position in Leeds http://freeyourself.freeserve.com If you apply, please put me as the employee that put ou on to it. Steven Harper -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:23 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] ukcfug site - browsing jobs? I'm on the ukcfug site, but can't seem to find a way to browse the available jobs? The only ones I can get two are the 2 listed on the resources page. Can anyone point out how I can get to the jobs section? Ta. p.s. anyone got any jobs going? fulltime, not freelance. thnx. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- 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] -- 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]
RE: [ cf-dev ] SMS
we used them for the Chasing Bush campaign on interwebnet.org http://www.interwebnet.org/chasing_bush so that people campaigning could text us news/sightings etc from on the march easily with their standard mobiles straight to our inboxes. It worked fantastically! I recommend it. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 24 March 2004 16:09 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SMS Yes Checkout http://www.sms2email.com Kola -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 23:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SMS Thanks Mark, it truly is simple ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 19:59 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SMS Anyone got any tips on sending SMS from CF templates?... any tutorials (can't find any) would be useful plus advice on gateways that are cheap or free! If you use an email to sms gateway, it's as simple as using CFMAIL. Google will find you some cheap gateways, there are very few totally free ones left these days (not sure if there are any tbh). If you have a company account with a mobile phone network, give them a ring and ask them if they run their own or can recommend an sms gateway - never know, they might have something for their business customers. Mark -- 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] -- 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]
RE: [ cf-dev ] cleaning email lists...
SELECT id FROM email
WHERE charindex('@', email) = 0
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 11:23
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
Heh heh, well at least one person had to come up with something that
wasn't NOT LIKE... ;)
Clever clogs :-P
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 11:22
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
SELECT ID FROM Email
WHERE Locate('@',email) = 0
Probably more efficient than NOT LIKE '[EMAIL PROTECTED]', but no idea if
it'll work
in access... Definitely ok in mySQL.
You can probably find an equivalent...
Ian Westbrook (FDM) wrote:
got a bit of a mental block this morning - can anyone throw me the
code
to select emails from a field where the email _doesn't_
contain an '@'
mailto:'@' symbol?
something like
SELECT id FROM email
WHERE email does not contain '@' mailto:'@'
TIA
Ian W
--
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]
RE: [ cf-dev ] XML/RSS Feed
Title: Message well, my site, funjunkie has several feeds including RSS 0.91 and 2.0 (and wddx). Its very very easy to create a feed - they're just textfiles, so you just copy the format and change what you need. I've created a coldfusion template that writes the rss page and then scheduled it to create the raw news.rss files so that a CF page isn't run everytime someone grabs the feed, which with modern aggregators happens quite a lot. Feel free to nick the format, follow http://www.funjunkie.co.uk and then the feeds are at the bottom of the page. The copy for each post item has its HTML formatting removed in my versions. -Original Message-From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:55To: 'cflist'Subject: [ cf-dev ] XML/RSS Feed Hi guys I've had a new call come through. Details are as follows: - Investigate possibility of exporting website data as an XML/RSS feed to other (selected) websites Not too sure of the finer details. We are on CF5 and use Paperthin's CF based content management system where all data is stored in Commonspot's defined DB tables. I have absolutely no exposure to XML or RSS and need some advice if this sort of thing is possible and where to start looking? Have read a couple of intros to XML/RSS to get a bit of backgound but as I say, I am completely new. Would greatly appreciate any advice you can give me. ___ *Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web SupportCap Gemini Ernst YoungSouthbank95 Wandsworth RoadLondon SW8 2HG ( 0870 906 7482___ ===This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.===
RE: [ cf-dev ] XML/RSS Feed
Title: Message p.s. if you want to consume an RSS feed in CFMX - I've a tutorial here: http://www.funjunkie.co.uk/using_xml_feeds_with_coldfusion.cfm its a bit old now, so you can prob find some better tutorials, but it works. -Original Message-From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:55To: 'cflist'Subject: [ cf-dev ] XML/RSS Feed Hi guys I've had a new call come through. Details are as follows: - Investigate possibility of exporting website data as an XML/RSS feed to other (selected) websites Not too sure of the finer details. We are on CF5 and use Paperthin's CF based content management system where all data is stored in Commonspot's defined DB tables. I have absolutely no exposure to XML or RSS and need some advice if this sort of thing is possible and where to start looking? Have read a couple of intros to XML/RSS to get a bit of backgound but as I say, I am completely new. Would greatly appreciate any advice you can give me. ___ *Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web SupportCap Gemini Ernst YoungSouthbank95 Wandsworth RoadLondon SW8 2HG ( 0870 906 7482___ ===This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.===
RE: [ cf-dev ] cleaning email lists...
in my experience with email addresses everything's gonna be wrong with them,
not just missing @ symbols. You need to run an regex against them to filter
out the bads.
-Original Message-
From: Ian Westbrook (BT account) [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 12:31
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
Oh, by the way, add in a condition which removes and scrubs
me from the
spam list too. :)
not spam. Opt-in, people who have signed up for emails: but
some of them are a little, er, _challenged_ when it comes to
computers and stuff, so don't always enter their address
correctly. For example, what prompted my email was noticing
that someone had entered their address as
firstname.lastname'aol.com - ie hit the wrong key for the @ sign...
Ian W
- Original Message -
From: Peter Harrison [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 12:24 PM
Subject: RE: [ cf-dev ] cleaning email lists...
Oh, by the way, add in a condition which removes and scrubs
me from the spam list too. :)
Thanks.
- Peter
-Original Message-
From: Ian Westbrook (BT account) [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 11:58
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
SELECT id FROM email
WHERE charindex('@', email) = 0
ooh, that looks good too ;-)
Ian W
- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 11:34 AM
Subject: RE: [ cf-dev ] cleaning email lists...
SELECT id FROM email
WHERE charindex('@', email) = 0
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 11:23
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
Heh heh, well at least one person had to come up with
something that
wasn't NOT LIKE... ;)
Clever clogs :-P
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 11:22
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
SELECT ID FROM Email
WHERE Locate('@',email) = 0
Probably more efficient than NOT LIKE '[EMAIL PROTECTED]', but no idea if
it'll work
in access... Definitely ok in mySQL.
You can probably find an equivalent...
Ian Westbrook (FDM) wrote:
got a bit of a mental block this morning - can anyone
throw me the
code
to select emails from a field where the email _doesn't_
contain an '@'
mailto:'@' symbol?
something like
SELECT id FROM email
WHERE email does not contain '@' mailto:'@'
TIA
Ian W
--
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]
--
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]
--
These lists are syncronised
RE: [ cf-dev ] cleaning email lists...
yea, short of that there's not a lot you can do with syntactically valid emails. I would just send them all and collect the bounces. After categorising the bounce messages and separating out-of-office repies from true bounces then you can filter your dataset and improve the quality of the list for the next one, whilst reporting on the quality of this initial list. This is what I did for our mailing software. It helps our clients go back to their data providers and get money back for crap lists! :D Lycos had a small issue with claritas after one mailing. -Original Message- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:06 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cleaning email lists... hmmm Good point but short of doing a raw smtp thingum to verify the existance of the mail server? - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 3:59 PM Subject: RE: [ cf-dev ] cleaning email lists... Creatre a table of common misspellings andrun a query to match them every time you find a new one add it to the table The problem with that though is what if [EMAIL PROTECTED] is a real email address? It's a valid domain, and its owned by someone, so why shouldn't they send e-mail through it? -Original Message- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 13:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cleaning email lists... what can/do you do against muppets like: [EMAIL PROTECTED] just delete them - I don't want people that stupid to use my site anyway ;-) Ian W Creatre a table of common misspellings andrun a query to match them every time you find a new one add it to the table -- 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] -- 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]
[ cf-dev ] ukcfug site - browsing jobs?
I'm on the ukcfug site, but can't seem to find a way to browse the available jobs? The only ones I can get two are the 2 listed on the resources page. Can anyone point out how I can get to the jobs section? Ta. p.s. anyone got any jobs going? fulltime, not freelance. thnx. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- 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]
RE: [ cf-dev ] ukcfug site - browsing jobs?
is that the Green Man pub? -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:28 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ukcfug site - browsing jobs? Can anyone point out how I can get to the jobs section? Head up the M5 towards Birmingham, Turn off at J14 and hang a right. It's the second left after the pub. Taz -- 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]
RE: [ cf-dev ] XML/RSS Feed
Title: Message to *consume* an rss feed it really is much easier with cfmx. With CF5 you'll either have to install a 3rd party xml parser or parse it manually with string functions (shudder). To *publish* an rss feed you can use whatever flavour of CF you like - you're just building a textfile. -Original Message-.From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:51To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] XML/RSS Feed OK Rich thanks. Your tutorial link is cfmx related we are on cf5 - so is most of the information redundant for me really? we may be going to cfmx at some point in near future - is this going to make things easier in terms of playing with XML and is it worth me advising to wait for an upgrade before going much further with this? ___ *Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web SupportCap Gemini Ernst YoungSouthbank95 Wandsworth RoadLondon SW8 2HG ( 0870 906 7482___ -Original Message-From: Rich Wild [mailto:[EMAIL PROTECTED]Sent: 23 March 2004 14:47To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] XML/RSS Feed I don't know about commonspot, but your feed subscribers will have to do *something* to the feed, othwerwise they've just got a flat xml packet on their hands. -Original Message-From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:39To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] XML/RSS Feed OK thanks Rich/Ellis I am still not really too clear how this would be done in terms of making the necessary data accessible the data is stored in a whole host of different tables and Commonspot uses a load of moderately complex queries on all the pages to retrieve all the correct data for display (all of which kind of happens behind the scenes as you would expect from a CMS) would I be feeding data straight from a DB or is it possible to pull data from the final rendered HTML code ? this is all a bit foggy still also, does whoever is going to be receiving any RSS feed have to be involved in any dev work to enable them to receive and process whatever we are supplying to them? sorry if none of this is making too much sense!! ___ *Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web SupportCap Gemini Ernst YoungSouthbank95 Wandsworth RoadLondon SW8 2HG ( 0870 906 7482___ -Original Message-From: Rich Wild [mailto:[EMAIL PROTECTED]Sent: 23 March 2004 12:08To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] XML/RSS Feed well, my site, funjunkie has several feeds including RSS 0.91 and 2.0 (and wddx). Its very very easy to create a feed - they're just textfiles, so you just copy the format and change what you need. I've created a coldfusion template that writes the rss page and then scheduled it to create the raw news.rss files so that a CF page isn't run everytime someone grabs the feed, which with modern aggregators happens quite a lot. Feel free to nick the format, follow http://www.funjunkie.co.uk and then the feeds are at the bottom of the page. The copy for each post item has its HTML formatting removed in my versions. -Original Message-From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:55To: 'cflist'Subject: [ cf-dev ] XML/RSS Feed Hi guys I've had a new call come through. Details are as follows: - Investigate possibility of exporting website data as an XML/RSS feed to other (selected) websites Not too sure of the finer details. We are on CF5 and use Paperthin's CF based content management system where all data is stored in Commonspot's defined DB tables. I have absolutely no exposure to XML or RSS and need some advice if this sort of thing is possible and where to start looking? Have read a couple of intros to XML/RSS to get a bit of backgound but as I say, I am completely new. Would greatly appreciate any advice you can give me
RE: [ cf-dev ] ukcfug site - browsing jobs?
no, but really - can't access the jobs bit. -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:28 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ukcfug site - browsing jobs? Can anyone point out how I can get to the jobs section? Head up the M5 towards Birmingham, Turn off at J14 and hang a right. It's the second left after the pub. Taz -- 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]
RE: [ cf-dev ] ukcfug site - browsing jobs?
ah - there seems to be a bug when using www.ukcfug.org.uk as opposed to www.ukcfug.org www.ukcfug.org works fine. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 16:01 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] ukcfug site - browsing jobs? no, but really - can't access the jobs bit. -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:28 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ukcfug site - browsing jobs? Can anyone point out how I can get to the jobs section? Head up the M5 towards Birmingham, Turn off at J14 and hang a right. It's the second left after the pub. Taz -- 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] -- 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]
RE: [ cf-dev ] WooHoo It works ...
heh. yea. I know of some gov departments that are using access and finding
the error of their ways.
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 11:37
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] WooHoo It works ...
so basically when you starting pushing access it has limits
and starts buckling - is that the general concensus?
___
* Regards,
Richard Lovelock,
Senior Application Analyst.
Westminster City Council - Web Support
Cap Gemini Ernst Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
___
-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 11:34
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] WooHoo It works ...
you've hit the nail on the head works great for a small dev
project site...
- Original Message -
From: Lovelock, Richard J [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 11:27 AM
Subject: RE: [ cf-dev ] WooHoo It works ...
why does everyone seem to hate access so much? (apart from memory
leaks mentioned in earlier thread this week)
it helped me learn loads and works great for a small dev
project site
I am working on for learning purposes?
___
* Regards,
Richard Lovelock,
Senior Application Analyst.
Westminster City Council - Web Support
Cap Gemini Ernst Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
___
-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 11:22
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] WooHoo It works ...
you could do exactly the same thing in SQL server Neil...
but yeah I
totally agree with you about access spit /
- Original Message -
From: Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 11:12 AM
Subject: RE: [ cf-dev ] WooHoo It works ...
MAX(ID) is Access aint it spit/
-Original Message-
From: Ian Westbrook (BT account)
[mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 11:06
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] WooHoo It works ...
couldn't you also do...
cftransaction
cfquery name=add_to_ReportNames
datasource=WebUserDSN INSERT
INTO Report_Names (report_name, path_name, Doc_Type_ID) VALUES
('#trim(form.entered_report_name)#',
'#trim(form.entered_path_name)#',
'#trim(form.selected_doc_type)#')
/cfquery
cfquery datasource=#dsn# name=getlast SELECT MAX(id) AS
'last_record_ID' /cfquery
...
/cftransaction
??
Ian W
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 11:00 AM
Subject: [ cf-dev ] WooHoo It works ...
I came up with this ...
cftransaction
!--- First addrecord to reportNames and get the
@@identity
which will give last record_ID created ---
cfquery name=add_to_ReportNames
datasource=WebUserDSN
INSERT INTO Report_Names
(report_name, path_name, Doc_Type_ID)
VALUES
('#trim(form.entered_report_name)#',
'#trim(form.entered_path_name)#',
'#trim(form.selected_doc_type)#')
SELECT @@IDENTITY AS 'last_record_ID'
/cfquery
cfquery name=add_to_Details datasource=WebUserDSN
INSERT INTO Details
(Report_ID, Phase_ID, Group_ID, Menu_Group)
VALUES
('#add_to_ReportNames.last_record_ID#',
'#trim(form.selected_phase_type)#',
'#trim(form.selected_group_type)#',
'#trim(form.selected_menu)#')
/cfquery
/cftransaction
Thanks all for the help ...
Regards - Paul
**
**
*
The information contained within this e-mail (and any
attachment)
sent by
Birmingham City Council is confidential and may be legally
privileged.
It
is
intended only for the named recipient or entity to whom it is
addressed.
If
you are not the intended recipient please accept our apologies and
notify
the sender immediately, or telephone +(44) 121 303 .
Unauthorised access, use, disclosure, storage or copying is not
permitted and may be unlawful. Any e-mail including its
content may
be monitored and used
RE: [ cf-dev ] Whats wrong?
you don't need the hashes '#' around the dateadd (jFromDate, jToDate) CFSET lines in that page! ..*ducks*.. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 15:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Whats wrong? it's a technicolor marvel: http://www.madirish.org/images/cfstudio.jpg Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Lovelock, Richard J To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] richard.lovelockcc: @cgey.com Subject: RE: [ cf-dev ] Whats wrong? 19/03/2004 14:59 Please respond to dev does CF studio colour things prettier than DW then??? I have never used Studio but if my code will look prettier I'll have to seriously consider switching! :oD ___ * Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 14:51 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Whats wrong? what constitutes prettier!!?? CF Studio/HomeSite+ colours your code in in lots of different pretty colours if you complete the tags and attributes in your tags correctly. And it looks pretty... :oD You'd never guess it was Friday afternoon and I'm starting feeling a little demob happy Stephen -- 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 message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- 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:
RE: [ cf-dev ] Whats wrong?
;D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 15:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Whats wrong? i wouldn't know, it's not my site. just used google images to track down a handy screenshot Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Rich Wild [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] go.com cc: Subject: RE: [ cf-dev ] Whats wrong? 19/03/2004 15:09 Please respond to dev you don't need the hashes '#' around the dateadd (jFromDate, jToDate) CFSET lines in that page! ..*ducks*.. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 15:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Whats wrong? it's a technicolor marvel: http://www.madirish.org/images/cfstudio.jpg Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Lovelock, Richard J To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] richard.lovelockcc: @cgey.com Subject: RE: [ cf-dev ] Whats wrong? 19/03/2004 14:59 Please respond to dev does CF studio colour things prettier than DW then??? I have never used Studio but if my code will look prettier I'll have to seriously consider switching! :oD ___ * Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 14:51 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Whats wrong? what constitutes prettier!!?? CF Studio/HomeSite+ colours your code in in lots of different pretty colours if you complete the tags and attributes in your tags correctly. And it looks pretty... :oD You'd never guess it was Friday afternoon and I'm starting feeling a little demob happy Stephen -- 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
[ cf-dev ] Jakarta Lucerne
Anyone used Jakarta Lucerne as an alternative to Verity? http://jakarta.apache.org/lucene/docs/index.html If so, I'd be interested in opnions.. -- 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]
RE: [ cf-dev ] Jakarta Lucerne
brill, thanks fellas! -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 08 March 2004 13:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Jakarta Lucerne Yeah I think Arron wrote those aticles, lots more info at his blog http://cephas.net/blog/ Justin -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED] Sent: 08 March 2004 13:11 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Jakarta Lucerne Anyone used Jakarta Lucerne as an alternative to Verity? http://jakarta.apache.org/lucene/docs/index.html Nope, but FYI - CFDJ has a couple of articles about Lucene with instructions for using it via cfscript and for creating CFXs. Lucence is also used in the new version of Bluedragon to implement cfsearch, cfindex and cfcollection. Mark -- 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] -- 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]
RE: [ cf-dev ] Not using CFLocation any more
or do what I did and setup IIS to use a custom CFML 404 page that handles redirections. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 March 2004 03:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Not using CFLocation any more I would guess because 404 error pages are delivered by the web server not by coldfusion. Coldfusion has it's own settings for non existing pages. You should use these for CF and static html pages for 404's Russ Michaels Administrator CFdeveloper.co.uk This message has been sent from CFdeveloper with username administrator ([EMAIL PROTECTED]) -- These lists are syncronised with the CFDeveloper forum at http://forum.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/ 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]
RE: [ cf-dev ] Bookmark
In honesty I an coming up to the end of a project deadline and don't have time to try and find it :-( surely using google would have taken less time than the time it took to write that e-mail? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 March 2004 10:45 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Bookmark Does anyone have the code for a Click here to bookmark this page please? In honesty I an coming up to the end of a project deadline and don't have time to try and find it :-( Many Thanks Regards - Paul ** *** The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. ** *** -- These lists are syncronised with the CFDeveloper forum at http://forum.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/ 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]
RE: [ cf-dev ] Bookmark
ad nauseam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 March 2004 11:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Bookmark surely using google to find out the answer for him would have taken less time than the time it took YOU to write THAT reply? surely using google to find out the answer for him would have taken less time than the time it took ME to write THIS reply? ad infinitum Rich Wild [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] go.com cc: Subject: RE: [ cf-dev ] Bookmark 04/03/2004 10:46 Please respond to dev In honesty I an coming up to the end of a project deadline and don't have time to try and find it :-( surely using google would have taken less time than the time it took to write that e-mail? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 March 2004 10:45 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Bookmark Does anyone have the code for a Click here to bookmark this page please? In honesty I an coming up to the end of a project deadline and don't have time to try and find it :-( Many Thanks Regards - Paul ** *** The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. ** *** -- These lists are syncronised with the CFDeveloper forum at http://forum.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/ 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/ 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
RE: [ cf-dev ] Quick way to insert a record per day.
loop over the results of DateDiff(datepart, date1, date2), adding a date using dateadd() for each iteration. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 14:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Quick way to insert a record per day. I've got a start date and an end date and I want to insert a record into the database for each date between and including the start and end dates. Any thoughts on a quick and easy way to do this? Stephen the fuzzy brained. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Quick way to insert a record per day.
heh, one of them eh? ;) -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 15:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Quick way to insert a record per day. Cheers chaps Definitely needed the help after the meeting I've just been in. Stephen Rich Wild wrote: loop over the results of DateDiff(datepart, date1, date2), adding a date using dateadd() for each iteration. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 14:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Quick way to insert a record per day. I've got a start date and an end date and I want to insert a record into the database for each date between and including the start and end dates. Any thoughts on a quick and easy way to do this? Stephen the fuzzy brained. -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CSV to query
That's my fav method. Eeez verry naice! -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 17:01 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CSV to query You might be interested in another approach which is a little more efficient than CFHTTP. Set up an ODBC datasource using the CSV driver and point it at a directory. Then all you need to do is perform a query with that datasource, using the filename of the csv where you would use a tablename in your SQL. Steve -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CSV to query Ignore me - it's done in cfhttp. Thanks for the help. ;) Tim. From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: Mon 01/03/2004 12:10 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CSV to query Brain ache... Trying to read in a CSV file and use it as a query object. I know there's something that can do it but I'm having Monday issues... Any suggestions? Tim. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Coldfusion Developer
I've never bothered with the certification. Me neither. My portfolio speaks for itself. Well, it hopefully will do! Thing is, most people are using studio/DWMX right? What's the point in memorising the attribute of every single tag when you have easily to hand helpfiles? As it happens, I know most of them, but that's just through usage over the years, certainly not because I sat there with the wall chart memorising them. I don't *need* to know the attributes for CFFORM, because I never use it in everyday work. Rich -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Coldfusion Developer
Getting subsets of data that the application already has access to is about the only thing I use it for. Quicker than going back to the DB and saves on caching. I used it this way as well, saving large recordsets in memory to avoid repeated trips to the db to perform time-expensive complex queries. In my testing I found that using v. large recordsets (400,000 etc) of data and filtering them with either QofQ or looping and comparing, looping was MUCH faster. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Coldfusion Developer
(but fair play to anyone who does put in the effort to learn all the stuff and do the exams!!! ;o) ) Oh yea! I'm not taking ANYTHING away from those who have taken the exam - it sure looks great on a CV, and when we've been recruiting CF developers we've looked for certification where no immediate portfolio was present. You have to have some indication of competancy. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Date problem
dayofweekasstring(dayofweek(now())) -Original Message- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 09:33 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Date problem Hi is there a function that takes a date and returns the day of the week ? like Dayofweek(now()) == returns Thursday? cant seem to find one thanks |\/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\/| -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] sending http content
anyone got any ideas on this one? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 15:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] sending http content I have an app that depends on the use of gethttprequestdata to grab some xml posted in the content of the http headers. Now, all's well and good, but how can I use CF to actually send testdata to it? Can I, even? --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] sending http content
no, its not the same thing... I need to send the content in the request headers, not the body. normal posted data would show up in the form scope, but this doesn't, its only available through using getHttpRequestData() unless I'm missing something about cfhttp. -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 10:34 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] sending http content Can't you post the test data to it using CFHTTP ? Stephen -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 10:31 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] sending http content anyone got any ideas on this one? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 15:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] sending http content I have an app that depends on the use of gethttprequestdata to grab some xml posted in the content of the http headers. Now, all's well and good, but how can I use CF to actually send testdata to it? Can I, even? --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] sending http content
no, because the values are not exposed in cgi scope either. the content length is, but not the actual data. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 10:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] sending http content cfhttpparam type=cgi should do it Nick - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 10:39 AM Subject: RE: [ cf-dev ] sending http content no, its not the same thing... I need to send the content in the request headers, not the body. normal posted data would show up in the form scope, but this doesn't, its only available through using getHttpRequestData() unless I'm missing something about cfhttp. -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 10:34 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] sending http content Can't you post the test data to it using CFHTTP ? Stephen -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 10:31 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] sending http content anyone got any ideas on this one? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 15:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] sending http content I have an app that depends on the use of gethttprequestdata to grab some xml posted in the content of the http headers. Now, all's well and good, but how can I use CF to actually send testdata to it? Can I, even? --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] sending http content
You have a script that is (I'm guessing here) grabbing some SOAP data or other from the request header when it is called using getHTTPRequestData(). spot on. using getHTTPRequestData(). You then want to respond to that request, sending back the appropriate response, again in the header, rather than in the main message body? no, I can respond in the message body, that's fine - what I'm trying to do is test my app. Because the data is coming from a remote service, I can't test my data until the app goes live, so I need to send some test data to it myself, emulating the call. How can I do this with CF - and if I can't use CF to send it, what can I use? -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 11:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] sending http content hmmm, no, I can't seem to set the content of the request headers that way. Right, I only came into this just now, so explain again and I'll have a thunk... You have a script that is (I'm guessing here) grabbing some SOAP data or other from the request header when it is called using getHTTPRequestData(). You then want to respond to that request, sending back the appropriate response, again in the header, rather than in the main message body? --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] sending http content
I have an app that depends on the use of gethttprequestdata to grab some xml posted in the content of the http headers. Now, all's well and good, but how can I use CF to actually send testdata to it? Can I, even? --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Forum Apps
~cough~ mine. ~ducks and runs~ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 11:33 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Forum Apps ~cough~ phpBB2 ~ducks and runs~ Robertson-Ravo, Neil (RX) wrote: Any got any faves for forums apps..(MX, 5) ideally free but not essential... 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 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Forum Apps
heh heh Where?? as if you couldn't guess. ;) -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 11:45 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Forum Apps Paul Johnston wrote: ~cough~ phpBB2 ~ducks and runs~ I second that! If you can get PHP then use this! It's FREE! Fusetalk is in some ways better, but... I actually like phpBB2 better than fusetalk. I use both. I've got one site that I now wish I had used phpBB2 rather than fusetalk. Only major issue is that I would have to work out how to integrate the CF login on the site with the phpBB2 login... Rich Wild wrote : ~cough~ mine. ~ducks and runs~ heh heh Where?? Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] New lists and forums integration
god forbid that chat should be archived. -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 09:07 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] New lists and forums integration aww, where's chat? - Peter -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 15:48 To: [EMAIL PROTECTED] Subject: [ cf-dev ] New lists and forums integration Guys, I have been setting up the new fusetalk forums, and I am syncing it with this list so that list posts go to the forums and vice versa, but in order to do that I am splititng this list up into categories to match the forum. Hopefully things will then get more active as the other members will start using them. Here are the new lists, you will need to subscribe to each, and please post to the appropriate one to keep everything nice and synced. I suggest you create a folder for each in outlook and setup your mail rules. In addiiton the new fusetalk forum also has an offline reader. Coldfusion coding: [EMAIL PROTECTED] To subscribe email: [EMAIL PROTECTED] Database/SQL coding : [EMAIL PROTECTED] To subscribe email: [EMAIL PROTECTED] DHTML/CSS/XML etc : [EMAIL PROTECTED] To subscribe email: [EMAIL PROTECTED] Cfdeveloper service and questions : [EMAIL PROTECTED] To subscribe email: [EMAIL PROTECTED] HELM control panel: [EMAIL PROTECTED] To subscribe email: [EMAIL PROTECTED] The new forum will be at http://forum.cfdeveloper.co.uk/ but please follow the link from the www.cfdeveloper.co.uk website as there will likely be addiitonal parameters on the URL. Currently the beta version is still online, so don't bookmark it yet. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Email Links Splitting
I built one myself - its quite easy. You take a long url, check to see if it hasn't been stored in the db, if it hasn't, create a unique id and store the unique id against that url. Whenever someone clicks the shorterlink - retrieve it using that id and then redirect! -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 09:15 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Email Links Splitting that's a bit nifty!! how does that work - something to do with DNS??? (havent time to read through help etc on site) ___ * Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 09:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Email Links Splitting You could try using www.tinyurl.com to make a 'tiny' URL instead and paste that into the email? Jb. -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 09:03 To: 'cflist' Subject: [ cf-dev ] Email Links Splitting Morning Guys/Gals (sorry if i am supposed to be using the dedicated list yet - am I?? haven't had time to sort it out yet) I need a pretty urgent response if possible.. We have an application on our website which allows Met Police officers to send out Email newsletters usinf CFMail. An officer wants to send out an email with a link to a document but the link is quite long and goes over two lines which breaks the link from the first line (i.e. the text on the 2nd line doesn't stay as part of the text) This also happened when he inserted the link just in to a normal email to me Is there anything I can do to ensure that his link stays together as a hyperlink even if it gets split over two lines? ___?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / * Regards, Richard Lovelock, Senior Application Analyst. Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === _ This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com ** Copyright ERA Technology Ltd. 2004. (www.era.co.uk). All rights reserved. The information supplied in this Commercial Communication should be treated in confidence. No liability whatsoever is accepted for any loss or damage suffered as a result of accessing this message or any attachments. ** _ This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Mac compatability
our designers user either IE or firefox. -Original Message- From: Paolo Piponi [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 16:18 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Mac compatability OK, that's contradictory. Lisa says NS and you say IE. Is it IE or Netscape for the majority? And Safari/Firefox - are you guys not happy with just one or two? Paolo -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 16:14 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Mac compatability IE 5 on the recent-old macs... and the brand spanking new Safari on anything recent. Although I use FireFox on my Mac :D -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] xml post
A client is posting an xml request to an app of mine. I can see that the content_length is 363, but can't remember how to expose the content itself for parsing. Can anyone remember? Rich -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] xml post
ah sorry, I think it was gethttprequestdata() that I was after. Finally managed to find it. I needed to actually get at the data itself, I'm ok with the parsing it later, but thanks anyway. -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 09:24 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] xml post Wasn't quite sure what you need to do with the data etc but .. IsXMLDoc()to see if its valid Then XMLParse() to get stuff out of it .. Or use CFDUMP to have a look at the whole thing .. or do a ToString() on it HTH Stephen -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 09:09 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] xml post A client is posting an xml request to an app of mine. I can see that the content_length is 363, but can't remember how to expose the content itself for parsing. Can anyone remember? Rich -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] checking email addresses
I'm Alex and so is my wife. (we tried to verify email addresses in this way, but quite a few mail servers don't respond accordingly, so we didn't bother) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 10:58 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] checking email addresses ok, but who's alex? ;-) Matt Horn [EMAIL PROTECTED]To: [EMAIL PROTECTED] rn.org cc: Subject: Re: [ cf-dev ] checking email addresses 06/02/2004 10:56 Please respond to dev Ignore me listen to Alex he is smarter then me anyway - Original Message - From: Matt Horn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 06, 2004 12:55 PM Subject: Re: [ cf-dev ] checking email addresses You used to be able to do this with 'finger' or 'verify' commands on the mail server as u can imagine its a security risk and most mail server administrators will have disabled those cammands so I think what you want to do will be very difficult if not impossible Matt - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 06, 2004 12:51 PM Subject: [ cf-dev ] checking email addresses Anyone got some code that can simply validate some email addresses. Not that they are the correct syntax, but that they actually exist and will accept mail? I'm sure this can be done... Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] checking email addresses
delivery failures are valuable. Our clients pay plenty money for that information. They get to clean their lists with it. -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 14:18 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] checking email addresses You and every spammer in the world :D ** I did not call you a spammer ** I know you are legit. But technically ** it's the same problem, isn't it? Duncan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 14:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] checking email addresses it's for a list of email addresses, a large percentage of which i suspect are now out of date. i need to bulk mail them all, but don't want to get back hundreds of delivery failures. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Adam ReynoldsTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: o.ukSubject: RE: [ cf-dev ] checking email addresses 06/02/2004 13:20 Please respond to dev Not really possible. What I do is send an authorisation email to the address. If they don't click on the link provided, whatever they wanted from your site is not done until the initial authorisation. Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 10:51 To: [EMAIL PROTECTED] Subject: [ cf-dev ] checking email addresses Anyone got some code that can simply validate some email addresses. Not that they are the correct syntax, but that they actually exist and will accept mail? I'm sure this can be done... Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] checking email addresses
well it's not strictly legit, it's a porn site's mailing list. funnily enough several of the addresses are also on this list... That's legit in my book. Anyway, I *told* them when I signed up that I didn't want them to send me stuff! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 15:07 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] checking email addresses well it's not strictly legit, it's a porn site's mailing list. funnily enough several of the addresses are also on this list... Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Duncan Fenton [EMAIL PROTECTED]To: [EMAIL PROTECTED] rve.co.ukcc: Subject: RE: [ cf-dev ] checking email addresses 06/02/2004 14:17 Please respond to dev You and every spammer in the world :D ** I did not call you a spammer ** I know you are legit. But technically ** it's the same problem, isn't it? Duncan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 14:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] checking email addresses it's for a list of email addresses, a large percentage of which i suspect are now out of date. i need to bulk mail them all, but don't want to get back hundreds of delivery failures. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Adam ReynoldsTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: o.ukSubject: RE: [ cf-dev ] checking email addresses 06/02/2004 13:20 Please respond to dev Not really possible. What I do is send an authorisation email to the address. If they don't click on the link provided, whatever they wanted from your site is not done until the initial authorisation. Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 10:51 To: [EMAIL PROTECTED] Subject: [ cf-dev ] checking email addresses Anyone got some code that can simply validate some email addresses. Not that they are the correct syntax, but that they actually exist and will accept mail? I'm sure this can be done... Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:
RE: [ cf-dev ] OT: preventing hotlinking
or do what I do when people hotlink FJ's images. call down a lil bit of goatse on their heads. -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:38 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: preventing hotlinking I've just thought of an interesting solution to this problem, that doesn't require more 3rd party plugins for IIS. Assuming your application is CF throughout, you could store the name of the images directory in a database and pick this up for output in any links. Then you could set up a session to change the name of the images directory every day. This wouldn't physically stop people from linking to images, but it would make their links redundant every day. Taz -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: preventing hotlinking
um. yes, yes it is. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking Goatse? What's that, goat cheese? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking or do what I do when people hotlink FJ's images. call down a lil bit of goatse on their heads. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: preventing hotlinking
well, he'll love the goatse that I can provide him with. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:54 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking Well then you're in trouble then, cos my mate Dave, he hot links and he loves the stuff... -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking um. yes, yes it is. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking Goatse? What's that, goat cheese? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking or do what I do when people hotlink FJ's images. call down a lil bit of goatse on their heads. -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] FW: Newsflash - IR35 to be abolished in April and replaced by IR591
(Ooh, was that a political rant?) careful Taz. You almost sound like you know what you're talking about. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] need another pair of eyes to look at this simple r egex
that matches 2 consecutive matches.
ie jshas89kshjas
or sdd65987987
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]
Sent: 16 January 2004 16:04
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] need another pair of eyes to look at this
simple regex
Ok, Quick regex question
I have the following which is supposed to return true if
string contains 2 or more numbers - can anyone see what I'm
missing here (it always returns false).
if( not reFindNoCase(([0-9]){2,}, k7p2oog){
return true;
} else {
return false;
}
Thanks
Kola Oyedeji
Certified Advanced Coldfusion Developer,
ICLP London
DDI: +44 (0) 208 256 9034 (Ex.2204)
www.iclployalty.com
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED] For human
help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Strange T-SQL issues
use need the TIMESTAMP var type in cf. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 10:44 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Strange T-SQL issues I am having issues putting a date/time from CF into SQL Server. I am sure it's simple, but I can't seem to get the time into the server (date is no problem). Running this code in Query Analyzer produces the correct output (ie a date with the right time): DECLARE @sd varchar(30) SELECT @sd = '2003-10-19 12:23:03' DECLARE @dt datetime SELECT @dt = CONVERT(datetime, @sd, 120) SELECT @dt as dt However, if I insert in a date via a Stored Procedure (either as a cf_sql_date or cf_sql_varchar and convert to date) either way it removes the time and just inserts the date. Anyone? Paul -- Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: +44 7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Strange T-SQL issues
I have no idea, it appears to be one of those weird decisions the CF engineers made. I'm assuming the date var type just takes the date and not the time - you could test this if you have some time. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 11:40 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Strange T-SQL issues Yup, that would do it. Can you tell us why though Rich, tis most perplexing! It had me screwed for quite some time. d -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 10:47 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Strange T-SQL issues use need the TIMESTAMP var type in cf. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 10:44 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Strange T-SQL issues I am having issues putting a date/time from CF into SQL Server. I am sure it's simple, but I can't seem to get the time into the server (date is no problem). Running this code in Query Analyzer produces the correct output (ie a date with the right time): DECLARE @sd varchar(30) SELECT @sd = '2003-10-19 12:23:03' DECLARE @dt datetime SELECT @dt = CONVERT(datetime, @sd, 120) SELECT @dt as dt However, if I insert in a date via a Stored Procedure (either as a cf_sql_date or cf_sql_varchar and convert to date) either way it removes the time and just inserts the date. Anyone? Paul -- Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: +44 7866 573013 -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CF Salaries
Is it the same situation in the UK? nope. instead trained IT graduates are retraining as plumbers and builders where they can make much more money and gain employment. Building courses etc are oversubscribed across the whole country. -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 14:02 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CF Salaries In Ireland, there have been serious drops in people entering tech. university courses. So bad that the colleges are actively promoting computer courses. A couple of years ago it impossible to get a place. Techie companies are worried that there won't be enough skills in the future. Is it the same situation in the UK? Justin -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 13:40 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CF Salaries What about the flood of asp-ers who claim to know asp? plug shameless=true I actually do /plug Duncan Fenton Solution Consultant -Original Message- From: EWS [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 12:55 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF Salaries snip perhaps it is the flood of ASPers and PHPers that claim to know CF that is bringing down the perceptions on recruiters (especially those who dont really understand what CF is and how it can be utilised). ASP and PHP programmers are after 10 a penny these days. They are being taught ASP at University and even in some High Schools and PHP modules are given away by the thousands so PHPers dont have to understand basic programming concepts (plug and play programming). What does everyone else think? Ellis C Wood BSC Ellwood Web Solutions -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
