best way of using INESRT statement ??

[David]

Hi,

I have a form which submits fields to add a new record to my table.

I have the following code:

__________________________________

vUser = request.form("user") 'PK in table (not autonumber)
vPass = request.form("pass")
vEmail = request.form("email")

uSQL = "INSERT into OrderStatusAccess (UserID, Password, Email,
CustomerID) values ('" & vUser & "', '" & vPass & "', '" & vEmail &
"', '" & session("customer") & "');"

adoDataConn.Execute (uSQL)

______________________________________

The problem:

This code just inserts a blank record at the top of my table, so that
when I go to view all the records listed for that table, nothing
shows, because the first record is blank.

UserID is the PK for the table OrderStatusAccess.

Any ideas ?

David

 

[Dave Anderson]

uSQL = "INSERT into OrderStatusAccess (UserID, Password,
Email, CustomerID) values ('" & vUser & "', '" & vPass &
"', '" & vEmail & "', '" & session("customer") & "');"

The problem:

This code just inserts a blank record at the top of my
table, so that when I go to view all the records listed
for that table, nothing shows, because the first record
is blank.

What results from this?

Response.Write(uSQL)


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[David Gordon]

Thanks Dave,

I fixed my code by reading what was printed....my fault.


David