Looping Through Table Data On Form.submit
I have this form..which has a table (created from stored procedure
values)..once the table is populated..i have some radio buttons (for
each row of the table) and a main submit button.
On clicking submit..i want to loop through the table..pick up the
first <TDbeing the user ID and the value of the radio button clicked
(currently I have my radio button ID set as UserID_0, UserID_1 ..
etc). And pass those into a stored procedure..
View Replies
ADVERTISEMENT
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
View Replies
View Related
The following will both post the form data using HTTP POST method to theserver2, and then open page2.asp, right? It is not posting form data to server1. The only difference is that #1 will just replace page1.asp with page2.asp. But in #2, it will open a new window for page2.asp, and page1.asp also there.
So that means post the form data and open a new page is not necessary
replace the existing page, case 2 is a good example. That's my confusions.
1. In page1.asp in server1, it has <form action="http://server2/page2.asp"
method="post">
2. In page1.asp in server1, it has <form action="http://server2/page2.asp"
method="post" target="_blank">
View Replies
View Related
When people say submit the form data, does it mean the form data are submitted to web browser using either HTTP GET or POST method, and then it will redirect to another page.
For example, this is page1.aspx
<form action="page2.aspx" method="post">
means it will submit the page1.aspx form data to the web server, and then redirect from page1.aspxto page2.aspx?
View Replies
View Related
I'm not very familiar with classic ASP, but I need to modify an existing form on an ASP site to make the form data get posted to 2 different locations. Any suggestions on options to accomplish this?
View Replies
View Related
I'm really new to this and want to submit the data entered in a form to my email address. My problem is that I get the email but none of the data is being "grabbed" so although I get the headers I don't actually receive any of the information I really need.
What am I dong wrong? - this is my code:.....
View Replies
View Related
I have a classic ASP page with a number of text boxes which are updatable.
For convenience I want to add 'tabs' at the top of the page (like a card
index) as the data to be displayed is split into specific groups (client,
company, preferences, events).
How do I update any changes to the data and switch to a different page - at
the same time? i.e. the user doesn't have to click 'update' (submit button)
before changing pages Code:
View Replies
View Related
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies
View Related
I have an ASP form that has a field that automatically places the current date into it. It uses the function Date().
The problem I am having is when the form is submitted into my Access database the date is coming out wrong in the Access field. The datatype for the field is Date/Time but it still is not coming out right.
Example: the date in the ASP form shows as 12/19/2006 and the entry in the Access form shows 12:00:27 AM. If I change the format of the Date/Time field to Short Date, the result is: 12/30/1899.
Does anyone know how I can get the data that is posted to the Access database to come out the same as the ASP form?
View Replies
View Related
Assume there is a table called Item:
and fields Itemcode Customercode
now a customer may have one or many items(itemcode)
Now the issues are, Customercode can be zero or a code value.
NOw i want to put a do while loop to get all the records as comma seperated format
TempItemcodest=0
select * from Itemtable where customercode=customervalue
Do while not Rs.eof
TempItemcodest=TempItemcodest & "," & rs.fields("Itemcode")
rs.movenext
loop
TempItemcodest=TempItemcodest & "0"
so i am adding a zero at the begging and end to have the commas seperated properly.
is there any better way to do this?
View Replies
View Related
Basically, I have a dataset I need to send to a vendors site. They
have a page that will accept from form posts. What I'm trying to
figure out is how to loop through and submit form data when I do not
have control of the end site.
My basic idea is to have a page that will cycle through the dataset
put into invisible form fields and submit to the site (many times
over). Is this possible through asp?
View Replies
View Related
I want to loop through some checkboxes & extract their name & value. actually i want an if statement that says if they are empty write nothing & if they arent then extract name & value of checkbox.
i know how to do the if & extract the values etc but not the loop. at the moment i have really long code that looks at each checkbox tests if its empty & if it isnt then extracts the values I need. Code:
View Replies
View Related
I am working with two db's (i.e John and John1) I have a form that when submitted the information goes to the (i.e) Doe table. This table (Doe) is located in both the John db and John1 db, I need to add the functionality so that when the submit button is selected both db's are updated.
View Replies
View Related
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
I have been go through a lot of different websites to find out the problem but still cannot find a solution for it. I have an HTML email form which use post method to post the form data to an ASP page. It works fine in Outlook 2000 with IE6 or IE7. However, I updated my Outlook to the version 2003. The HTML email form does not work at all. Once the form is submitted, there are blank values in the ASP page. Just only when I refresh the page which a post back, the value is there.
View Replies
View Related
I am making a Website for my Clan in the Website I have added couple of form to JoinUs and leave feedback all the stuff is working fine but the Button to Submit the Data is not.
How can I link Submit Button or Activate it so that when someone fill out the JoinUs or comment form and Submit it, It come to me or the link which I will put in?
View Replies
View Related
I have a form that has approximately 7 text fields and 1 checkbox.
Generally when this form is submitted(to itself BTW) it works fine,
however, when the checkbox is only field that has been
modified/clicked the form doesn't always submit. When it does work, a
Stored procedure is passed form variables and updates to the db are
made. When it doesn't, its as if the form wasn't submitted, it
reloads and resets the page, but the stored procedure isn't triggered.
View Replies
View Related
I was wondering if there is any way to submit data without having to click the submit button -- I have done numerous Google searches, however all of the relevant results were writen in Javascript. Unfortunately, one of the criteria of my assignment is that it needs to be in VBScript. Code:
View Replies
View Related
I am using dropdowns and they are populating correctly. I am having problems when I submit to the Dbase. I am losing the rest of the entry. This is a Ascess Dbase and they are text fields. An example of the error:
Dropdown Selections: from table OsmcSystemsImpacted
VGS Data Center
Legacy Platform
VGS RVA
What ends up in my Dbase: going to table OsmcLogEntry
VGS
Legacy
VGS
I am not getting anything after the first "Space" So what is happening to the rest of my data?
View Replies
View Related
I have a form where users enter informaiton including a zip code. I was hoping that after they submit their info I could retain that zip code for the next page. The end result would be to have a page with a link that says "Click here for directions to our event!" and have the link go to mapquest directions from their zip code to mine.
Looking at Mapquest's URLs it seems they come in a very standard format that one could easily plug two zip codes into the url and have directions from place to place.The users do not have to log in to enter data into the form (my Google-ing has turned up stuff on session variables, but that seems to require log-ins).
I am gonna play around with this for a while, but if anyone has any pointers or links that could get me going in the right direction.
View Replies
View Related
I know I have done this but my mind is fried. I have a dynamic dropdown in
a form. I need to pull both the dynamic dropdown's ID and name listed in
the dropdown. Need a little help with grey matter tonight.
View Replies
View Related
I have a page with image, image has some image map, I want to submit
form when user mouseover that image map, my code is like this:
<img src="Images/floor4.jpg"usemap="#planetmap" id="IMG1">
<map id="planetmap" name="planetmap">
<area id=f4 shape="circle" coords="65, 93, 11" alt="CF4588"
onmouseover=overf4()>
And I write sub overf4() in vb script
sub overf4()
document.frmSelect.submit()
end sub
when mouse over that point form submit several times until mouse in on
the point I want to sumbit iust one time
View Replies
View Related
I am looking at putting a form on one of my pages that inserts data into my database (MySQL)it is possible to submit this form and then when the form is submitted fire an e-mail off to a member of staff to say that a new record has been added
Has anyone had any experience of doing, or trying to do, anything like this (or even know if it's possible)?
View Replies
View Related
This is from a "back-end" page on my site, but have run into a problem I've not had before, first off the form is being generated with some dynamic capabilities. Simply meaning I'm building it based upon so many records from a database.
Now I've isolated the problem down to 1 particluar text field and somehow related to it's name. When the name is present the form refusses to submit, except when I simply delete a reference to the name it works fine. Below you'll see an example of the code:
View Replies
View Related
I am successfully generating an HTML-formatted email using ASP and a NewMail object. It works great. The content of the email includes a simple HTML form that posts to an asp page.THE PROBLEM:
The form in the email functions properly (can be submitted, opens a
browser and redirects to the "post-to" asp page) but the form data is
not making it. i.e.at the far end in the "post-to" asp page....
request.form("someField") is empty.I imagine it has to do with encryption but can't find any info on the subject.
View Replies
View Related
I know this may be too easy for most of you. I am new to ASP code and I am trying to create a form where you can submit via ASP.
I already created a page with asp but couldn't figure how to send the form to email address. It seems that it requires another page of code what ot do but I can't find anything on the site to show me how it works.
View Replies
View Related
Once the form is submitted from an ASP page, how can I direct the output to display at a new asp page? The output is a text variable.
View Replies
View Related
i have got a very elaborate login page which has 1 form and more than 1 submit buttons.1 for login(preceeded by user name and password fields) and another for forgot password (preeceded by user name field).how can i submit the login details(i.e. user name and password) just by pressing enter in either of the 2 fields?
View Replies
View Related
what was the best way to have a use submit a form. I have a form of mine here. I bassicly just want to get a hold of the information when they submit it.
Whether it will be e-mailed to me or written to a file on my server thats OK. But I want it to link to the ASP file which proccessed it. Could somebody atleast give me an example of how to do this?
View Replies
View Related
Can somebody clarify if/how/when a simple form is submitted when the <Enter> key is pressed? As I understood it, if you have a form with a single submit button, if enter is pressed, the form should be submitted as if the button is pressed. Is this correct?
Does this behaviour vary across browsers?
View Replies
View Related
Some help in creating a form the gets some of it information from an Access database. I am building a website for a company that wants to run conference that you can sign up for on the internet. What they want is a form that can be e-mail to one of its employees and then processed at the office, well here is where I get stuck.
There is going to be among other form fields one for the Name, Company, Company Address…(so one) and a field for the name of the conference, data, time and location of the conference. What we want to have happen is a drop down form menu that you can select the conference from and via that selection the data, time and location field will be filled out for you. Can any one help me with this?
View Replies
View Related
how to do the asp step by step from basic.
View Replies
View Related
I'm trying to submit the values in a form and put them into a string using the following
for each objField in Request.Form
str = str & objField & ": " & Request.Form(objField) & "<br>"
next
This is the problem: let's say that my form has the following fields (in that order): Code:
View Replies
View Related