Getting rid of the last comma in a cfoutput query 1

[3dColor]

I would like to get rid of the last comma when a query is returned:

<cfoutput query="QofQ">#color#, </cfoutput>

So if I have 3 entries; red, green, blue...

The CF output is "red, green, blue,"

How can I get rid of the last comma?

Thanks

 

[NorthStarDA]

instead of doing a query output, can you do a ValueList()?

#ValueList(QofQ.color)#

that will put commas where they go.

=========================================
Don't sweat the petty things and don't pet the sweaty things.

 

[3dColor]

I am not familar with the ValueList() command.

Do I need to place commas in the database?

#ValueList(QofQ.color)# Where do I insert the commas?

Thanks!

 

[NorthStarDA]

you dont.. your original example loops over a query where you output each single value with a comma - this function does not require the loop, it gets all values from that column of your query and comma-separates them for you.

if your not familiar with the function, look it up on liveDocs for a full explanation

http://livedocs.macromedia.com/coldfusion/7/index.html

=========================================
Don't sweat the petty things and don't pet the sweaty things.

 

[3dColor]

Thanks for your help, your idea works great for one column in a database but i have two columns in the DB i need to put together.

I am creating a JS function for Google maps where I want the end result to look like this:

var pointsArray = [new GLatLng(39.116699, -105.713997), new GLatLng(39.924764, -105.155873), new GLatLng(39.907537, -105.071079), new GLatLng(39.933751, -105.163547), ];

But without the trailing comma at the very end.

Here is what I used to generate the above resulting code:

var pointsArray = [<cfoutput>new GLatLng(#latitude#, #longitude#), </cfoutput>];

I tried using the ValueList() command but it only seems to take on argument. Below code doesn't work.

var pointsArray = [<cfoutput>#ValueList(new GLatLng(QofQ.latitude, QofQ.longitude))#</cfoutput>];

Any other ideas?

 

[philhege]

<cfset strlatlong = "">
<cfoutput query="QofQ">
<cfset strlatlong = strlatlong & "new GLatLng("&latitude&
"," & longitude&"),">
</cfoutput>
<cfset strlatlong = mid(strlatlong,1,len(strlatlong)-1)>
<cfoutput>
var pointsArray = [#strlatlong#];
</cfoutput>

HTH,

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.