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.
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 RelatedThis 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
%>
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
%>
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.
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