i have a field which has datatype as money
when i add a value in it like 110.00
rsadd("Amount")=txtamount
it comes like $110.00 which is right
what i want to do is instead of $110.00 i want -$110.00
i tried like this
rsadd("Amount")="-" & txtamount
when it added it came like this ($110.00)
The problem I am having is that I am trying to insert data from a form into a DB, but I cannot figure out how to change the form value (varchar) to the db value (money).
I've tried cast(bill_priceA as money) and I get
Microsoft VBScript compilation error '800a03ee'
Expected ')' Code:
I'm having some trouble converting my varchar datatype to money. Code:
View Replies View RelatedI can't get the following code to display only two decimal places.
-------------------
ProductPrice.Text = String.Format("{0:c}", ProductDetail.Price)
--------------------
Can someone tell me how i can only show two decimal places and also how i can just show rounded to an integer.
I am updating information in an SQL database through a form and I need to convert my varchar string into the money datatype in my database. Can anyone help me with the syntax? Here is the code....
View Replies View RelatedWhat regular expression would I use to take out all of the money (US amounts) from a string?
Right now I have:
Code:
Set RegularExpressionObject = New RegExp
With RegularExpressionObject
.Pattern = "$(.*)"
.IgnoreCase = True
.Global = True
End With
xmlText = RegularExpressionObject.Replace(xmlText,"")
Set RegularExpressionObject = Nothing
which obeously doesn't work. What should I use for:
.Pattern = "$(.*)"
??
I want to know,
. Operation Behind the Online Money Transaction.
. If Once The client paid the money,
. How is it validated..( Credit Card)
. Also how Can the Admin of the Site will get the Money from the User.
I need to add and subtract transactions for each of our accounts
within our Access DB for account reconciliation.
Values found in our PdAmount field are either positive or negative.
Positive numbers are entered like $690.34
Negative numbers are entered like ($42.36)
I will use something like:
<%
Do until rs.eof
If rs(PdAmount) <> "" Then
'need function to check for positive
'if positive...remove "$" and add to total
'if negative...remove "(", "$", ")" and subtract from total
End If
Response.Write(total)
%>
Can someone give me a function that I can use?
I think it has to be in this script that I have an error. I am new to ASP so Please help! If I need to include more script .....
View Replies View RelatedI need to allow user to save dataset to their computer in Microsoft Money
format. I searched internet for help on this but found nothing helpful. I
also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If
you will provide the steps yourself, please be very explicit in what you
provide.
how to write a function to calculate total amount to nearest penny in ASP using VBSCRIPT.
View Replies View Relatedhow to do the conversion of data type varchar to money Code:
View Replies View Related