473,225 Members | 1,414 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

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 1743
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Ruben | last post by:
Hello. I am trying to read a small text file using the readline statement. I can only read the first 2 records from the file. It stops at the blank lines or at lines with only spaces. I have a...
3
by: Miran Kopmajer | last post by:
I have a problem with blank line inserted. Please help! This is how my SQL report looks like ACCEPT vf CHAR PROMPT "Vrsta fakture: " ACCEPT fk CHAR PROMPT...
4
by: YFS DBA | last post by:
How do I use VBA to insert a *new* record into a subform? I have a master form with client information, and a sub form with billing information. I want to click on a button ("Add Data") and have...
2
by: M Fisher | last post by:
Is there a way to get the autonumber of a newly inserted record? I am working with unbound forms, and using an append query to insert a record into a table. I am then using a select query that...
20
by: Bryan | last post by:
hello all... im trying to add a record to an sql db on ms sql server 2000, using vb.net. seems to be working.. except for one thing, one of the columns in the database is a bit datatype, and...
4
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
4
by: sparks | last post by:
I am trying to fix a database that someone did about 4 yrs ago in access97. The main table just contains demographics and is on the main form of the database. It has a subform on a tab that...
9
by: =?Utf-8?B?UHJhdmlu?= | last post by:
We are using .net Framework 1.1 We are having one page on which we are using this Grid component. From this page we open a popup for adding new record as well as for editing an existing record...
10
by: MLH | last post by:
Suppose, in a multi-user environment, you have append query SQL in a VBA procedure that looks like INSERT INTO MyTable... and the next line reads MyVar=DMax("","MyTable... You can never be...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.