How do I pass the value from form to SQL insert statement?
Code:
Insert into table values ('A','" &request.form("Textbox1") &"')"
Is the request.form statement correct?It seems that the record is enter to DB but second field is empty.
I have an html form where a serial # is entered and goes to an asp page to determine wether it is a res or comm number, then directs to another form where they can finish entering info to register the serial number. I want the second form to display the serial # entered in the first form. How do I do that??
View Replies View RelatedI am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
View Replies View RelatedI have a form and from there I click on link to open a search page, choose an item(checkbox), then that item should appear in the same form I first opened. I tried javascript onClick event such as :
<input type=submit name=submit value=Submit onclick="javascript: form1.submit();">
and also tried:
<input type=submit name=submit value=submit onclick='http://myformurl/form.asp'>
It is only opening a new form instead of the same one. How can I do to choose to pass the value to the same form?
i think this is a simple process but i'm lost on how to format it
page.asp?cnum=Request.form("cnum")something like that?
I have a form that you enter in a file path i.e c:folder1
you then click search and the application will search for that folder and check if it exists if so it will return a list of files in that folder. you are alowed to select what files you want to copie and then enter in the folder you want to copie them to.
here is my issues: i enter in my folder to search on and it is good I get a list of files in that folder I am also given the the folder path at the top of my table. in the code I have also created a hidden field so that when I click on my copy button my from folder path is sent over to that I can us it in my objFile.CopyFile.
NOW Here is where I go *WTF* at the top of my page I am printing out my folder path vartiable and it is right. however once i press that copy button the folder name gets cut off at the space i.e E:flkfkdlsdkklfile2 inforil....
so how do I fix this here is my code I have tryed to highlight the partst pertaing to this issue. Code:
I am trying to pass information from form 1 to form 2 and then write all the information to the db using form 3.
I am writing contact information into Form 2, but making it a hidden field, below are the hidden values that i am passing to form 2: Code:
I am using enctype="multipart/form-data" in my form.
Everything has worked for past 2 years and I have not changed the code in the slightest. (1)
I pass some value to another page and this has worked for as long without any tweaks needed. (2)
Now (2) no longer picks up the values submitted by (1) for some unknown reason. If I take away the enctype, the data is passeed through but it's wasted as the form is to upload a file.
Would any change on the server or network be to blame? What do people suggest?
I'm interested in knowing how to pass the form variables from page 2 to page 3
Page 1
Gathers info via a form from a person.
Page 2
Uses form variables from page 1 to decide what to do next, it then must pass some of the form variables from page 1 to page 3...
Page 3
Uses different Form variables from page 1 which it has been passed by page 2
I have a simple form and want to submit a selected value of a combo box. so my combo box is named "selectname" and my form has action="file.asp?" what do I have to put after the question mark ?
View Replies View RelatedLets say I have a page with 6 different options a user can select, each linking to a registration form. Regardless of what the user picks, they will fill out the same form. The only difference is the title of the Email sent. To avoid having a seperate form page for each option, is there a way to pass a value and put it into the Subject title of the email depending on which link they click?
View Replies View RelatedI want to pass ASP returned values via hidden form fields...
Here is a simpler demo of my what I am trying to do....
Page containg asp values in hidden fields of a form:
(input.asp)
<html>
<body>
<form method = "post" action="ad.asp">
<input type = "hidden" value = "adski" name = "ad1">
<input type = "hidden" value = ""<%= WeekDayName(Weekday(Date)) %>"" name="ad2">
<input type = "submit" value="submit" name = "submit">
</body>
</html>
Output page, showing passed ASP values:
I have IIS server installed on XP-pro. I also have Norton Internet
Security installed.
I can run simple ASP programs without any problem. But when I use forms
with post method and call an asp in action, it does not pass any data
to ASP.
Request.Form method on a form field does not return any value.
This code works on web hosting provider server, just does not work on
my workstation with my own IIS server. Code:
Using DW 8 with 3 frames. I want click on whatever in top frame that uses Go To URL which displays results in bottom frame. My problem is that the results in the bottom frame actually runs a recordset (SQL query) that pulls variables from various form elements in the middle frame.
The middle frame never submits the form variables to the server. It only serves as a resource for the getting variables used in the SQL statement. How do I go about addressing variables in the SQL statement ?
how do I pass a table name in an ASP select stt. as a form variable.
e.g from server side script
Select * from (response.form(group))
I have a page "entry.asp" where a user enters data into a form (named "form"). I want to submit the form and have the data passed to a frameset with two frames (frame1.asp and frame2.asp). I need the posted data from the form to be accessible to frame1.asp and frame2.asp.
View Replies View RelatedI have an asp page which allows the user to scroll through images one at a time created using DW server behaviours, record set and repeat region etc.
What I would like to do is have a PayPal button on the page that can pick up from the recordset necessary fields for ordering such as item cost and description. The part of the code referring to the recordset is below: Code:
Ok, the problem is that when I run this code I need to do error checking, so this is the 2nd page that is accepting information. If I do not get a valid response (ie nothig was checked) I need it to re-ask the question.
Currently the code will re-ask the question, but the 'other' value is not being passed So once I answe the question, it keep looping. I did notice it does this odd loop, where it 'bounces' back and forth, the new answe looks like it gets passed but the ones I did not have to re-ask are not then passed, then they are asked and passed and the other question that was not asked value was notpassed.. Code:
I am trying to pass some data through a form to a mailing script.
The form entry is ...
<input name="width1" type="hidden" value=<% = rsMoreDetails("width1")%>>
and is picked up in the mailing.asp as
width1=Request.Form("width1")
and the mailing script uses...
body_text = body_text & "Option 2 - "& width1 & vbcrlf
The problem is that when the mail is sent and the value is say "14 inches" I seem to loose everything after the first space so it only sends "14"
Am I doing something wrong or this the way it is and if so is there a work around please?
I have a form that is posting to itself. Does the necessary validation on the data.
Once it passes all validation, it is redirected to another page. I need to access the data that was submitted on the first page on the redirected page.
I know you can pass your data along via URL but I am unsure how to access the data once it is in URL form.
I also read that you can use Server.transfer and access your form objects with request.form(var_name).
I am passing a value to a form through the URL as follows:
<A href="http://www.xxxxxx.com/orderone.asp?text="radius">http://www.xxxxxx.com/orderone.asp?text="radius"
On the orderone.asp page, I am reading the value into a text box as follows:
<input name="Template" type="text" id="Template" size="25" maxlength="255" class="body" value=<% = request.querystring("Text") %>
so far it works fine. It shows the value in the text box on the page. I am trying to post this page with all the form fields to a new page that emails all the variables that are on this page. The form tag looks like
<form action="Orderform3.asp" method="post" name="order">
In orderform3.asp, i am requesting the values for all the form fields as follows before emailing all the fields to myself:
strBody = strBody & Request.Form("Account_Name") 'strbody is the variable that adds all the form fields to the body of the email
strBody = strBody & vbCrLf
strBody = strBody & Request.Form("Contact_Name")
strBody = strBody & vbCrLf
strBody = strBody & Request.Form("Template")
Here is the problem...I am getting the email with the values filled in except for "Template" and I cannot figure out why. Is there something that I am doing wrong? i have to mention that there is no DB behind this site...it is just a static web site with an email script in it.
I have a resume form with four separate pages,and on the last page when you submit the form I need it to gather all the information inputed to be sent to an email address.
View Replies View RelatedI have a Function in VB Script that generates a signature. I assign the result to a variable and then need to do a hidden post to an ASP Page for further processing.
Basic functionality is I have a button upon pressing it -- It does the hidden post.
Code looks like this. Please assist with passing this stringToSign variable to the .asp page via hidden post. Code:
i have a registration form where the student must enter their personal info(will be inserted in a personal_info table)then the student have 2 proceed and fill up the next form by entering what subjects he would like 2 take....
now the problem is i dont know how to retrieve the identity number that has been entered in the previous form(personal info) to be inserted in the subject table..
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
View Replies View Relatedhow do i pass form values through a redirect statement to another page. I have a redirect stt. Response.Redirect "exist.asp" and i want to pass form values to be displayed from exist.asp.
View Replies View RelatedI have a page that calls itself using a form. The form has two select elements. In the sql statement I am attempting to match the values of the select element to populate a recordset.
The two fields in teh Access db are of type Text and of type Integer. What baffles me is that one sql statement works fine and the other returns nothing. I am having the issue matching on the bedrooms.
In the first statement I took out all other doo-doo and just matched bedrooms = request("bedrooms"). On the other one I used p.bedrooms but it keeps turning up empty. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
I am using an asp page (upload.asp) to gather information and to upload
files to the web server using SoftArtisans SAUpload Tool. In the first page
(upload.asp), I have a form for gathering info with the following: Code:
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:
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code: