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:
The 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'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.
If I am attempting to add multiple products to an existing Customer-Products
linking table do I do this via an Insert or Update?
The first time I enter a customer in the database I would obviously do an
INSERT into the Customer-products linking table.
But, the second time I wish to ADD new products as well as possibly
overwrite existing ones......
I am getting twisted what the correct approach is?
if it is possible to insert and update records in a database from the data that is in an HTML table? I have a program that converts data to an HTML table and would like to be able to insert/update records to the database on the webserver.
View Replies View Relatedwhat is there i need to look up and add to my code so that if more than one user is logged on to my site and edits information such as stock levels other users aren't under the impression there is stock when it has just been givin out to someone else? the easy was is just to have one user to access it at any one time but i think there will be about 5 -10 users at anyone time viewing the info and if 2 ppl update records at the same time how is it done?
View Replies View RelatedI 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 RelatedThrough the form action I want to be able to update the existing record. Is it possible to run an update through a join? The statement selects a ticket and the associated contact. The user should be able to change the contents of any field and then hit the submit button the update save the ticket. Code:
View Replies View Relatedi want to know how to update records by login
i mean to say when a user will login by his name and password his records of his name n password from the database will dispay on page and he will be able to update
after login m redirecting the page to update.asp .
how can i move the values how parameters i.e loginname and password.
I have created a page that calls multiple records from an access database. I would like for the user to go through and update the data, press update and it updates to the database and returns to the same page.
this has been accomplished all bar one thing, it doesn’t update the database! What have I missed? Code:
Those anyone knows how can I update several rows in a table using form fields with ASP?.
I'm using oracle9i.
I have a master/detail table configuration in a SQL database.Each record in the master table can have many records, which are stored in the details table.I need to create an update page that will allow the user to view, update or add new records within the details table that is associated to a master table record.
So, say I have 7 fields in the detail table and I'm pulling 20 records from the table that is associated to a specific master record. I would have 20 rows each with 7 columns that need to be updated or added to.
The columns contain dropdown menus,which will hold the value from each field in the detail table But,I also need to pull data from other tables that will hold the other values for the dropdown menus.
I'm trying to update records in the database and the script I'm using is giving me an error:
Type mismatch
/Action_Item/action_items/view_action.asp, line 79
Whis is referring to this line:
response.Write("<tr bgcolor=""" & strBgColor & """><td width=""150"">" & lclArray(0,rowCounter) & "</td>" _
& "<td>" & lclArray(1,rowCounter) & "</td>" _
& "<td>" & lclArray(2,rowCounter) & "</td>" _
& "<td>" & lclArray(3,rowCounter) & "</td>" _
& "<td>" & lclArray(4,rowCounter) & "</td>" _
& "<td>" & lclArray(5,rowCounter) & "</td>" _
& "<td>" & lclArray(6,rowCounter) & "</td>" _
& "<td>" & "<a href='edit_action.asp?action_id=" & RS("action_id") & "'>"&"<img src='edit.gif' border="" alt="">"& "</a></td>" ) ....
Im 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 RelatedWhen 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 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 need a code that will update multiple records on a list thru checkbox.
If the record is selected, the details that was updated on the selected
record will copy the same value as what is updated.
I am having trouble with the edit, update and deleting of records. I got the codes from a user in a different forum. Now I can't find ant help from that forum. Here is a link to a zip file with the pages and database in it.
bkdphoto.com/problem.zip
Simply open the listings.asp page then click on one of the Edit or Delete labels. I am getting the following message when I do:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/Tests/New Folder2/delete.asp, line 7
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 RelatedI have a database generated form that I would like users to be able to update by selecting a checkbox. Say the page displayed has six records on it and the user wants to delete one or more of the records. They would click the checkbox and hit a "delete" button.
Then the database would be updated and the user redirected back to the page that would now show all the records that weren't deleted. Sort of like Yahoo mail, you get a list of all the bulk mail, select the ones that you want to delete, hit a delete button, and the page is updated to show what e-mail is left. How do I do this using ASP?
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 just moved an ASP Classic website to a new hosting company that has a
number of .NET components available. The website works fine after the move
with one exception. We were creating PDFs using ASPPDF for ASP but now it
looks like only ABCPDF.NET is available.
My knowledge of ASP.NET is very limited at this time and I am planning on
converting the site to ASP.NET soon but I really need to get the PDF working
as soon as I can.
I am trying to add a Visual InterDev project to Visual Source Safe 6d.
Normally I just go up under Project | Source Control | Add to Source Control
and I can load the project to VSS but now when I try to add the project to
VSS I get the error:
"Cannot establish source control for the Web Application. The server does
not have a source control system installed on it, or the user name is not
recognized."
I am on a workstation which has VSS installed. VSS is also installed on the
web server istself. I atttached to the VSS database as "admin" and under
my own user name but I continue to get the same error.
What could be wrong? Perthaps I am using the wrong version of VSS. Is
version 6d compataible with Visual InterDev? Or do I need an earlier
version?
I am developing on WXP SP1 with VS.Net 2003 and VS6 installed. I cannot get
my localhost webserver to render any classic ASP pages. ASP.Net and standard
HTML works.
If I request an ASP page from localhost the browser hangs for several
minutes before just doing nothing. The status bar says the website is found
but nothing is ever downloaded.
I have verified the mappings in the IIS manager and I have re-registered the
ASP.DLL. I am now at a complete loss.
The following code works on IIS 5.0 on a Windows 2000 server.
Response.Clear Response.ContentType = "application/rtf" Response.AddHeader
"content-disposition", "inline;filename=letter.rtf" response.write l_strBuffer
But on IIS 6.0 running on Windows 2003 server we get an error.
"Internet Explorer cannot download <file name>.
Interner Explorer was not able to open this Internet site. The site is
either unavailable or cannot be found. Please try again later."
After increasing the AspBufferLimit attribute in the metabase.xml, we were able to resolve the issue.
Is there any other way to resolve this without modifying the metabase.xml?
Can you develop Classic ASP pages using VS.net?
View Replies View Related