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 4 1758
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
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
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!
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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...
|
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...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |