Inserting Into Multiple Tables From ASP Page.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
SQL Server - Update/Insert Multiple Cols Into Multiple Tables
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for. I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement. If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
Searching Multiple Memo Fields In Multiple Tables In Access
I have a search option on my website, which should perform a search on 4 fields, as follows: tblNews headline content tblDatabank filename description It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc. I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
Inserting Into Two Tables Problem....
I want to insert form data into two tables. the page has 2 forms ,operation-data & admin-data and each has its table on MySQL. operation-data generates an autonumber as op-key, and admin-data has checkboxes to select wich admins will carry out such operation. My problem is, i don't know how to insert the admin-data WITH the op-key. I don't think i'm making any sense so i'll illustrate it. let's say: Code:
Inserting Multiple Records
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.
Inserting Multiple Records
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.
Inserting Into Multiple Rows
if i have an online invoice and i want to insert all the items of the form into different rows of a table. is it possible and can get the code ?
Inserting Multiple Records
i'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:
Inserting Multiple Names
if its possible in dreamweaver ultradev4 to create a pop-up box where i can select multiple names which can then be added to another field on a sepearte page. This popup page needs to be dynamic as new users are added to the database daily. Basically its the way that hotmail handles the address book. The user clicks a button to view the address book, they select the people they want to send it to, then click ok & all of those names appear in the 'to' box.
Multiple Tables?
Okay, I have a db that contains 1 table. it has some house info and stuff in it, but I want the updates and news and stuff on my site to be dynamic. So should I make a new table inside my DB and use that alongside the house info table? What would be the best way to accomplish this, and if possible, do u have to set a recordset up for EACH table?
Uploading & Inserting Multiple Images
How can I upload & insert 2 images to the server using asp, I used this code for one single image....I need to know for 2 images in order to insert them in database The following is the code : Set Upload = Server.CreateObject("Persits.Upload") Upload.IgnoreNoPost = True Upload.LogonUser "","maf","fam@dmin" Upload.Save server.mappath("/uaeagricent/AgriNews/Newsimg/") session("path")="" For Each File in Upload.Files session("path")=file.path Next....
Querying Multiple Tables
I want to query multiple tables (all with exactly the same field names) and then display the records returned in date order. I've written the SQL to query all the tables (they start with the same name, but end with sequential numbers), but it's returning no records when I know there should be some. Any ideas? Code:
Search Multiple Tables
i have a simple search page which i want to search mutiple tables with different layouts so i can return the search results in one recordset. how owuld i do this?
Update Multiple Tables
I have 3 tables Employees, nationalities, Companies. I can easily use a join to retrieve all the data I need from all three tables.Now my problem is updating those tables.I want to be able to update all three tables in one swoop. That is, how do I update all three tables with one update statement? Is this even possible?
Multiple Tables One Datalist
I am trying to create a datalist that pulls from table A. When the user clicks on one of the rows in table A I want it to expand under that row and show the data from table B (one to many relationship). Im not sure what is the best way to accomplish this. Is there a way to use the selecteditemindex to insert a new datalist ?
Connecting To Multiple Tables
anyone in here got an idea on how to open multiple tables on a single asp page? what i did was put 2 record sets but the problem is only the first table was looping.
Update Multiple Tables
I havecracking my head to solve this problem. I am doing a project on Online form. But because the there is too much field for a table, i have to split it up into 3 tables. I need to know how to update the 3 tables simultaneously, when i submit the form.
Insert Into Multiple Tables
I need help inserting the same inormation in second table called "users" ' insert to customers table with retail type by default (admin can change to BtoB later with BackOffice) mySQL="INSERT INTO customers (name, lastName, customerCompany, email, city, countryCode, phone, address, zip, password, state, stateCode, idCustomerType, active, user1, user2, user3, bonusPoints, idStore) VALUES ('" &pcustomerName& "','" &pLastName& "','" &pCustomerCompany& "','" &pemail& "','" &pcity& "', '" &pCountryCode& "','" &pPhone& "','" &pAddress& "','" &pZip& "','" &pPassword& "','" &pState& "','" &pStateCode& "',1," & pActive & ",'" &pUser1& "','" &pUser2& "','" &pUser3& "',0,"&pIdStore&")" call updateDatabase(mySQL, rsTemp, "customerRegistrationExec")
Deleting From Multiple Tables
I am currently using this sql code to delete information about a league but how could I delete records from other tables and incorporate it into this sql code? sql_insert = "DELETE FROM Leagues WHERE LeagueID=" & lid
Multiple Radio Buttons/textboxes – Inserting Into The SQL DB?
I’ve a few radio buttons; few of them have input textboxes and dropdown list. I use Select case to insert values (depend on which radio button that you've selected) into the sql db but it doesn’t work. Then I use if, elseif and else…the value of radio still doesn’t insert into the DB. In this case how can we insert the value(s) into the DB? Code:
Retreiving Data From Multiple Tables
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table. In the plist table I am storing the productID and the industryID's that relate to that productID.. industryID productID 1 4 1 7 1 9 1 10 etc. What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
Updating Multiple Tables In Ms Access And Asp
I have an query that gets value from two tables lets say tb1 and tb2. First i m tryin to insert values into tb1 and based on those values i have to update some already existing values in tb2. it gives me following error: Provider for ODBC Drivers error '80004005' Cannot update. Database or object is read-only i know my cursur types are correct as i can update without any error with a single table. This leads me to wonder if updating multiple tables in access is possible?
Create A Recordset With Multiple Tables?
My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables. How do I create a recordset that can handle the relationships and bring in all data?
Select Different Fields In Multiple Tables
I have 4 tables first table category (category_id and category name in it) second table artist (artist_id, category_id, artistname in it) third table album (id, artist_id, album_title in it) forth table song (id, album_id, title in it) I'm selecting category in first page I'm selecting artist in second page I'm selecting album in third page I'm requesting, collecting and posting all id's to the next page. this is the question!! How can I read from database 1- category name when I was selected in first page 2- artist name when I was selected in second page 3- album name when I was selected in third page
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.
Select Database Then Multiple Tables For Updates
What I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then: Set rs1 = db1.OpenRecordSet("Table1") Set rs2 = db1.OpenRecordSet("Table2") etc... However how do I do this in asp3? Code:
Selecting Multiple Tables Using SELECT Statment Problem
I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset. I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment. To make things more clear, my example: -Open a connection SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid rs.open sql,conn,3,3 while not rs.EOF -read from record rs.movenext wend rs.close conn.close now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?
Clone/duplicate Recordset Spanning Multiple Tables
I would like to dulicate a selected record. Sounds easy enough like performing another INSERT operation. However, that solution only works if the datasource is only one table. I have 4 different tables all linked to the main table through a unique primary key (auto number). When a user clicks a button to clone a record, all related records from the other tables must also be duplicated using the newly assigned ID that matches the one from the main table. Hopefully I didn't confuse you. Consider it like a multi-step process of filling out different web-based forms but using the same unique id. I don't know the first place to start on creating duplicate entries based on existing records. If you can start me with the code, I could probably follow the logic. THe difficult part for me to conceptualize is how to carry this new ID to all the other tables.
Inserting Asp To Other Page
is there a way to run an ASP script from an html page?the script is obviously written on an ASP page elsewhere but I want it run from HTML or SHTML.so they dont figure out the URL of my ASP page.
3 Tables, 1 Page
I am trying to list data from the DB from three different tables. The first table is creditors, the second is statements and the third is payments. I don't know much about inner joins and I'm not even sure that's what I need to do. The first section on the page is detailed information about the creditor. Below that is a section for a summary of all statements from that creditor. Below the statements section is a section for listing payments from that creditor. The 'creditors' table has a field of "credID" as well as the tables "statements" and "payments". The "statements" table has a "StatementID" field and the "payments" table has a field of payID. What is the best way to list the statements and payments from a particular creditor?
Inserting Dynamic Code In .html Page
inserting dynamic page code in .html page? i.e. i would like to insert a code which will display links. where my homepage link extension is .html. if it is .asp it would have been very easy. and also i would have worked fine. but now the problem is the homepage index file extension is .html. so if i insert the code it is not displaying the links. i tried inserting the code in a separate file and saved as file.inc and gave the link from home page <!--#include file="file.inc"--> but still the link is not showing and not working.
Updating 2 Diff. SQL Tables From One ASP Page
I have one ASP page that has two separate FORMS, each that will update a separate SQL table. These tables are in the same DB with the same connection string for both. The SQL statement seems to be writing correctly (when I test them) but neither of the tables updates when I try to update both of them. IF I try to update just ONE of the tables it does work correctly. Code:
Pass Form Values To A Page After Inserting In Access
I'm using DWMX and Access DB. i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id). this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
SQL/VBscript - Modifying Design Of Tables From Within ASP Page
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables. I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
Display Records From MS Access Tables As A Total In A Table In A ASP Page
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number) Joe Bloggs ---> 100 Closed Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
Creating Dynamic Tables In Dreamweaver To Display Tables
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
Multiple Query On One Page
I have created a database request page (wahooo - new to asp and it works) and everything is great. Now I'm creating a second page and want to know if I'm able to make two different queries on one page. I want to be able to create one query that uses a Request.QueryString from a URL and then use one of the returned values from that query to create another query on the same page. I hope that make sense. Here is the database connection code:
Multiple Page Report
i was wondering how to go about making a multiple page reports. i am really clue less.
Multiple Connections On One Page?
If you are going to be making multiple calls to the same database from a single page, should you connect/close, connect/close, connect/close....or just connect once at the beginning of the page and close at the end?
Multiple Page Survey
i'm thinking about making a muti page survey and was looking for some input on the best way to go about it. example i want 3 questions on the first page, the user answers then hits next the next questions load and so on. what would be the best way of programming this?
Multiple ASP Modules Not Working On Web Page
I currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
Multiple Select Options At The Same Page
I m trying to use multiple option menu using redirect function in ASP. I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
Linking Multiple Css Files To A Master Page
We have a master page set up and it is tied to its css file through the standard method in the <head> tag. What I would like to do though is from another page inheriting the master page to add another link to a css file. That way i can have the sites global file used to make the general apperance consistent, then make the internal content more flexible without destroying the current css file. Is this a possible task? When i went into the main master page and tried to add a <asp:contentplaceholder id="additionCSS" runat="server" /> tag to the head. When this is done visual studio alerts me saying it doesn't recognize the tag 'asp'. Is there a way around this? We are only just rewriting the site to use master pages now so I'm still figuring it out.
TRIMMING MULTIPLE KEYWORDS On Search Page!
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description. However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
Having A Problem With Creating Multiple Page Results
I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst' Does someone know where i am going wrong? Code:
Passing Multiple Selected Items To A Forms Page- How?
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data. I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not. Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be. HERE IS MY MAIN QUESTION: What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data? I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
|
TRACKER
