Combining 2 Variables In A ASP Form
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:
View Replies
ADVERTISEMENT
I have this query that isn't working for me. This is a simple phonebook (first name and last name) form. Trying to accept wildcards. Here is the statement as I see it: Code:
Query = "SELECT cn,telephonenumber,mail FROM 'table' WHERE (cn = '" & FName & "' OR cn = '* " & FName & "') AND (cn = '" & LName & "' OR cn = '* " & LName & "')"
But this isn't working. Where am I messing up the syntax?
View Replies
View Related
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:
View Replies
View Related
I have 2 SQL strings:
SELECT *
FROM NK_editie " & MM_whereConst & " " & whereClause & "
ORDER BY editie desc
And
SELECT *
FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID
ORDER BY editie desc
Now I want to combine those 2 to one string.
I have problems to set it up in working order.
My tryout:
SELECT *
FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID &
" & MM_whereConst & " " & whereClause & "
ORDER BY editie desc
It shows al the records which are joined, only the second string " & MM_whereConst & " " & whereClause & " is not working.
View Replies
View Related
I've created a web form with multiple textfields for acquiring somes date of birth (i.e. textbox for DD, textbox for MM, textbox for YYYY), now what I'm trying to do is grab the values from these objects and combine into 1 session variable, which later on is inserted into an ACCESS database.How do I append these values together to be one value in a session variable (i.e 23122004). I have a input mask inside the ACCESS database, so it needs to go in this format. I assume once I have captured these 3 fields, I need to convert them to integer, and then merge?
View Replies
View Related
I have a database used by another application, i want to be able to manipulate the data stored in the database, the problem is that the way the information is stored its awkward(assume this is purposely so), but i cannot change the db structure at all, so heres my problem: Each Person in this database will have multiple comments stored against them:
ID | CommentCode | LineNum | ValueData
1234 COMM1 1 Something about thi
1234 COMM1 2 s person seperated ov
1234 COMM1 3 er multiple lines
1234 COMM2 1 Something else about
1234 COMM2 2 them
What i want to do is circle through the recordset and combine the multiple lines of the same comment, any ideas/examples?
View Replies
View Related
I need to take two seperate queries and put them in a single html table, but i want to combine the sets of data 'while selecting them' so i can use the SQL sort by command to arrange the whole table by date..
sorting the two queries independantly then dumping them to the table results in both queries being sorted independantly, ie the most recent entry(by date) of the second set of data ends up in th emiddle of the table.. any ideas?
View Replies
View Related
I am trying to edit data from this form in ASp/HTML but because both the field that I am editing is in the text box that has the same name, it is combining the data from both the field and updating in the table. Is there a way I can change the name of the text box progammically?
View Replies
View Related
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
View Replies
View Related
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
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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?
View Replies
View Related
Could someone please remind me how to get all the form variables in a post?
View Replies
View Related
I 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:
View Replies
View Related
I have a form that loops through a recordst for the following Code:
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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 Related
For 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 Related
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 ?
View Replies
View Related
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??
View Replies
View Related
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:
View Replies
View Related
if iam requesting a form field, how do i trim that to just the first 2 letters Code:
View Replies
View Related
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?
View Replies
View Related
I have an array varibles in ASP script and i want to use these
varibles again in client Script (in VBScript) .
View Replies
View Related
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.
View Replies
View Related
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 Related
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
View Replies
View Related
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:
View Replies
View Related
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 Related
can anyone tell me difference between environment variables and server variables.
View Replies
View Related
