search.asp uses a form to pass two variables ysColu (column name) and ysText (the text being searched for) to result.asp, result.asp then displayes a list based on the two variables.
This all works fine, however whenever the "Next" button is used to page through the recordset the variables reset to their default values. I was wondering is there any way to fix this? Code:
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "DSN=alpha;UID=alphamtgo;PWD=ppjlmqc"
server.mappath("databasecards.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
Set Session ("alpha") = MyConn
sql = "SELECT * FROM [7th reg]"
rs.Open sql, MyConn
%>
this is my error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
/7ed.asp, line 11
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
I have a form with 2 text boxes, when submitted the content is written to a database. Basically it's a page builder, one text box has the name of the page, the other contains the text.I have built a preview page which I want to pass whatever has been typed into the text boxes to, before the form is submitted. Basically what I want to do is pass them as variables to the preview.asp page.
Anybody know how I can do this? The text box names are 'title' and 'text' E
I need to do something very basic. I need to gather information from a form, and when they click "submit", it will take their input and add it to a URL string.
In other words:
Name:
Company:
Click Submit
Goes to http://www.yadayada.com/tom.asp?name=XXXXX;company=XXXXX
How can I do this simple task
It appears that form that I have used for months has stopped passing form variables (via POST) to my asp results page. I have been working through various problems, all caused by the installation of Microsoft XP SP2. I am assuming that this is yet another security issue, but don't know what I should set to overcome this problem.
View Replies View RelatedI need help on how to do the following:
1. Submit a form from a.asp to b.asp (arbitrary names)
2. Have b.asp redirect to either c.asp or c2.asp which is decided by a form field gotten from Request.Form("Field")
3. Have all the previous form data available in c.asp
What I need to know how to do is declare the variables from the form on a.asp on b.asp so I can view them on c.asp.
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?
Could someone please remind me how to get all the form variables in a post?
View Replies View RelatedI have created a form, which has hidden fields, which are to be passed to a payment gateway using the POST method.
My problem is that the variables in the hidden fields do not get passed on to the payment page when the form gets posted. The payment page comes up empty.
Does anyone know why this is happening? Code:
It's regarding an ASP FORM for the credit card process:
I'm collecting credit card information on my secured server. When collecting the Month and Year values (for the expiration date of the card) with Select/Option tags, I don't have a way to concatenate them together prior to submitting the form so I can post them in the format the gateway asked me for (e.g. "mmyy" or "mmyyyy")
Do you have a way where I can submitt those variables togehter in such format? Code:
I have a form that loops through a recordst for the following Code:
View Replies View RelatedI'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 form that imputs several variables. Some of these variables are varchar some are smalldate and some are numbers.
What is the recommended method of handeling input that does not fit the required variable type? I am thinking of doing some kind of check and if it is not the required field type just dropping that value (for instance if they type "aaaaa" into a date field I would just turn that variable into "").
I have done a search and came up with many great methods of doing this, but what is the best way? I would like to avoid large Java routines (actually I would like to avoid java all together.
i having problems with calling variables which are sent via a form using the 'post' method. I'm actually using a Flash form to pass the variables. The problem i'm having is reading those variables in the ASP.NET query. I'm using C#. Here is the code i'm using: Code:
View Replies View RelatedFor some reason i keep getting empty values in my form variables, if anyone can spot a reason why then please tell me what I'm doing wrong. Code:
View Replies View RelatedUsing 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 ?
I need to flush the form variables after submit. The problem is that the form variables retain their values on page refresh.
I added the following at the top of the asp code,
<%@ LANGUAGE=JAVASCRIPT%>
<%
Response.Expires = -1
Response.ExpiresAbsolute = "Jan 1, 1980 "
Response.AddHeader ("pragma","no-cache")
Response.AddHeader ("cache-control","private")
Response.CacheControl = "No-Store"
%>
But it doesn't seem to work! Any suggestions??
I 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:
if iam requesting a form field, how do i trim that to just the first 2 letters Code:
View Replies View RelatedI 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 an array varibles in ASP script and i want to use these
varibles again in client Script (in VBScript) .
My page shows details of a work request. It has a number of buttons: one to go to a search page, another to make a copy of that page, and so on.
What I want the user to be able to do is, click the 'Copy' button and have the details from that page passed to ANOTHER page, ready to submit a new request. Basically, it's just a quick way for users to submit new requests, using a previous one as a sort of template.
This all works using a client-side function in the details page, which simply calls the submitting page using document.submit. However, this uses the same browser window, overwriting the "old" page.
I want a new window to open and have it read the session variables created by the details page. I've tried 'meta http-equiv='refresh' content=1...' and, while that opens a new window, it doesn't read the session variables. Similarly, the gazillion JS scripts I found on the web do pretty much the same thing.
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 RelatedI 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 have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies View Relatedcan anyone tell me difference between environment variables and server variables.
View Replies View RelatedI'm not sure how to best describe my problem, so a simple example should help explain things:
I have two arrays, called set1_data and set2_data
if I create a variable like so:
firstPart = "set1"
and then assign like this:
copyOfArray = firstPart & "_data"
how do I make copyOfArray reference the set1_array, as opposed to just a string "set1_array" which is what it's doing?
I've had a good rummage round ye olde Internet but couldn't find anything there must be a keyword or function to achieve this?!?
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:
I have a form as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
In my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:
<form name="form" method="post" action="RegDetails.asp">
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
http://javascript.internet.com/forms/val-pass.html
It works fine in a new blank page with the form action:
<form name=myForm onSubmit="return validatePwd()">
The final stage in this javascript demo form displays an alert box:
else {
alert('Nice job.');
return true;
When I change the first line of my original form to:
<form name=myForm onSubmit="return validatePwd()">
how do I get my original action of - action="RegDetails.asp" instead of this alert box?