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 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?
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:
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.
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?
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?
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?
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?
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.
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 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.
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.
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:
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:
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 ?
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:
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?
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.
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?
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 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.
