Bulleted List

[boatguy]

I have a comma separated list in a dB field, how do I display it in a bulleted list in CF?

 

[Sarky78]

Like this:

<UL>
<CFLOOP LIST="#whatever#" INDEX="i">
<LI><CFOUTPUT>#i#</CFOUTPUT></LI>
</CFLOOP>
</UL>

Hope this helps!

Tony

 

[boatguy]

Thanks arperry

 

[boatguy]

I am getting an error. My field type is an nvarchar and I get the following error:

Error Diagnostic Information
LIST

The value cannot be converted to a string because it is not a simple value. Simple values are booleans, numbers, strings, and date-time values.

Do I need to generate a list first?

 

[TruthInSatire]

It is vital you put the code that is causing the error if you would like us to look at it.

however my guess is you're doing this.

<UL>
<CFLOOP LIST="#[b]queryName[/b]#" INDEX="i">
  <LI><CFOUTPUT>#i#</CFOUTPUT></LI>
</CFLOOP>
</UL>

when it should be

<UL>
<CFLOOP LIST="#[b]queryName.columnName[/b]#" INDEX="i">
  <LI><CFOUTPUT>#i#</CFOUTPUT></LI>
</CFLOOP>
</UL>

posting your code would give us a better idea and more to go on.

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[boatguy]

Thanks again. Working fine now.