ASP :: Insert Statement-check

Check For Duplicates Before Insert...
I've got a form that allows the user to search a table for data and if it finds that the data is not there, it should insert what is missing into a new table. But I'm not sure as to how I would check the records before I insert records. Code:

Asp Sql - Check If Update Else Insert..
I'm using a database to store the products in a basket.

It's this scenario:
A visitor already has some products in his basket and wants add some new ones.

Now, first I want to check if the selected products aren't already in the database.

1. if they are -> update the product when the amount number is changed
2. if the product is not in the database then insert it.

I'm stuck at the point that I can't retrieve if the database is updated, so I can either stop the query or insert the new product.

Java has a statement like getUpdateCount(), but ASP/VBSCRIPT??

I want the fastest solution, i dont want to retrieve the data twice and compare them to check if it changed..

IF Statement To Check If The Cookie Exists
How do i relate to cookies? i mean if i want do to an IF statement to check if the cookie exists or something what do i write?

Check Entered Form Values And Insert Them To Db
I have this page set up at www.kevinhall.org/headcount/headcount.asp
what is the easiest way to check where the user has entered a value
and submit the row to the db. Maybe i'm going about the form wrong.
Each box has its one name but I was hoping i could get around using a
request.form on each one and useing the isEmpty. Its so tedious and
non efficient there has to be an easier way.. Maybe with .net possibly?

Is It Possible To Check If Session Cookie Exist With A Simple If Then Statement?
I am making a news letter application for my company. The idea is that if the cookie (fictional name Frankie ) don't exist a newsletter is being sent to all subscribers.

Insert Statement
I have an asp page which runs an update into our mysql database.
The only problem I have is that a user selects a customer from a
dropdown (this is database fed), and I require the selected item to be
loaded into the db.

All I can get in the database is the first part of
their name upto the first space ?

i.e. if the selected item from the dropdown is A B Knowles, the
database entry is 'A'

cust = request.form("customername")

I have tried adding ' " & cust & " ' for the insert statement

What do I need to do to fix this minor glitch.

Insert Statement
i tried to insert data's to a table and its working ..but the only problem is when i click the button Submit(to add data)its adding 2 rows of data... 1 is the data's which i entered n the other 1 is a blank row of data...so when i log out n run the form again..error occured.. saying that confilcts in a primary key.. coz there is a blank rows in the table... Code:

Getting The ID From An Insert Statement
I am using ASP to talk to an SQL database. Most of my tables have a primary key named 'ID'. Is there a way to grab the ID of a record in the same line as the INSERT statement?

INSERT Statement
For some reason my page is giving me the dreaded syntax error.
Can anyone see what is wrong? It's probably something simple...it always is.Code:

sql_insert2 = "insert into users (PayrollNo, Firstname, Lastname, Password) values ('" & Payroll & "', '" & Firstname & "', '" & Lastname & "', '" & Password & "')"
Con.Execute (sql_insert2)

INSERT Statement
The block of code below shows how I am inserting field values into my dbase table:

strSQLStatement = "INSERT INTO tblArticles
(handid,ArticleDate,sport,articleheader, fpick,articleText) "_
& "SELECT '" & handid & "' As handid, '" _
& ArticleDate & "' As ArticleDate, '" _
& sport & " As sport, " _
& articleheader & "' As articleheader, '" _
& fpick & "' As fpick, '" _
& articleText & "' As articleText;"

Conn.Execute(strSQLStatement)

but I am getting an "Insert statement contains fewer items than the insert list" error , when in fact I am not (both 6 field names).

Insert SQL Statement
how can i write an insert whereby.my attributes in Mainshift table is shiftdate, line, shift & description. ShiftDate and Line is the primary key.so i want to insert the shiftdate, from today's date until around 31st Dec 2008 and line i want to do a select distinct statement where i will extract from execmaster table.

for the shift i want it to be a default "2". for the description all is all "working day"can anyone help on how to write an insert statement on this?

INSERT Statement
This variable, dteEmpDow = WeekdayName(Weekday(Date)), produces this error when using an INSERT statement to Access db:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

The Access db field is set to recieve a date/time data type.do I have to convert it somehow?

Insert Statement
I am using simple insert statement that works fine but it doesn't work when you put " ' ", for example "let us" works not " let's us" because of ' sign....

is there anyway user can add anything?

ASP Variables And INSERT Statement
Can any one tell me what is wrong with this insert statement:

sql = "INSERT INTO Questions (Question,SurveyId,CatId) VALUES ('" & question & "','" & surId & "','" & Sig &"') "

and why when I print it to screen, it shows this:
INSERT INTO Questions (Question,SurveyId,CatId) VALUES 'this si a test','38, 3','');

I have used similar and it works, they are the right values bit wont work..?

Performing Insert Statement
I have a asp page that contains link(A href tag) to some other page.When the user clicks on the link ,I want to perform a insert SQL statement and then link it to target page.Is it possible?

