Adding Records With Autonumber Field
I'm writing a database admin page in ASP. I had it adding records correctly. Then I added an autonumber field ("ID") to the table, and it stopped working. The sql I'm using is Code:
View Replies
ADVERTISEMENT
Get Value Of Autonumber-field
I use (something like) following code to add new records to a database, but it doesn't work!!! I need to know the value of an AutoNumber-field when I add the record. Why doesn't it work and how can I make it work? I think it should be easy, but I can't figure it out! Code:
View Replies View RelatedNext ID From Autonumber Field
I have a page that does an insert into a table in an Access DB which has an autonumber primary key field. Following this insert I need to be able to get the ID that was generated. If I were using SQL Server I would simply return fetch @@IDENTITY from a stored procedure for example.
Does anyone here know of something similar I can use in Access to be able to get that ID? I tried just using a SELECT query with all the information I had just inserted but it comes up empty unless I put it in a separate request (i.e. redirect to a new page passing all the info through the querystring and then building the query on the redirect page...which is a huge pain and takes FOREVER to run.
Determine If Field Is Autonumber
I have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
View Replies View RelatedAdding Records
I have a table with 2 fields, name and value
I need to be able to add multiple records quickly, for example I need to add
name value
abc 1
abc 2
abc 3
abc 4
abc 5
abc 6
etc etc, does each record have to be added separately, or is there a way I
can add a chosen number of records, lets say 10, and have the value field
increase by one each time?
sometimes I might have 30+ simple records that need adding quickly, and each
time the first records value will be one, and each record after will
increase by one, is there a way to solve this problem or does each record
have to be added separately?
Adding Records
I have a drop down which has numbers from 1 to 25
When a user selects 3 he will see 3 first name textboxes and 3 last name textboxes
the user fills them out and hits the submit button
three records are added to the table
i have a for loop for adding records
Here is my code:
Adding Different Records
Just when you think something is working, suddenly something new comes along.this is my situation: I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.
SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue
Or can I do that in ASP? doing something like (my example doen't work)
<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>
in the mean time I'll be looking around for an answer to my lack of know how.
Loop + Adding Records
I have loop displaying certain records depending on an id number in my sql database. What i need to do using asp is total all the numbers in one of the fields and display that as a response.write.
View Replies View RelatedDeleting And Then Re-adding Records
I may have made a typo somewhere. I am trying to delete collections from RelProdCollection Table that has a certain record with Product ID number of __ and then readd them based on the user's choices on the edit form. Code:
View Replies View RelatedAdding Values From Records
I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.
SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue
Or can I do that in ASP? doing something like (my example doen't work)
<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>
in the mean time I'll be looking around for an answer to my lack of know how.
Adding Records To Data Base?
I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:
View Replies View RelatedAdding Multiple Records With Checkboxes
SQL 2000 database with ASP
I've found many things "out there" regarding updating and deleting
multiple records with checkboxes but I can't seem to find anything
about adding them. A user wants to create a price list for their
client and they need to add parts to it in a separate table. I would
like to display the list of parts and the user would select multiple
parts to add to a price list by checking a checkbox and submitting the
form. Code:
Problem With Adding Records To A Table
There is something wrong with the adding code. It will add sometimes. It's a large database where I have to add records to multiple tables.
The products table doesn't work correctly. Maybe there's a typo somewhere that I don't notice. Please look at the bolded part of my code and see if you can catch something. Code:
Adding Records To Multiple Tables
i have an instance where I need to add records to 2 different tables. i know how to do it basically, but the problem is, one table is generating a key number and i need this number for the second table records.
how do i put the appropriate records into the first table, grab the id number and insert the records into the second number? the information is coming from a form. i'm developing in an access db but will be moving this to an ms sql db before it goes live.is there a stored procedure that might make this easier? i know nothing about stored procedures.
Adding, Deleting Records Using Global.asa
Can I do the following things in the global.asa file?
When sessions starts:
Add a record into my database
When session ends:
delete it where rs("sessionid") = Session.SessionID...
?
I'm pretty sure I can, but...I've heard not ALL things can be done in global.asa...
Do I create an object, and a connection? How would I do it? Since I want a database in MY database, not in memory like I've seen...
Adding A Sort On A Field
How to I add a hyperlink sort on a field so that the end user may sort either asc or desc?Here are the file and .inc file.
View Replies View RelatedAdding All The Numbers On A Field
i know this is a very lame question but dyu have any idea on how to add all the number on a specific field?
for example
AGE
3
4
7
4
6
8
then i want to get the average age...
is there a sql command for this? and how do i display it on my asp page?
Error In Deleting,updating And Adding Records Using Asp!
I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:
View Replies View RelatedAdding Records To Tables Via Dropdown Boxes
I have a form that uses Code:
<select name=player_id multiple>
<option player_id="<%=player_id%>"><%=FName%> <%=LName%></option>
</select>
To create a drop down selection list. What I want to send to a table is FName and LName instead of the ID. Any hints on how to do this.
Field Order For Adding To Tables
if the order of the fields in a query matters when querying a table with asp. that is, if the table has columns labeled "RecordID, FirstName, Initial, LastName, etc" in that order, do i have to do my "INSERT INTO" command with the fields in that same order, or could i do "FirstName, RecordID, LastName, Initial, etc" ? i think it doesnt matter. am i right?
View Replies View RelatedAdding Records With Client-side Excel File
With ASP, how can I automatically add records to a database with an excel file residing on the user's machine? Assuming the excel file has the same field names/datatypes/order as my database table's fields.
View Replies View RelatedUpdate A Field For A Bunch Of Records At Once?
My products table has a weight field that I need to populate. A bunch of them have it and a bunch of them don't, but I need them all to have one. The weight is the same, 3, for all the records. I also have an Include field in that table. I want to make the weight field 3 for all records where the include field is true (it's a yes/no checkbox in access.)
I'm using Dreamweaver and I can build the SQL statement just fine but I'm not sure of how to loop through this to set the field for each of these records.
Delete Records Using A Date Field
I've got a table with three fields:
ref (Autonumber)
notice (memo)
expdt (Date)
I'm trying to use an SQL statement to delete all records where expdt < the current date (Now). Here is the code I'm using:
<%
If Request.Querystring("act") = "clean" Then
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ConnStr
strExpdt = cdate(Now())
sql = "DELETE FROM tblNboard WHERE expdt < " & Now()
conn.Execute sql
conn.close
set conn = nothing
strResponse = "All expired notices have successfully been deleted."
End If
%>
However, this just gives me the following error:
Syntax error (missing operator) in query expression 'expdt < 11/12/2003 19:54:25'.
What am I doing wrong??
How Do Find A Empty Field/value/records?
I know it should be very easy but I am new in ASP so I could not figured out.
Here is the simplified version of my code:
thePaymentID= request.querystring("IDValue")
SQLqueryPayment= "SELECT sum(paid) as paid, sum(Interest) as interest
FROM payment WHERE payment_ID =" & thePaymentID & ""
dim rstempPayment
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DSN=payment"
set rstempPayment=conntemp.execute(SQLqueryPayment)
fldValPaid = rstempOwner.Fields("paid").Value
------------------------------------------------------------------------
I need to find out if "fldValPaid" hold anything. I will use it an IF ELSE statement. In payment table a particular record could exist or not. How do I find out by evaluating "fldValPaid" if any record exists or not. I have to find out using "fldValPaid" ...I can not use number of record/record return or any other method.
Save Db Records Of A Field In An Array
I want to save db records of dates in an array something like the below(I know it's wrong, i'm just trying to describe what I want)... Code:
View Replies View RelatedStuck On Update Multiple Records (same Field)
how to update a database from a dynamic table with checkbox. Their is only one field I would like to change and that is the one with the checkbox.
I am using Dreamweaver and I create a dynamic table, add the update record and I get BOF EOF error. The database does have data in it. Code:
Returning Records Based On Time Field
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
Autonumber In Access
I've searched the net but I couldn't find any SQL code on how to insert an autonumber column into an access database and table. Can anyone include the code?
View Replies View RelatedGenerating Particular Autonumber
Ive got a table in an access database and I want to generate my own autonumber
based on the number of records in the table. Code:
Autonumber Fields
I'm creating a basic ASP guest book, keeping my guest book entries
in a Microsoft Access database, and using ADO to access it. My problem is
that I am using the autonumbered ID field to split my guestbook into pages
of 10 entries. It works for the most part, but if I delete an entry, a gap
is left in the records and I end up 9 entries instead of 10 on that page.
Basically I need a better way of sorting this out - I thought of SELECTing
all the records into an array first and then working from that, but I can't
get array to be dynamic enough in VBscript
One-line Autonumber
A portion of the asp for our site looks like this: Code:
insert = "INSERT INTO Students VALUES ( '" & _
(????)
CStr ( Request ("UserName") ) & "','" & _
CStr ( Request ("Password") ) & "','" & _
CStr ( Request ("Email") ) & "','" & _
CStr ( Request ("Country") ) & "','" & _
CStr ( Request ("DOB") ) & "','" & _
Date() & "@" & Time() & "','" & _
Date() & "' )"
It just inserts a new record into the db. What we did was add an autonumber field to the db, but now it won't update.
We know why - because it needs a value for every category in the db - but we don't know how to code it so it will update the db correctly. So, if anyone could help me with the (????) line in the coding so it will correctly update, that would be perfect!
Return Autonumber
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 primarykey for this row after i just create it.
Insert With A Autonumber Row
var SQLString = "INSERT INTO table VALUES( '' ,'" + Request.Form("name") + "','"
+ strAlpha + "','', '"
+ Request.Form("email") + "', '"
+ Request.Form("userid") + "')";
dbConnection.Execute(SQLString);
This is jscript inserting into access2000. My table looks like this:
id (autonumber)
name
date
email
userid
Its the first field that causing my problems, I get a data type mismatch error. How do I insert with an auto incremented field?