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.
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:
how do you do this. 2 tables. one called "Bookings" one called "Rooms"
what kinda query would i use to make it LIST the contents of the ROOM column in the BOOKINGS table, then get remove identical matches in the ROOM column in the ROOMS table?
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.
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?
is it possible to dynamically add a field into a table? or add a table? Lets just say that I have a DB with 10,000 entries and about 5MB in size. I want to add a new feature and for this i need to add an extra field to the table. I don't want to d/l the DB, make the changes locally and then u/l again, so can I do it via script?
and on the website i can display the results like so:
Current ads worth: 1681.50
I need the script to ignore letters as in the quantity field people have also added word such as packs and VE ETC so i need it to ignore letters, however in the price field some people have placed the ( , ) sign in there price so the code must recognize ( , and . )
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?
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?
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.
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.
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:
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)
I'm trying to put my data from Access DB into a table, but, where I know how to do it creating one row per record, what I'm wanting to do is essentially extract each record into 1 cell, and then have the next record in the next cell, creating a table 2xn in size.
The data I'm getting for each record is a URL & a file location, to create an image hyperlink for each record, and need the images to appear in a table 2 columns x however many rows required.
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:
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:
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?
I have never programmed in ASP in fact I am not a programmer at all. I found this script that sends an email that pulls information from a contact form.
'Sends an email Dim mail Set mail = Server.CreateObject("CDO.Message") mail.To = "youremail@yahoo.com" mail.From = Request.Form("your_email") mail.Subject = "Contacts" mail.TextBody = Request.Form("your_message") mail.Send() Response.Write("Thank you for visiting!") Destroy the mail object! Set mail = nothing
I got it to work with my flash contact form however on the form I have two other fields. Name and Phone number that I want to tack onto the TextBody but I do not know how to do this.
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
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:
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:
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?
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?
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 ?
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.
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.