Insert Statement Problem With ASP
I have been working on this problem for a long time and cannot figure out why i am getting a problem. Code:

Building An INSERT Statement In ASP 30
I have an old web app that ues an Access database and ASP 3.0. I need to build an INSERT statement based on the contents of a form. What is the best way to handle blank text boxes that are submitted with the form?

For example, I collect all my name/value pairs that are submitted with the form like this... Code:

Problem With Insert Statement
Been trying this for over 2 hours now, and I can't seem to figure it out. I tried browsing these forums for any clues but can't find a problem quite like mine.

Dim conn, rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("database.mdb") & ";"

sql = "INSERT into booking(numid, carNo, workshop, bookDate, bookTime, status) VALUES('"& tempNum &"', '"& carno &"', '"& workShop &"', '"& bookDate &"', '"& bookTime &"', '"& status &"')"

conn.Execute (sql)

I keep getting a "Operation must use an updatable query" error message.

Insert Statement Problem
Having a problem with my change password code. It bombs on the INSERT statement.....I get an error stating thier is a syntax error in my insert statement but I can't figure out where. The delete statement works fine and yes all the variables are getting passed. Code:

Access Insert Statement
I am used to SQL Server, no Access, but this one thing has to be done in
Access. Can you tell me if this query will work, based on the syntax?

I am trying create a new row on the database, in one table, and the primary
key is an Autonumber called PersonalID. This is on the second page, which
shows after the personal has filled out some info on the first page, then
submitted the form using POST. Database name is Shape, and table is named
Personal. Code:

Error On Insert Into Statement
i have this error on the regisration page of the website i'm doing.
Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/Shop/register_process_corp.asp, line 40

SQL = "INSERT INTO
------------------^

Code:

Insert/select Statement
How can i get the autonumber(primary key value) from the specific rows when i just insert it.Example

i just insert the member information.
sql="INSERT IMTO register(user,password,address) VALUES (shujuan,841218,singapore)"

so how can i get the autonumber value for this row after i just create it.

Pass PK And FK To Do INSERT Statement
Three tables: Registration, Session, Payment: Joined with 1 to many rel. starting with registration, moving to session and ending with payment.
Form 1: Registration= INSERT INTO statement works fine. Reg table now has fields populated with form data.
Form 2: Session= <<<<<this is where the problem occurs>>>>>
Form 3: <<<<<<problem as well>>>>>>

When i want to do another INSERT INTO statement, I have to know the RegID from the earlier table join(registration). Of course, I can't run either Form 2 or Form 3 without knowing the RegID from the Registration table begin point.

I don't know how to increment the RegID as a foreign key in a joined table over the internet. Using Access over the network it's real easy to pass the foreign keys and the design seems to be more flexible this way, but I need to update tables and present stored data to the user across the internet.

Multiple Insert In SQL Statement
i have a problem while running an insert query into SQL using ASP. sometimes the query inserts the values twice.

AddNew Or Insert Statement
I want to know the opinion of you all great guys out there whether AddNew method of recordset is better to use & secure than simply a insert statement.

Looping Through SQL Insert Statement
I dynamically load a question into a form along with its answer and its name (1,2,3...).
It's name is the the numeric value loaded but I ad on: Code:

Syntax Error In INSERT INTO Statement.
Now I know I posted this elsewhere twice but no one seems to even be looking at them. I really am stumped by this problem.

I recieve the error:
Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/quizmaker/admin/create_teacher.asp, line 20

DIM mySQL
mySQL = "INSERT INTO users(user, password) VALUES('"& uname &"', "& pword &")"
USERS1.open mySQL , objConn <----- Line 20.

Syntax Error In INSERT INTO Statement???
Syntax error in INSERT INTO statement.

Please download the attachment and unzip it.

I have 4 files:

Starting with "signup.asp" - fill up the registration form. this will forward you to next form.

"signup_process.asp" - process the filled form
"signup_success.asp" - indicate that register successfully
"Database.mdb" - the database file (MS Access 2000 format)

My problem occurs in "signup_process.asp".
The error message found in IE:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/myweb/signup_process.asp, line 31

I look through my code, but found no mistake.

But why still I cannot add the information in the form into the "Database.mdb"?

Syntax Error In INSERT INTO Statement
I've see this error message when I try to submit my form..

Help with Syntax error in INSERT INTO statement. line 153

Here's the SQL Code:

Insert Statement Dropping Values
i'm reading in a .csv file and then inserting the data into a mssql db. batchid sometimes shows up blank. the values that are disappearing begin with the letter "N", such as "NP2338" or "N00312". outside of those that begin with "N", the rest are a five digit number. the table field is varchar. why is it dropping those that begin with "N"?

Problems With Insert Statement Using SSL(Verisign)
I am having problem with the following Insert Statement when used on Production Web server with SSL(https://...., Verisign).

This doesn't occur everytime. Our studies shows that it is occurring approximately between1-2% of the total applications/Year(70-80K).

After adding some debugging, the insert statement, after failing, is giving
the following error:

Error NUmber: #-2147217833
Error Desc[Microsoft][ODBC driver for Oracle][Oracle]ORA-01401: inserted
value too large for column

Ironically, 75% of the time, when the users resubmit the page the record
will be inserted. Code:

Syntax Error In INSERT INTO Statement
My Code is as follows, im basically trying to get the value from a radio button from another page for a vote, take the value thats allready in the table add 1 to the value and then insert it back into the database, then create a voted cookie and redirect back to the same page to view the vote results. Code:

Auto-escape INSERT Statement
I have a 'memo' form field being entered into an access database.If people put in characters other then text (Quotes, operators, etc) then I get an insert error:
----
User Input: oh let's see - a va

Error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''oh let's see - a va', 'No additional comments submitted')'.
----

Is there a way to get this into the database? In php, I would simply use the function 'addslashes()' (escaping the string) - is there a similar function in ASP or am I doing something else wrong?

Syntax Error In INSERT INTO Statement.
I keep getting the same error... Syntax error in INSERT INTO statement. (line 14) Code:

INSERT Statement Error In .asp File
I am making a masters page with delete, update , and insert fuctionality, i am using the insert.asp page with a form to submit the data and insert it in the database by prossesing a seperate page called insert_prosessor that has the Insert Statement to insert the data.

Now i am having trouble with the insert_prosessor as it's ERROR message reads" syntax error in INSERT Statement" I cant find the problem.. Code:

Question On Syntax Error In INSERT INTO Statement.
Usually on our server we see or can view source to see where in the INSERT statement something got messed up. I have debugging on but when I run a test, I get the following error:

Syntax error in INSERT INTO statement.
Line 57

It is a very long INSERT statement but for the life of me, I can not see where it is wrong. What I am wondering, if all I am seeing is "Syntax error in INSERT INTO statement. " does this mean it is at the beginning of the statement since i do no see any of the actual data on the error page?

Insert Statement Executing Repeateadly On The Page Refresh
i have a form that action is set to itself, on the same page i m having the insert statement, executed when i submit that form, but when the user refresh that page the query is executed and submit the null values in the table.

<form name=form1 action=form1.asp method=post>
<input type........
<input type.......

<input type=submit value....>
<input type=hidden name='insert' value=1>
</form>

<%
if request.form("insert") = 1 then

Execute the insert query

End If

%>

Build DB Insert Statement Dynamically - Loop Form Elements
When you submit the form you can see I am trying to get the each row of the form elements into a format such that I can build multiple insert statements. Here is what I am working with:

<%
Dim x
For x = 1 to Request.Form.Count
Response.Write Request.Form.Item(x)
Next

Would I use some type of Mod operator on the value of x to determine my line breaks?

Error '80040e14' Syntax Error In INSERT INTO Statement
I'm having a very difficult time with an ASP page that I develpoped in Dreamweaver and the MS Access DB it's supposed to update. When I submit the data the following error appears:

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/sessiondata2.asp, line 115

I know this is usually a reserved word issue but I don't think that's the case here because the page updates perfectly when executed on my computer as a testing server.

The rest of the site updates data into the database properly so I know the connection string is working. I can't figure out what would throw an error on a live server when there isn't one on a testing server. Code:

Check For .Net From ASP
I'm working on a "hybrid" application some classic ASP, and some
asp.net. I'm trying to develop a support type page that checks necessary
components, database connections etc.. last item is to check for the .NET
extensions. Is there a way to do that from a classic ASP page?

Check IP
let say:

http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp

can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page?
so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.

Check Box
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?

Check Box Value
i got a list of checkboxes and radio button with the recorset paging function. let said i got the paging list << 1 2 3 4 5 >>. i set each page is 10 records. and every record got one checkbox for DELETE ID usage.

in the first page, i check 5records, then i go to second page, i checked another 5records. but why it cant keep the value for the first page 5records when i go back or go to next pages?

Age Check
Does anyone know of any nice ready made asp scripts to check a website's visitors age? I mean the sort of thing you see where you have to choose your day, month and year of birth from drop down lists to comply with US laws Code:

Check If Is Int
I'm trying to guard against SQL injection, but I have an ID number being embedded into a querystring for MSSQL table selection.

Is it good enough just to check if the querystring value is an int, if so could you quickly remind me how to check that. In PHP we use is_numeric or is_int.

Check If Page Is Down
I would like to check if a website is currently down, but don't know how to do this efficiently. I do not have access to the remote server. I have tried using XMLHTTP, and it worked, it just took a long time and I felt it wasn't effecient enough. Is there some other way to check if the website is up or not using ASP?