Currency. Can somebody help?

[ferhelping]

This is a piece of code from my ASP page. Everything works fine but when it is displayed, the database sends the PriceGlass and PriceBottle as text, without the currency format. I need to make them display as currency, as they are in the database, with the $ symbol.

<% ...

while (!cursorW.EOF){
Response.Write(&quot;<tr><td>&quot; + cursorW('WineID') + &quot;</td>&quot;
Response.Write(&quot;<td>&quot; + cursorW('WineName') + &quot;</td>&quot;
Response.Write(&quot;<td>&quot;
Response.Write(cursorW('PriceGlass'));
Response.Write(&quot;</td>&quot;
Response.Write(&quot;<td>&quot;
Response.Write(cursorW('PriceBottle'));
Response.Write(&quot;</td></tr>&quot;
Response.Write(&quot;<tr><td></td>&quot;
Response.Write(&quot;<td colspan='3'><pre>&quot; + cursorW('WineDescription') + &quot;</pre></td></tr>&quot;
cursorW.MoveNext();
}

... %>

Please help me.

Thank you very much. [sig]<p>Fernando Regueiro<br><a href=mailto:ferhelping@yahoo.com>ferhelping@yahoo.com</a><br><a href= > </a><br> [/sig]

 

[KenKasmar]

Try this:

<% ...

while (!cursorW.EOF){
Response.Write(&quot;<tr><td>&quot; + cursorW('WineID') + &quot;</td>&quot;
Response.Write(&quot;<td>&quot; + cursorW('WineName') + &quot;</td>&quot;
Response.Write(&quot;<td>&quot;
Response.Write(formatcurrency(cursorW('PriceGlass'),2));
Response.Write(&quot;</td>&quot;
Response.Write(&quot;<td>&quot;
Response.Write(formatcurrency(cursorW('PriceBottle'),2));
Response.Write(&quot;</td></tr>&quot;
Response.Write(&quot;<tr><td></td>&quot;
Response.Write(&quot;<td colspan='3'><pre>&quot; + cursorW('WineDescription') + &quot;</pre></td></tr>&quot;
cursorW.MoveNext();
}

... %>

Later,
Ken Kasmar
Red Falcon Internetworking, Inc. [sig][/sig]