hfshultz
Posts: 17
|
| Posted: 05/24/2004, 1:19 PM |
|
OK, I'm trying to get the return response from Verisign to create a record in my Credit table and fill in the echoed data from Verisign as well as the AUTH code. I have made a page with the following code in the "Before Show" event and can't get it to work at all... it's at least creating a record with 0 values but isn't carrying over anything.
Here's my code in the before show section:
Dim SQL
Dim Connection
Dim ErrorMessage
SQL = "INSERT INTO Credit (ClientID,AMOUNT) "&_
"VALUES ("& CCToSQL(CCGetFromGet("CUSTID",0),ccsInteger) &","& CCToSQL(CCGetFromGet("AMOUNT",0),ccsInteger) &")"
Set Connection = New clsDBconfdata
Connection.Open
Connection.Execute(SQL)
ErrorMessage = CCProcessError(Connection)
Connection.Close
Set Connection = Nothing
On Error Goto 0
|
