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:
View Replies
ADVERTISEMENT
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:
View Replies
View Related
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:
View Replies
View Related
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...
View Replies
View Related
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.
View Replies
View Related
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 Replies
View Related
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)
%>
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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) ....
View Replies
View Related
I am trying to have a form that has multiple records on it and the user can check a box on which ones to add to the database. I created the form but cannot get the fields to enter into the database.
View Replies
View Related
I 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?
View Replies
View Related
I have a tablet structutre that is the following:
id customer error
1 custa 0
2 custb 1
1 custa 3
2 custb 0
1 custa 0
Each id is unique to customer. I have a table with over 100 rows of the above.I need a way to pull that last three occurances of error number 0 for each customer? I was trying to use a subselect but i was having trouble.
View Replies
View Related
I have to develop an online quiz on my website. the site is developed in ASP.
i have a access database of the questions, the multiple ans.s and the correct ans. every quest. has an unique id.
i want a way by which any 10 'unique' quests. will be selected from the database everytime an user takes the test.
View Replies
View Related
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.
View Replies
View Related
Is it possible to insert values in a Database with a
checkbox? Say I have a recordset and if the check box is checked I
want to insert the value of the of the field in the DB.
<%=rsqa.Fields.Item("recini").Value%>
That is a persons initials, i want to insert those initials in a column
if it is checked, if it isnt checked nothing is inserted..
View Replies
View Related
what Im trying to do is to insert into the database the values of the checked checkboxes of the recordset fields the appear in the table I've written the following code:
View Replies
View Related
I have a form that is passing a number to check box values with the same name (productID) but different values (numerical values). It is also passing a warehouseID as a hidden field.
I need to dump these values into an access table called wtbProductWarehouses with fields titled ProductID and WarehouseID. What is the code that I need to write to have it loop through all of the productID values and individually add each one to the db while also adding the warehouseID with it.
View Replies
View Related
Have an asp form created and I need to assign a unique id number to each submission. Can this be done w/o a db?
View Replies
View Related
I am having problems inserting checkbox data into my database. The string data from the text files in my form have no problems being inserted in the db. Code:
View Replies
View Related
I have a form that if a user selects a certain option from a dropdown list a checkbox will appear. This checkbox references information from another table and then multiplies a figure before it is submitted (well, that's the theory anyway!)
I can't seem to get the multiplier to work. Can someone please give me some advice to this? I've included some simplified code that concentrates on the areas that I'm having difficulty. Code:
View Replies
View Related
Is it possible to insert more than 2 checkbox values into 1 field in the SQL database?
I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.
View Replies
View Related
A page displays the Product literature that a customer can request to receive by postal mail by clicking a check box. The literature selections are created by a dynamic record set based upon what the company enters into the Literature table (currently 10 selections). The checkbox form tags are:
<input type="checkbox" name="LiteratureID" value="<%= rs("LiteratureID")%>">
LiteratureID is the Access autonumber primary key field. I can use the LiteratureName in the "name" attribute if it is easier.
The form processing page needs to Insert each selection into its own record in another table. This "requested" table also inserts the database ID for the customer that is created after first inserting the customer contact info. In other words the "requested" table needs to record the customer autonumbered db ID and each selected checkbox value.
Here is my current code:
View Replies
View Related
I have a series of checkboxes:
<td><input type="checkbox" name="reportTo" value="Rob"></td>
<td><input type="checkbox" name="reportTo" value="John"></td>
etc...
but I only get a value passed to the database if just one is selected. If more than one is selected, no value is returned. I thought the value passed was s'posed to be a comma delimited string of all checked boxes?
View Replies
View Related
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).
Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.
View Replies
View Related
I have to develop a page where, based on status some records are selected from the Access database and displayed. A checkbox is displayed beside every record.
Some checkboxes can be selected and the corresponding record should be deleted if the delete bottun is pressed.
I know how to select the records from the database and perform multiple delete. But do not know how to link the database and the checkboxes. Anybody has any ideas??
View Replies
View Related
I have an ASP script which is used to upload files with Persits.Upload.1 object. But I can't get the values from mutliple checkboxes in the form like normally.
<form method="post" ENCTYPE="multipart/form-data"....>
<input type="checkbox" name="language" value="English">English
<input type="checkbox" name="language" value="Spanish">Spanish
<input type="checkbox" name="language" value="Chinese">Chinese ....
View Replies
View Related
I am using a form to upload images with Persits.Upload object. Now my problem is I cant use multiple checkboxes in the form.
In general forms I can use Form("checkboxName").Count to get the number of checkboxes selected and use Form("checkboxName")(i) to retrieve the value of each check box.
This doesnt work with Upload.Form
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
