[cfaussie] Re: FW: string manipulation

2009-09-07 Thread nkosi
Or do it in the query ... Oracle would be something like ... SELECT substr(your_column_here, 1, 1) AS COL1, substr(your_column_here, 2, 1) AS COL2, substr(your_column_here, 3, 1) AS COL3, substr(your_column_here, 11, 1) AS COL11 FROM your_table_here Not that I am recommending it ... I'm ju

[cfaussie] Re: FW: string manipulation

2009-09-07 Thread Kevan Stannard
Hi Claude There is also a Java function that may work for you: However this does not return a normal CF array, this is a Java array of Character objects. If you want to manipulate the digits you'd probably want to convert to a normal cf array first. Kevan Stannard 2009/9/8 > > > > > > >

[cfaussie] Re: FW: string manipulation

2009-09-07 Thread Steve Onnis
thats a lot of work for not much -- Make it into a list -- Make it into an array (CF8 only) or Even the example belowwhy wouldnt you just use MID() ? Steve _ From: Paul Kukiel [mailto:kuki...@gmail.com] Sent: Tuesday, 8 September 2009 1:40 AM To: cfaussie@googlegr

[cfaussie] Re: FW: string manipulation

2009-09-07 Thread Paul Kukiel
How about this: #left(right(number,len(number)-i+1),1)# Paul. From: SAMARIS Software [mailto:i...@samaris.net] Sent: Tuesday, 8 September 2009 1:27 AM To: 'cfaussie@googlegroups.com'; 'coldfusion-ho...@yahoogroups.com' Su

[cfaussie] FW: string manipulation

2009-09-07 Thread raiola
Regards Claude Raiola B.Econ (Acc), B.Hot.Mngt. Websites: www.SAMARIS.NET Mobile: 0414 228 948 From: SAMARIS Software [mailto:i...@samaris.net] Sent: Tuesday, 8 September 2009 1:27 AM To: 'cfaussie@googlegroups.com'; 'coldfusion-ho...@yahoogroups.

[cfaussie] Re: Coldfusion FORM scope randomly missing variables

2009-09-07 Thread kj
Hi, FYI, I think IE 5 had a bug & it sometimes didn't include all the Form parameters in a HTTP request... (you never know *grin*) I've also encountered a similar problem with a client who was using an NTLM authorisation Proxy Server - something like the following: When end users first attempt