FormatCurrency()

This is only part of my code. I want to add FormatCurrency() funtion before in/before the "salary" part. I should format plain number I request from my database (ex. 1000000) into $1,000,000. how to merge that two things together?

<%
do until rsEMP.EOF
response.write("<tr>")
response.write("<td>" &rsEMP("lastname")& "</td>")
response.write("<td>" &rsEMP("salary")& "</td>")
response.write("</tr>")
rsEMP.MoveNext
loop
rsEMP.close
%>

View Replies


ADVERTISEMENT

FormatCurrency

When inserting a value into a SQL Server DB of data type money, I have by value in the application formatted using FormatCurrency. When the value is passed into the stored procedure, do I need to strip off of the dollar sign ($), before passing in the value to the SP?If so, how would you strip off the dollar sign using the vbscript string methods?

View Replies View Related

FormatCurrency Function ()

I want to add FormatCurrency() funtion in/before the "salary" part. I should format plain number I request from my database (ex. 1000000) into $1,000,000. It would loop by itself.
Does anyone know how to merge that two things together?

<%
do until rsEMP.EOF
response.write("<tr>")
response.write("<td>" &rsEMP("lastname")& "</td>")
response.write("<td>" &rsEMP("salary")& "</td>")
response.write("</tr>")
rsEMP.MoveNext
loop
rsEMP.close
%>

View Replies View Related

FormatCurrency Question UK £

I've just finished a site for a client and am just sorting out some of the
finer elements of the site.

The client wants prices formatted like

£8

£11

rather than £8.00 or £11.00. If the price is £8.50 then it has to show
£8.50.

Could anyone advise on the syntax for formatting the price in this way? I
haven't got a reference book with this in, and haven't had much luck
searching the archive.

View Replies View Related

Error With Formatcurrency Statement

I got the following line in the formatcurrency statement that is giving error.

Response.write "<TD ALIGN=RIGHT WIDTH='10%' >" &
FormatCurrency(TotPersonnel) & "</TD>" & vbCRLF

The error message is: Error Type:

Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'formatcurrency'
/gwisprod/FSR_EditDetailPrint.asp, line 345

I found out that if TotPersonnel field contains null value, the above error gets generated.

View Replies View Related

Formatcurrency Puts ( ) For Negative Numbers

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How can I display the negative numbers with a minus sign infront like -111.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved