Skip to main content
A
apocalipsis19
Inspiring
April 21, 2009
Question

ColdFusion List Question

  • April 21, 2009
  • 2 replies
  • 1586 views

Hello Community!

I have two questions regarding CF lists:

1-) I have a list that has the values 1,2,

As you can see, the comma at the end of that string will make mymy program break because that list of comma delimited values is being used in a SQL statement: in(1,2,)

How do I remove that comma at the end of my list?

2-) I have a list with the values 1,,3

How do I get rid of that unnecesary comma? How do I fill in the space between , and , with a value so it's 1,value,3 instead?

Thanks!

Ysais.

This topic has been closed for replies.

2 replies

A
Anonymous
April 22, 2009

if mylist = '1,2,'

then you could make your SQL in(#removechars(mylist, len(mylist), 1)#)

essentially removing the last character.

to get rid of the unnecessary comma you could CFLOOP though the list and create another list 'mynewlist' this time not including anything that's blank

ie if mylist = '1,,3'

<cfset mynewlist = ''>
<cfloop list="#mylist#" index="getitem">
<cfif getitem neq ''>
<cfset mynewlist = listappend(mynewlist, #getitem#)>
</cfif>
</cfloop>

mynewlist becomes '1,3'

-
-__cfSearching__-
Inspiring
April 22, 2009

you could CFLOOP though the list and create another list 'mynewlist' this time not including anything that's blank


If the goal is to remove extra commas, it is simpler to just use:  newList = arrayToList(listToArray(oldList)).

I
insuractive
Inspiring
April 27, 2009

Have you tried just using the original list in your SQL statement as a <cfqueryparam> tag with attribute list="yes" ?  Not sure if it will still through an error, but its definitely worth using the <cfqueryparam> tags to handle your lists in your SQL: faster and less vulnerable to attack.

-
-__cfSearching__-
Inspiring
April 21, 2009

There are several options (like replace).  But, CF list functions ignore empty elements.  This is one situation where that behavior might be useful. One option is to convert the list to an array and then back to a list.  That will get rid of the extra commas

<cfset newList = arrayToList(listToArray(yourList))>

Just check the list length before passing it to your sql, to avoid an error if the list is empty.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices