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:
View Replies
ADVERTISEMENT
I have two fields that I want repeated in an ASP page. One column is a list of job duties, and the other column is a list of corresponding values that goes with each job duty. All of the values are coming in, but my job duties are not listing. Only the first job duty is being listed. I'm sure that I have my loop incorrect. Can someone give me a hint as to what I need to do? ....
View Replies
View Related
I am displaying multiple records returned in a resultset using a Do While loop. I've set the form field names like the following:
<select name="fieldnameA<%=ID%>"...
where <%=ID%> is a hidden field on the page that holds the id value for each record.
I want to append that number to the end of each form field
So, "fieldnameA" would be fieldnameA1 or fieldnameA2, etc.
I thought this would work, but the field names remain the same for every record...i.e. fieldnameA just repeats and the hidden field value isn't appended to the end of the field name.
Is there a way to append the value of the hidden field to the end of the form fields? So, the form field names are different for each new record displayed?
View Replies
View Related
I have information pulled from a database and it works ok. However, I have several records in each repeat region and I want to add the values in these fields together.
So in the first record I have
cont1 = value from database (1000)
cont2 = value from database (2000)
cont3 = value from database (1000)
Second Record
cont1 = value from database (2000)
cont2 = value from database (1000)
cont3 = value from database (1000)
Total For that line is = (8000)
View Replies
View Related
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies
View Related
is there a way to write a insert statment with out typing out all of my field names? i want to do an insert in every field but i don't want to have to write them all out.
View Replies
View Related
I have about 30 names of workers (and their IDs in hidden fields, that depend on their departments) in one form, beside them there is one dropdown list for each worker, with same items. I want to select item from dropdown list for each worker, that will write item ID in another hidden field... and then I want to submit worker's ID, ID from dropdown list etc....into another .asp page and sql db.
If I use next way :
<%
FOR EACH name IN Request.Form
Response.Write("<BR>")
Response.Write(Request.Form(name))
NEXT
%>
I get only values of IDs from dropdown lists. But I need workers' IDs, too.
View Replies
View Related
I'm writing ASP/mysql apps, and I'm almost clueless about mysql. Can someone tell me how to insert data into fields using ASP? Code:
View Replies
View Related
I'm trying to retrieve 2 values from a table (product stocknumber & description) that match a form result (product ID number) to send with the "form results email". Not quite sure how to do this. Code:
View Replies
View Related
I've got a really strange problem I can't explain - when I add new values into my database (Access) ir multiplies them by 100 - for example id I enter the values:
10.50
7.50
5.50
They go into the database as:
1050
750
550
The field in Access is a Double type, nullable, and set to default to 0.
My code to add it is: (the response.writes are what product the numbered output above - so I know what the form is posting, and subsequently what the database has in
its fields) Code:
View Replies
View Related
[Number of query values and destination fields are not the same.]
This file has worked with another project of mine but can't understand why it doesn't work with my current project.
I've look at the fields being queried and the fields being inserted and they are exactly the same. I basically made a copy of the main table and called it an archive table. So this is just taking out of the main table and inserting into an archive table. Code:
View Replies
View Related
I have a form which the user fills and submits.i have insert statement there.
When i submit the form to itself ,the values get submitted and inserted in DB easily.
<form method="post" action="Infoviewagentver212.asp" name="form">
Now when i want the user to hit submit and go to other page i change the above to:
<form method="post" action="newpage.asp" name="form">
but here what happens is my values are not getting inserted in the DB??
How do i do this?
View Replies
View Related
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:
View Replies
View Related
I cant figure out how to insert a string variable in a string. My SQL query should select the top x posts. So I need something like
Set x = Request.Querystring("x")
strSQL = "SELECT TOP "+ x + " FROM myTable;"
help me with the syntax?
View Replies
View Related
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 Replies
View Related
Here's the link for the db table:
http://k.domaindlx.com/gemetria/pageing.asp
How do I insert a field of values?
View Replies
View Related
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"?
View Replies
View Related
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?
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 wish to insert several images in a page (1.jpg, 2.jpg, 3.jpg…) Is there anyway to use asp programming to keep the code short and smart? Something like this:
<img src="* .jpg" width="72" height="52" /> repeat while * goes from 1 to 5 . I guess that this can be made… In some way.
View Replies
View Related
I have a booking page that the user enters 2 addresses date and time etc
what I need is the option for the user to select multiple date entries for
the same journey or maybe multiple days ie they want to travel the same
journey every Monday or every weekday etc.
View Replies
View Related
does anyone know how to set this asp page to repeat the same transaction by mouse click.
i would like to repeat the query in my asp page by mouse click, i.e. first query done by query input in the input page the next would be by mouse click using the same output as the first image page.
View Replies
View Related
Not sure if this is possible, I have a memofield that contains a data string
(e.g. name1, name2, name3, name4 .... name 30) I would like to represent the
data in a table so that each name is on a different row eg
Name1
Name2
Name3
Name4
etc
Name30
View Replies
View Related
how I can repeat details in a ASP page. For example I have to fill in a a form which has the following quetion.Language : (a text box here to fill in the details)
and then a message with 2 buttons Do you want to insert another? YES NOWhen click on the button YES, I want my asp page to take the quetion "Language :" and the text box and copy it so the user can insert another value.How can I do it ??
View Replies
View Related
how do I achieve this?
Today's News
Date
Title of current news
Short DescriptionTitle of 2nd newsTitle of 3rd news Note:
I want the current inserted news to be on top with short description and the previous news just to display the title only.
View Replies
View Related
I have some fields in the database that are not used in certain records, the problem being of course the it displays these feilds in the webpage and then the size of the webpage gets rather big, full of empty spaces .its just to fields in particular I need to apply this to?
View Replies
View Related
what im after below is instead of test the name of the news_attachment field is repeated
Code:
Response.Write ("<a href=""" & recordset("news_attachment") & """>Test</a></td>")
View Replies
View Related
How can I repeat a header every 'x' number of rows?
View Replies
View Related
I am on the last part of my ecommerce site but I've hit a problem I can't seem to figure out. I have an asp page with an Orders table that lists the OrderID and the customer name and what they have bought.
Then if you click on the ID number you go to a details page that lists their name, credit card details, address etc. Also I want to show all the items that they have purchased but so far it only enters the first item they've purchase. I have tried making just the products a repeat region but I get an error when I do that.
View Replies
View Related
I would like to retreive a list of records from my database using repeat region but I need 2 records in 1 line.
Any idea on how to do this?
View Replies
View Related
I'm making the register form to add user in my system. I want user to type fullname,username, password & repeat password. So I write function to check the input from users.This is one of the part in function
else if(form.pwd2.value <> form.pwd1.value){
alert("Repeat password again!")
form.pwd2.focus();
return(false);
}
This part are giving error when submit clicked. So i cut this part & try again & it's ok & no error. i want to make this repeat password checker.
View Replies
View Related
Anone know of free code available to create a vertical repeating region? (I've found code for a horizontal repeating region.). I want to display my data from an Access table vertically, not horizontally.
View Replies
View Related