I am trying to get a Update script for ASP/Database/SQL, lol. I want to update a field on a users account. Its like his money. Right now when it updates it does this: 1, 11, 111, 1111, 11111. I need it to do 1, 2, 3, 4, 5, etc. Any help would gretly be apreciated, Thanks.



~Isaac~
www.swfoc.com

I don't know ASP but would probably work if you had it pull the number from the database by method of a quiery. add one then update the record.

Well heres some script below of what I am working with:


<%
If Request("Action") = EditB Then
Set DB = Connect()
SQL = "UPDATE Users SET GP = '" _
+ Request("GP") + Request("GP1") + "' WHERE Username = '" + Session(SiteID + "Username") + "'"

Response.Write SQL
Set RS = DB.Execute (SQL)
Response.Redirect "welcome.asp"
Else
Set DB = Connect()
SQL = "SELECT gp FROM Users WHERE Username = '" + Session (SiteID + "Username") + "'"
Set RS = DB.Execute (SQL)
End If
%>


GP= there Money$
GP1= the number 1 that needs to be added to there cureent GP. Again any help would greatly be apreciated. Thanks.


~Isaac~