Coma at the end of each eanswer of my checkbox
I have a simple query for a list using checkbox :
<cfloop query="getlist">
#thingstodo# : <input type="checkbox" name="thingstodo" value="<br/>#thingstodo#"> <p>
</cfloop>
So it will apear like this :
Some list of things to do 1 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 1"> <p>
Some list of things to do 2 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 2"> <p>
Some list of things to do 3 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 3"> <p>
Some list of things to do 4 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 4"> <p>
My problem is it adds a coma at the end and this is how it looks in the database :
<br/>Some list of things to do 1,<br/>
Some list of things to do 2,<br/>
Some list of things to do 3,<br/>
Some list of things to do 4,<br/>
Some list of things to do 5,<br/>
I tryed using replace before i send it in the databse but i think i'm doing it wrong plus some of the text in the list might have a coma in it so this might not be the answer:
<cfset thingstodo = Replace(thingstodo, ",","","ALL")>
Thanks for your help
