When I submit the Application form, various records are inserted into 10 different tables. The master table is taking the correct ID number, but the rest of the tables are showing "0" as the ID. Can anyone throw a light on what could be going wrong ?
View RepliesI'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
I have created an online database for a school project, and everything WAS going fine until today. I created the add record page and for some reason, whenever i try to add the records to the database THIS error message comes up: Code:
View Replies View RelatedI am working on a project, and now I am experiencing a problem to insert multiple records at a time. My form is designed so that a user can insert multiple input (in several text fields).
What is the best strategy to handle this? the number of fields are created randomly (I will use innerHTML in Javascript to present text field randomly on my form). I have tried to use google using the following keyword: "inserting multiple records using ASP", but the result page did not satisfy me.
although it seems that the database is updated the data doesn't pass to the table...Just the autonumber is increasing in the database without insering the records (the other records remain blank...like submitting nothing).. Code:
View Replies View RelatedIm having a hared time with this, im trying to update multiple records in a database from a form.
The form display all records from a search query and then the user selects whether to post the record of put the record on hold (two fields in the database).
Now everywhere I have looked I only see examples which update the records by using counts but I could end up with any number of records. I thought that using a loop would be an idea to get passed this.
Does anyone know how to upload or insert multiple records into a MS Database. I've been trying to figure this out all day with little success. It seems that their should be a way to upload a txt file or csv file and have all the records go into the dbase.
View Replies View Relatedi've created a page that displays a list of records with a checkbox next to each.
I'd like to give my users the option of selecting multiple checkboxes then clicking submit which will insert a new record for each of the checked option.
for example: Code:
what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships.
On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?
I want to insert records into a database using a loop. I've got a number of input fields named 1-50. I want to request each textfield and insert the data into a database table.
Whats the best way of doing this? I've tried a While... Wend loop but the loop seems to carry on.
i have a page where all my company records are disaplayed, now two records fit per page, so what i want to try and do is place a page break and a title after every two records so when its printed it prints them two per page with a a title on everypage.
View Replies View RelatedI want to insert multiple records in my SQL database. I was wondering if this is the right way to do it: PHP Code:
set insertRecords = Server.CreateObject("ADODB.Recordset")
insertRecords.ActiveConnection = mlConn
For i = 0 To 5
insertRecords.Source = "INSERT INTO Info (Name, Age) VALUES (" & getName & ", 20)"
insertRecords.Open()
Next
I am having trouble getting records to insert and update properly. This is not a consistent problem. It is intermittent. The page will allow me to correctly update 2 or 3 times generally, however after that it will double up the data in the insert and update.
Here is the code I am using. Code:
how to do a dnsless connection to an access database and then insert records. The database name is members and table name is member_info.
View Replies View RelatedI have a SP on a page and its working fine, well it works. For some
reason it looks like its getting executed twice and on the first time
it inserts the default values and the second it inserts the correct
values in the DB. Is it because i have another insert statment on the
page? Im not sure what you need to be able to help/suggest something
for me. Let me know what you may need.
I'm currently tring to insert data into an access db using asp. I have a form which is found in a popup window and which contains the fields Name and Comment. When I click on the Submit button,I call a javascript function in order to redirect the user to the page that will save the name and comment.
However,I am having an error like this:Field 'VoicesComment.Name' cannot be a zero-length string. The problem is that the value from the previous page in the popup window is not retrieved. I have tried retrieving the name entered and the page does not return anything.
The code for the page that is supposed to save data is as follows: Code:
I am receiving the following error when attempting to insert a new record into my database
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 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.
The code below works 1st time through, but on the 2nd invocation (with TOTALLY different data), I get the above error message.
My database is an Access 2003 database, and everything else works fine !
Also, if I'm really trying to write a duplicate record, why doesn't it fall into my duplicate trap? Code:
I am trying to insert data from a form into a database and i am getting the following error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
The code that i used can be seen below: Code:
I'm having a probelm with inserting data into a database using asp but I can't see what i'm doing wrong. I get the page cannot be displayed error ....
View Replies View Relatedwhen executing the piece of code below i recieve the following error:
"ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. "
I think it may have somehting to do with the "Do While NOT ResultsSet3,4,5,6 etc.EOF" loops i've added in. Code:
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 RelatedThe problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.
View Replies View RelatedI 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?
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?
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)
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" + "'")"
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')
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
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 Relatedi'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?
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: