Insert Multiple Records
I'm trying to set up a form whereby users can select a variety of different subject mailing lists they'd like to be added to.
Each subject is in a different table so I want the FROM part of my SQL statement to loop through the values selected from the list box which I've loaded into an array.
But I'm getting a Type mismatch error.Code:
Dim strSQL
Dim subjects
Dim subjArray
Dim iLoop
subjects = Request.Form("subjects")
subjArray = split(subjects)
strSQL = "SELECT firstName, lastName, address1, address2, city, state, pcode, country, email FROM"
For iLoop = LBound(subjArray) to UBound(subjArray)
subjArray(iLoop)
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Insert Multiple Records
I have a recordset that contains multiple records of product a user is purchasing. For clarity, I converted the recordset fields to variables. I need to take that entire recordset and insert it into another table on a remote server. The below code only inserts 1 record. How do I change the code to get all records inserted? <% Dim DataConn2 Set DataConn2 = Server.CreateObject("ADODB.Connection") DataConn2.Open MM_kasKSS_STRING SQL = "INSERT INTO wsOrderDetails (OrderID, OrderNo, Description, Qty, PriceEach, Priceline) " SQL = SQL & "Values ('" & iod_OrderID & "', '" & iod_OrderNo & "', '" & iod_Description & "', " & iod_Qty & ", " & iod_PriceEach & ", " & iod_Priceline & ")" DataConn2.Execute(SQL) %>
How To Insert Multiple Records In Database?
how to insert multiple records in database?? i have this problem like i have this one form and there are three fields like the (quantity,unit,item name)..the item that will be inputted will vary, depending on the number of item to be inputted.. Ex. enter the number of item: 3 qty unit item_name 1. 2 pcs pencil 2. 2 pcs glue stick 3. 2 pcs clip (SUMBIT) what should i do in order that these items will be inserted in just one insert statement?
How Do You Insert Multiple Records At The Same Time?
I need help to solve this situation.... House 1 (1 photo) House 2 (4 photos) Example: Table1 idHouse....#auto House.......text Addr..........Memo Table2 idPhoto.....#auto idHouse....num Photo........text I need insert multiple records into a single field of the Table2 and insert the idHouse too. How do I do this?
Insert Multiple Records Into The One Table At The Same Time
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products. Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
INSERT Multiple Records From Checkbox Form With Unique Ids
I have an .asp page with a form to copy job responsibilites form one job to another. It is a hotmail type interface with checkboxes besides each responsibility. After submitting, it should copy the selected resp's to a different job. After that it should renumber that job's responsibilities. This is the code I am using now to copy: copySQL4 = "INSERT INTO jambue.RESP(POSCODE,IDCODE1,IDCODE2,RESP_NUM,RESP) SELECT '" & id & "' POSCODE,'" & dept & "' IDCODE1,'" & unit & "' IDCODE2, '999' RESP_NUM, RESP FROM jambue.RESP WHERE (POSCODE = '" & POSCODE & "' AND IDCODE1 = '" & sourceDept & "' AND IDCODE2 = '" & sourceUnit & "') AND RESP_NUM IN (" & Request.Form("chk") & ")" As you can see the value '999' is hardcoded in there as the new Responsibility Number to go with the copied responsibility. I use this because there are no jobs with that many responsibilities. This works fine if I only select one resp. to copy over. But if I select more than one that part still runs fine but I get an error with the below. It says too many rows would be affected. Of course, this must be because there are now at least 2 responsibilites with the same RESP_NUM. Code:
Trying To Insert Multiple Records Into Database When Form Is Submitted
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2. I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do... I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
Submit Form Elements To Insert Multiple Records Into A Database
I have a table that contains all of the function permissions within a given application. These functions are different sections of a site and each has its own permissions (READ, WRITE, UPDATE, DELETE) which are controlled by a web frontend and the table records are manipulated to control the permissions. Code:
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.
How To Update Multiple Records With Different Multiple Value
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.
Insert All Records
I am trying to figure out a way to insert all the records from a dynamic table - repeat region into one table as individual records. On the 1st page users select which items they want from a large list. When they click submit it passes the values ( IDs ) with a URL par to the next form. This form has a recordset that uses the URL par from the last page and creates a new dynamic table - repeat regon with all the records they chose. I need to do this so I can then add up rates for those selected items. I need to find a way to the add all those selected records now into one table. Also I need to have them insert each record at a time. So if 4 records are in the recordset and repeat region, I need to have it add 4 records into the table. Hope that makes since. Im a bit lost on this one.
Insert Records
Is it possible when you insert a record in a database to only insert max 5 records. Can i make it delete the oldest one when i want to insert record #6 and so on?
Insert Records Access DB
Anyone know if it is possible to update/insert a database record into a dynamically specified field. The code I have here holds data in an asp session, ownerId, storeid and product type. I can insert a record into the Productcat table, fields OwnerId and surfboards, no problem. But what I would like is to insert the ownerid then insert poduct type into the field sepcified in the session variable (session("prodtype")) and/or strprodtpye For Example Insert OwnerId + product type into productcat into fileds ownerId and field labled ''strprodtype'' (variable, surfboard, wetsuit, boots, etc) SQLstatement = "INSERT INTO Productcat (Ownerid,'"&strprodtype&"') " I have tried using different methods, but the closest I got was IIS error msg ='field not found ("Surfboards", "wetsuits", "boots", etc)' Code:
Can't Insert Records In My Database..
I am workin on a project at home,asp vbscript website, n im having problems with inserting records into my database .. I am using a dsn-less ADODB connection, but it seems that some kind of security is preventing me from writing in the db.. i can access n retrieve, but NOT WRITE.. ive tried disabling every type of security, still doesnt work..
Unable To Insert Records
I get this following error while inserting recoed in ms-acces db : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. /mis/add_iteminfo.asp, line 35 This thing is making me go crazy as i'm running windows platform & running the app on localhost. The have several times but the db isn't read-only, not even in the iis. Don't know what to do .
Insert Records Into Database
i have learned database connectivity. I am facing some problems in inserting records to database using SQL. Please tell me the way to insert records using SQL. I received error about wrong arguments on following line. Rs.Open Query, DBConn, adOpenStatic, adLockOptimistic where Rs is the RecordSet object, Query contains they SQL String, and DBConn is the Connection to my Microsoft Access database. I easily connected to the database and retrieved records using following command: Rs.Open Query, DBConn, 3
Insert Mltiple Records
What is the most efficient way of inserting multiple records into a database ? At the moment, I'm grabbing data and inserting each record with a loop. The only thing is on each loop I'm opening a connection to the db (SQL Server), inserting a record, then closing it. Is there a way of inserting all the data with either one command or by keeping the connection and looping the command instead. The situation is the user entering email addresses into a textarea, one per line, then process each of those emails as a record.
Using Multiple INSERT In An If Then End If
This is my code, for some reason, when I use this exact code it doesn't update my database, but if I use the next section of code it does. Anybody knows why that when I use two different "Insert" in If Then End If, it doesn't work? Oh and I did try the "If PID = 105 OR 151 Then" alone and it works well. Code:
Multiple Insert Into DB
I hv a SQL server table 'spmidishad'. Theere are 7 columns. One of it is Partner. my searchresults.asp displays all the records retrived from my database (spmidishad). At the end of one row, there is a checkbox. Once a few is checked, i will press on the IMPORT button. This import button (the form action is from import.asp) is to import (insert) all the checked records into the database.. All rows inserted (the data) are the same except for the Partner column.Well, i want someone who can help me to figure out how I am suppose to do this..?
Multiple Insert
I have a page that will populate information from a "reference" table in the DB (SQL) like this: sku qty 123 10 111 10 222 10 333 10 This information will be different each time the page is visited based on the variable they submit. So next time it may show 20 records. how would I go about inserting this data to the DB? Can anyone point me in the right direction to get me started?
Multiple File Name Insert
I'm trying to make a form that allows the user to select multiple files from their computer, and then INSERTS those file names into an access database using ASP. I also don't want to have a seperate <input = file> tag for each one??? Is this possible?
Insert Multiple Values
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent
Multiple Insert Record
i want to insert some records to Access Database using the checkbox.i've try all the example i've found but it does't work.it's like checking our yahoomail.but i want all the tick checkbox insert to database
Insert Multiple Rows
I use Access Data Base 2000 and ASP configuration. My case is that I constructed a Editable Grid with 5 columnar labels so that I derive many rows from database for the client to choose from by the help of check boxes that I externally added for each row. What I have to do is after client chooses the rows by clicking the check boxes and then clicking on the submit button. I would like to insert the marked rows with labels(4 or 5 labels)into a differant database table from the one where the data was first drived. BTW, within the editable grid I have 4 submit buttons and each button should insert checked rows into differant data base tables.
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")
Multiple Insert/Update
After the page (transactions.asp) loads I want to allow the user to enter the number of transactions into the provided textboxes. Then, when the user clicks submit, I need to have all the hidden fields as well as the number of transactions values inserted into the transactions table of my database? I have attached the database should you have any questions about the db table values and fields. Please let me know if you have any questions or need more information or files.
Multiple/Mass Insert
my page(searchresults.asp) will show all the results that you searched for.. These results are from the sql server. All the datas are different. On the right of every record, there is a checkbox. Now is the scenario.. After all records are shown, I will check a few checkboxes. Then i will click the button. All the data that is checked will be inserted in the sql server. But the thing is that all data records is different.. Its actually kinda off like the hotmail, where you checked a few boxes and put them into a different folder..
Multiple Insert With Checkbox...
This is my problem... its for a mailing list with categories... I have 3 table... 1 : Name,City,Email 2 : Categorie 3 : Name_id , Categorie_id So when a user fill up the mailing list form, he can check as many categorie he want... but how i can insert 1 row in my table #3 for each checkbox checked... Can someone post me a simple script...
ASP Application Form To Insert Records Into SQL Database
I have a project where i have to use an html asp application form to insert records into an sql database. My problem is finding resources online to practice with to learn, i have basic knowledge of ASP and have attended the microsoft 1 week course on Administering a 2000 SQL Database and i have designed a few small sites so i know html and javascript. I have the database side covered its just the VB code to take the form values and post them to the sql database. I was wondering if anyone could point me in the right direction of sample codes to play around with as i cant seem to find any which relate to this project.
Can't Insert Records From Page With Request.form
I'm trying to insert records into an SQL database coming from a page using the request ..form method. The table "general" has a primary key 'geid .' I get the following error: Cannot insert the value NULL into column 'geid', table 'general'; column does not allow nulls. INSERT fails. ....not sure how to include the 'geid' field into the scheme. strSql = "insert into general (firstname,surname,company) values ('" strSql = StrSql & Request.Form("firstname") & "', '" strSql = StrSql & Request.Form("surname") & "', '" strSql = StrSql & Request.Form("company") & "')" myconn.Execute (StrSql) ....
Multiple Records
I have this search and results system on one page.... I'd like it where the results that come up from the search are editable and can be updated. I can't seem to figure out a working way to update more than one field at a time.anyone have a good piece of code for multiple edits
Multiple Records
I need to retrieve multiple records and insert all of them into different table.I got an error running the code below. <% FilePath = "C:Inetpubwwwrootdata.mdb" Set Conn1 = Server.CreateObject("ADODB.Connection") Conn1.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath & ";" SQL1 = "SELECT name FROM total where marks = 2" SQL2 ="INSERT INTO people (names) values ("SQL1")" Conn1.execute(SQL1) SQL1.MoveFirst while not SQL1.EOF Conn1.execute (SQL2) SQL1.MoveNext wend %>
(Multiple) Insert If Data Is Not Empty
I have 6 textboxes where user can input data (or can leave it blank). I need to insert all the data (if not blank) into the database. How should be SQL query be like? ...
How To Update Multiple Records!
how to update multiple records on one submit. Say for example i have number of records on a html table, user performs changes on some of the records, and hits the submit button at the end and all these value have to be updated into the sql query.
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.
Update Multiple Records
How do I update multiple records in a table in ASP using loops ? For example. I have a table with the following colums ID | Col1 | Col2 ------------------------- 1 | 50 | 100 2 | 25 | 130 3 | 55 | 70 I want to add *66* and *77* into the ID # *1* and ID # *3* respectively. So the result should be ID | Col1 | Col2 ------------------------- 1 | 116 | 177 2 | 25 | 130 3 | 121 | 147 Note: All datatype of the colums are integer.
Delete Multiple Records
I read this article below and play around with delete multiple records function in dreamweaver. Assume that all my database fields setup are exactly like the code below. I was able to follow the instruction and did everything excepted line# 29. Can someone give me a suggestion of the line# 29 suppose to be (in example if possible).....
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.
Update Multiple Records ?
how can update the multiple records at a time ? what loop will use to update the multiple records ? Code:
Calculation Of Multiple Records
This is the page where I collect the data in drop-down boxes with values of 1-10 and send it to a submitted page to do calculations. Example: Employee1 TeamScore(1-10) Employee2 TeamScore(1-10) Employee3 TeamScore(1-10) Employee4 TeamScore(1-10) Then I submit this page with all the values in TeamScore for every employee and I want to perform a calculation based on the values in the drop-down and a weighted score from another database table. An example of a weighted score is 0.11 and I need to multiply the value(from 1 to 10) times the weighted score of 0.11 for each employee. I have several records to update all at once from the previous screen of drop-down boxes containing numbers 1 - 10 and I want to take each individual drop-down value and multiply it by a weighted score (i.e. 0.11 etc.) 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:
Updating Multiple Records At Once
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:
Updating Multiple Records
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.
Selecting Multiple Records
I want to select multiple records using the WHERE function. Currently my SQL query is as below:- strSQL = "SELECT albums.* FROM albums WHERE id = 1" As well as selecting id = 1, I would like to select id = 2 and id = 3 . How can I write this? I have tried seperating it by commas and spaces but this didn't work.
|
TRACKER
