469,623 Members | 1,800 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Additional blank record inserted ?

Hi,

I have the following code which adds a record to a table:

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

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

adoDataConn.Execute (uSQL)

Why does this insert the single record plus a blank one ?
Thanks
David
Jul 19 '05 #1
4 1538
What makes you think that's what's happening? Where are you seeing this
blank record? What kind of database?

Ray at work

"David" <da***@scene-double.co.uk> wrote in message
news:c1*************************@posting.google.co m...
Hi,

I have the following code which adds a record to a table:

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

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

adoDataConn.Execute (uSQL)

Why does this insert the single record plus a blank one ?
Thanks
David

Jul 19 '05 #2
Based on what you posted it's impossible to say with any reliability. The
SQL appears to be fine. Is there perhaps a trigger on the table that would
insert another record based on some arbitrary condition? And, how do you
know there's an extra record?
"David" <da***@scene-double.co.uk> wrote in message
news:c1*************************@posting.google.co m...
Hi,

I have the following code which adds a record to a table:

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

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

adoDataConn.Execute (uSQL)

Why does this insert the single record plus a blank one ?
Thanks
David

Jul 19 '05 #3

Hi Ray,

I am running an MS Access front end app with tables in a MySQL DB on our
Linux Server, which are import-linked back into MS Access. The ASP
updates the MySQL DB.

A/ I can view the records in a form in MS Access which shows all users
under a specific customer.

B/ When I view other pages in my asp app, they list the users and a
blank record ?
David
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #4

"David Gordon" <da***@scene-double.co.uk> wrote in message
news:eH****************@tk2msftngp13.phx.gbl...

Hi Ray,

I am running an MS Access front end app with tables in a MySQL DB on our
Linux Server, which are import-linked back into MS Access. The ASP
updates the MySQL DB.

A/ I can view the records in a form in MS Access which shows all users
under a specific customer.
Doesn't Access often leave a blank row so you have a place to start typing
if you want to add a record?

B/ When I view other pages in my asp app, they list the users and a
blank record ?


That could be coming in from some flaw in coding or something, like
forgetting that arrays are zero based or something along those lines.

Ray at work
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Miran Kopmajer | last post: by
2 posts views Thread by M Fisher | last post: by
20 posts views Thread by Bryan | last post: by
9 posts views Thread by =?Utf-8?B?UHJhdmlu?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.