Inserting Into A Primary Key Field

I have a field couponID as the primary key in my table - when writing the insert statement how do I get the autonumber value to be inserted? below is the code that I have, but it doesn't work

sql="INSERT INTO coupon (Value, ValueSecondLine, ValidThrough)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("value") & "',"
sql=sql & "'" & Request.Form("validSecondLine") & "',"
sql=sql & "'" & Request.Form("validThrough") & "')"

conn.Execute sql

View Replies


ADVERTISEMENT

Inserting New Field.

How can I insert a new field in a MS Access database table. I've already got the following but I can't get it to work with a default value. Quote:

ALTER TABLE Articles ADD 'Moderated' number

How do I add a default value?

View Replies View Related

Inserting Data Into Bit Field In An Sql Database

I have an ASP variable called IRNvar:

If IRNvar(0,num) = "True" then
IRNvar(0,num) = 1
else
IRNvar(0,num) = 0
end if

In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement:

SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')"

Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.

View Replies View Related

Inserting Value From List Box Into Database Field

My question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:

View Replies View Related

VBasic Text Field (phone Number) Calculating Data Before Inserting Into Access

I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?

View Replies View Related

Primary Key

Let's say that someone trying to insert a record in the primary key which already exist...
it returns an error, and in fact that error:

Error Type:
Microsoft JET Database Engine (0x80004005)
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again
How can I replace that error with a friendly message such as "that record already exists"

View Replies View Related

Order By Primary Key?

how to display search results on my web site in an order that I specify. at the moment there ordered by the primary key which means there all over the place.I know what the code is but I'm not sure how to use it, can anyone give me a quick lesson, does the code need to be on the search page or the results page?

View Replies View Related

Primary Keys

Does anyone know how I can open up an entry in a microsoft access database table using its primary key through asp?

View Replies View Related

Insert With Primary Key

I have a table in MS SQL Server 2000 that has 4 fields, one of which is a primary key. How can I insert a new record and have SQL Server automatically handle the primary key field? I've tried the following SQL code:

Code:
INSERT INTO orders(TransCode, TransTime, TransAmount) VALUES ('stuff', 'stuff', 'stuff')
but it fails because the primary key is left NULL. I'm sure there is something really easy that I'm missing here.

View Replies View Related

Ascertain Primary Keys

Is it possible to ascertain which fields are the primary keys from an Access table just using asp? If so how?

View Replies View Related

How To Set SQL Primary Key To Auto Increment?

I just want to make the primary key so that it auto increments. Thanks

Code: .....

View Replies View Related

Creating Primary Keys

creating a script that will create a primary key base on the date today and a number ( ex. 1124204-1, 112404-2) with the last number increasing by one. the script should automatically increase the number if the key has already been used.

View Replies View Related

Auto Generate A Primary Key

I wan to ask isit can generate a primary key before to insert a new record from
asp to database (ms. access 2003). wat coding should i write for generate a primary key
that unique? i cant find a solution to do that. my primary key will be sequences like :M0001, M0002...... follow

isit possible i genrate a primary at ASP pages before store/insert into the database?

View Replies View Related

Retreiving Primary Key On Nxt Page

basically i have given each customer, in tbl_user, that goes through the first page an "autonumber" (userID) and then each window has this same userID for each window that user selected. so i can then see the relationship between what user wants what windows.

My trouble is that im having difficulty creating a system where the correct userID is entered with the window Code:

View Replies View Related

Fetch Data Wirh Primary Key

I'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box.

View Replies View Related

Trap Primary Key Error (ASP, SP And SQL2000)

I have a table in SQL 2000 with a composite Primary Key on coulumns Instrument_ID (int) and WeekOf (smalldatetime.) I am running asp on win 2003. Code:

View Replies View Related

Insert Problem With Primary And Foreign Keys

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Sybase][ODBC Driver]Integrity constraint violation: no primary key value for foreign key 'MemberCode' in table 'PersonMember'
/admin/Member_New-Sybase.asp, line 39

What i am doing is first i have added a record to my persons table the next step is i need to add this person id to the PersonMember table with a new MemberCode and then finally add more information to a membership table. Code:

View Replies View Related

LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause

I am using a Relational database for my site and i have the following tables:

FIXTURES, GAMEDATES

the fields in FIXTURES are:

GameDate
Home
Away

(All of the above are numerical fields)

the fields in GAMEDATES are:

DateID(integer)
GameDate(#Date Field#)

What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)

The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:

WHERE Fixtures.GameDate<=(Date())

obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.

The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.

Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data

View Replies View Related

Comparing Field Data From Previous Field

Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData

This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?

View Replies View Related

Fill Field Based On Another Field

I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.

I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.

I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).

View Replies View Related

Pass Hidden Form Field Value To Another Form Field To Insert In Db

I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.

(The hidden value (1 for example) would then automatically get passed to the
other input field.)

The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:

View Replies View Related

How Can I Change One Line Input Field Into Larger Input Field

I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.

All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:

View Replies View Related

ASP Inserting (')

There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.

View Replies View Related

Inserting Into

I get the following error message

Microsoft VBScript compilation error '800a03ee'

Expected ')'

/weblinkup/chat.asp, line 1775

oConn.Execute("INSERT into chat (username,nametext,roomname,type,priv,thetime,msg) VALUES ('" & username & "', '" & username & "', '" & Roomname & "', 'msg', '0', '" & now() & "', '" & username & " has just said " & emotetarget & "." ')")

what the problem is with the code?

View Replies View Related

Not Inserting

i have a database Access with Book Table and Author Table. now i have created a form which inserts info submitted into the Book Table, yet it keeps giving me this error "You cannot add or change a record because a related record is required in table 'Author' " while the names of the authors are all registered.

it works in Access but not in asp it doesn't make much sense. People just enter the names of the books which their authors are in the Author table. it keeps giving me error. how to know why this is so?

View Replies View Related

Bulk Inserting

I have an error as follows:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.

My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?

My codings:

strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =

'
')"

Response.Write ("test")
Set oRS = conn.Execute(strSQL)

View Replies View Related

Inserting Database

I had some Error when i write the update sqlp query


Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"


Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"

View Replies View Related

INSERT INTO Not Inserting

I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:

INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')

View Replies View Related

Inserting Data

I'm wondering if it's possible to create an instance of an ADO Recordset and add values to it by ASP ??

Ex :
I have 2 arrays :
arr1 = Array(1,"allo")
arr2 = Array(2,"bonjour")

Is it possible to add these 2 arrays into a Recordset to manipulate de data more easily?
If yes, could you provide me with a little example to see the synthax, because I tried almost everything and it didn't worked at all

View Replies View Related

Inserting Smilies

how do i design my site interface such that users can insert smilies along with text in the form field just like it is here on sitepoint...

View Replies View Related

Inserting Record

i've tested my code and it seems to send back an error, when i'm trying to insert a record into my db (sql server)
Basically when I udpate one of the records it's fine ( I update at a certain "productID")
But when I insert a new record it sends back an error telling me that my "productID" can't be a null value?Any ideas on how to fix this?

View Replies View Related

Inserting Apostrophes Into DB?

When I insert info into a DB from a form, it cuts the string off at the first apostrophe (").

How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data:

View Replies View Related

Inserting And Downloading

I am developing web pages , therein doing database
connectivity using ASP with Microsoft Access.I want to

insert a file (.opt/.pmopt) into a field 'OLE Object'. Also

I want to display that file name in tabular form and a link
to download that file.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved