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
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.
Insert Values
Iam trying to insert values into my database, but i keep on getting this error, Code: Subscript out of range: '[number: 1]' I have tried to check my insert values but i can't pickup anything, can anyone assist me in this regard. Here is the portion of the code:
Insert A Column Values
Here's the link for the db table: http://k.domaindlx.com/gemetria/pageing.asp How do I insert a field of values?
Insert Statement Dropping Values
i'm reading in a .csv file and then inserting the data into a mssql db. batchid sometimes shows up blank. the values that are disappearing begin with the letter "N", such as "NP2338" or "N00312". outside of those that begin with "N", the rest are a five digit number. the table field is varchar. why is it dropping those that begin with "N"?
Insert Values Using Same Db Fields To Repeat
I have an INSERT statement with information being pulled(upload.form) from the form. Example, text field named SubmitIssue1 will populate field SubmitIssue field in the database. SubmitDate1 will populate field SubmitDate1, and so on. However, what I am trying to accomplish is to expand the form to allow the user the ability to add another instance of an issue where they will use the SubmitIssue2 text area. I want to pull their name and email address from the top of the form and use it as well as this new information in the SubmitIssue2 textbox to create a new record. The information from SubmitIssue2 will populate the SubmitIssue field. HOW CAN THIS BE DONE? Please help with some examples of how this would look. Code:
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 Values
How do I pass in more that one variable in the form tag below code: <% Dim CmdPopulatelist Set Conn= Server.CreateObject ("ADODB.Connection") Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset") %> . . <% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %> <% Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db" Conn.execute(sql_select) CmdPopulatelist.Open sql_select, Conn %> . . . <form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
Allow Multiple Values
I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far: if strUser="jdoe" or strUser="jsmith" then
Check Entered Form Values And Insert Them To Db
I have this page set up at www.kevinhall.org/headcount/headcount.asp what is the easiest way to check where the user has entered a value and submit the row to the db. Maybe i'm going about the form wrong. Each box has its one name but I was hoping i could get around using a request.form on each one and useing the isEmpty. Its so tedious and non efficient there has to be an easier way.. Maybe with .net possibly?
Insert Checkbox Values From Dynamic Record Set
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:
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 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)
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 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) %>
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...
Multiple String Values
how can I compare a values to multiple string values. i.e. If Request.ServerVariables("REMOTE_ADDR") = "213.123.214.33" Then WriteLine "A problem has occured, please email for help<BR>" end if Would it be to do multiple if the elses, case or can you put all the possible values on the one line? i.e. "123.123.123.23" or "345.234.234.234" etc.
Multiple Values From QueryString
how i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.
Passing Multiple Values
I have a link as follows: <A HREF=""Tracker.asp?MovementID=" & RS("MovementID") & " PONumber=" & RS("PONumber") & """>" & RS("MovementID") & "</A> I am trying to pass: MovementID & PONumber. On linking to Tracker.asp, MovementID = 2257 PONumber=21071045 PONumber = Empty I am just testing this with Request.querystring. What have I done wrong, how can I separate these values ?
Multiple Queries And Using Their Values
I am running two queries on a single page and they essentially work, the only problem is that i am unsure exactly how to get one aspect to function properly. To explain it correctly it will probably be easier to just show you the code, the first query looks like this: Code:
Using Replace() For Multiple Values
is there a more efficient way to replace multiple values than this (so that the numbers 0-9 are placed with particular texts in one go): Code:
Displaying Multiple Values
how do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database. Code: strBody = "Here is your login password: " & strPassword If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.
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?
(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? ...
Returning Multiple Values From A Function
I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values. I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code:
Multiple Values For Radio Buttons
I have a form on a web page with a number of radio buttons bound to the same field. Is it possible to set up the form so that users can select more than one radio button to submit multiple values to a field in the way that you can, for example, in a drop down field?
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.
Split String To Perform Multiple Insert
I have the belwo code which i mean to do an multiple checkbox insert. I have managed to get it so i puts all the checkbox values into a string seperated by a comma, and it insert into a database, however just not how i need it to. Curently inserst like :-
Insert Multiple Selection From Listbox To Database
after a lot of searches to see if i can get such a code on the net, i've finally come to ask my questions here bcoz i can see bits of code here n there on net but not what i really want. i have a form with a listbox(lstduty) on it. i have been able to populate it with data(dutyName)from table 'duty' from a sql server 2000 database. now when a user makes multiple selection and click the 'add' button, i want to be able to add it to another table in the database as below: Code:
Returning Multiple Values From VBScript Function
I am using both VBScript and JavaScript functions in the same ASP file. All I need to do is to retrieve some values which are calculated in the VBScript function, to JavaScript. The call to the VBScript function is made through a JavaScript function. Code:
Post Multiple Values For One Form Field
I loop through a recordset to return values that populate a form which the user can then edit and save. However these fields need to be validated first to make sure the data entered is correct. I have a Firstname field that returns 3 records from my recordset which means when I try to validate, I get an error as the page doesn't know which of the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
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:
Freeaspupload: Retrieving Multiple Values From A Select Field
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component. I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
Retrieving Multiple 'values' In A Single OPTION ITEM
I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest). The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. 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:
Form Values With A File - Passing Values
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this: To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
|
TRACKER
