Re: listgetat problem...

On Sun, May 16, 2010 at 10:07 AM, Brian McCairn wrote: > replace commas with another arbitrary separator? Doesn't solve the problem. > > > #listLen(replacenocase(lsttext,',','||'), '||')# That just replaces the first , - in the "string" with || and so you get a listLen() of 2: "this is one||

Re: listgetat problem...

replace commas with another arbitrary separator? #listLen(replacenocase(lsttext,',','||'), '||')# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/14302721

Re: listgetat problem...

>>I currently have the same problem. Same as what? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusi

Re: listgetat problem...

Hi, I currently have the same problem. Any solution regarding this? Regards, Christian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffu

Re: listgetat problem...

this better illustrates what I meant #listLen(lstText, ",")# It will output 3 rex wrote: > listGetAt() sees the "," inside the double-quotes as a list item. So it > sees this piece of text as two items in the text lstText: > > > #listLen(lstText, ",")# > > Instead of doing

Re: listgetat problem...

listGetAt() sees the "," inside the double-quotes as a list item. So it sees this piece of text as two items in the text lstText: #listLen(lstText, ",")# Instead of doing this via CF, try leveraging MySQL's text importer. It will be much faster. MySQL has to have access to the fi

Re: listgetat problem...

The CSV format is not a comma-delimited list per line. It's richer than that. So you can't just use the list functions on it, you need an actual CSV parser. One isn't hard to write (and there are several valid approaches), but the easiest course of action is to just grab one that is already wri

listgetat problem...

Hi all - I'm trying to (unsuccessfully) import a comma delimited text file (from an MLS service) into a MySQL db and looping over the file using listgetat in this manner: ... '#listgetAt('#index#',4, ',')#', '#listgetAt('#index#',5, ',')#', '#listgetAt('#index#',6, ',')#' ... I'm suspecting tha

ListGetAt problem distinct

http://63.144.103.199/products/index.cfm?n1ID=5&n2ID=43&n3ID=133 if you click the accessories tab you can see i have repeating accesories in the Fans works fine if i pull out numbers that are repeated and add them to a new category.. which i am probably going to make the data entry guys do... sur

Re: listGetAT problem...

Since you are already Trim()ming all the values, you could do something like this: All of your existing code after that should work. On Jan 9, 2008 5:24 PM, Charlie Griefer <[EMAIL PROTECTED]> wrote: > On Jan 9, 2008 2:17 PM, Bryan Stevenson <[EMAIL PROTECTED]> > wrote: > > and in case you want

Re: listGetAT problem...

Yeah, that's a known "issue"... if you want a buddy of mine wrote a little UDF called listFix . It's available on cflib.org. Just pass your list to this function before running the rest of your code. Chris On Jan 9, 2008 4:17 PM, Bryan Stevenson <[EMAIL PROTEC

Re: listGetAT problem...

There is also a function at CFLib.org that will do this. http://www.cflib.org/udf.cfm?ID=962 On Jan 9, 2008 5:27 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > Todd wrote: > > Yeah, sorry... "If you're on CF8, which you should be, if you're not... > > sorry." > > > CF7 still - waiting on the host t

Re: listGetAT problem...

Todd wrote: > Yeah, sorry... "If you're on CF8, which you should be, if you're not... > sorry." CF7 still - waiting on the host to upgrade ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to dat

Re: listGetAT problem...

On Jan 9, 2008 2:17 PM, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > and in case you want to know why and just not a fix ;-) > > the problem is CF doesn't recognize empty list elements...so you can replace > all instances of || with | | in the list and then parse things out that won't resolve tw

Re: listGetAT problem...

and in case you want to know why and just not a fix ;-) the problem is CF doesn't recognize empty list elements...so you can replace all instances of || with | | in the list and then parse things out Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems

Re: listGetAT problem...

Yeah, sorry... "If you're on CF8, which you should be, if you're not... sorry." On Jan 9, 2008 5:07 PM, Charlie Griefer <[EMAIL PROTECTED]> wrote: > that assumes he's on CF8, no? > > (which he may be... i'm not sure) :) > > On Jan 9, 2008 2:00 PM, Todd <[EMAIL PROTECTED]> wrote: > > Use ListToArr

Re: listGetAT problem...

that assumes he's on CF8, no? (which he may be... i'm not sure) :) On Jan 9, 2008 2:00 PM, Todd <[EMAIL PROTECTED]> wrote: > Use ListToArray(*list* [, *delimiters*, *includeEmptyFields*]) instead. > > > > On Jan 9, 2008 4:45 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > > > I've got an http respon

Re: listGetAT problem...

Use ListToArray(*list* [, *delimiters*, *includeEmptyFields*]) instead. On Jan 9, 2008 4:45 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > I've got an http response that's being return like: > > 2|1|2|Approved||P|1688659283|12912008010910019012|.. > > I need to pull a couple of things out

listGetAT problem...

I've got an http response that's being return like: 2|1|2|Approved||P|1688659283|12912008010910019012|.. I need to pull a couple of things out of that to display on a page, so... Response: #request.response# Transaction Id: #request.transactionID# Invoice Number: #request.invoiceNU