Hi,
I currently have the same problem. Any solution regarding this?
Regards,
Christian
~|
Order the Adobe Coldfusion Anthology now!
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:
replace commas with another arbitrary separator?
cfset lstText = 'this is one, this is another one, this should be second
item' /
cfoutput#listLen(replacenocase(lsttext,',','||'), '||')#/cfoutput
~|
Order the Adobe
On Sun, May 16, 2010 at 10:07 AM, Brian McCairn
brian.mcca...@medicapp.eu wrote:
replace commas with another arbitrary separator?
Doesn't solve the problem.
cfset lstText = 'this is one, this is another one, this should be second
item' /
cfoutput#listLen(replacenocase(lsttext,',','||'),
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
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
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:
cfset lstText = this is one, this is another one /
cfoutput#listLen(lstText, ,)#/cfoutput
Instead of doing this via CF, try leveraging MySQL's text
this better illustrates what I meant
cfset lstText = 'this is one, this is another one, this should
be second item' /
cfoutput#listLen(lstText, ,)#/cfoutput
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
http://63.144.103.199/products/index.cfm?n1ID=5n2ID=43n3ID=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...
sure
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...
cfset request.responseCODE = #trim(listGetAt(AuthList, 1, |))#
cfset request.response =
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 of
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 response that's
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 ListToArray(*list* [,
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
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 two
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
date
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 to
Yeah, that's a known issue... if you want a buddy of mine wrote a little
UDF called listFix http://www.cflib.org/udf.cfm?id=507. 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 PROTECTED]
Since you are already Trim()ming all the values, you could do something like
this:
cfset AuthList =replace(AuthList,||,| |,all)
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
19 matches
Mail list logo