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
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
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
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
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 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