Here is the code that is writing the data to a table:<BR><BR> do while not rstemp.eof %><BR> <tr><BR> <% for i = 0 to howmanyfields<BR> thisvalue=rstemp(i)<BR> If isnull(thisvalue) then<BR> thisvalue=" "<BR> end if<BR> %><BR> <td width = "<%=col_width(rstemp(i).name)%>" align="<%=align(rstemp(i).name)%>"> <font face="Arial" size="1"><%=thisvalue%></td><BR> <% next %><BR> </tr><BR> <%rstemp.movenext<BR> loop%><BR>
Let me get this straight...<BR><BR>"thisvalue" is a number which you want to split up so that it contains commas? You haven't explained what you are trying to do very clearly. Can you be a bit more specific please?
Correct, "thisvalue" contains a number that I would like to contain commas. For example, "thisvalue" may contain a number like "500000" and I would like to show "500,000" in the output. The other pieces of the code contain scripts that format the columns in the table based on the field name.