I'm just starting on ASP and I've found it extremely useful.I have a form page where I'm collecting some information - that information I want to have emailed to me and part of it needs to be directed to a Merchant Accounts providers site for user to complete their purchase.
Email part I can take care of using CDONTS and/or SoftArtisans.SMTPMail.Passing the data to Merchant Account Provider (MAP) I can take care of.Doing both simultaneously is a different issue.I would like to have one submit button that directs some info to the email and some to the MAP.
I'm attempting to achieve a couple of things but I don't know if it's possible. I think the following piece of code will help explain what I'm trying to achieve:
<% 'test whether user checked a particular check box when the user clicks the submit button
If Request.Form("mycheckbox") = "YES"
Then 'I want the forms action to post all form data to THIS_PAGE.HTML
Else 'I want the forms action to post all form data to THAT_PAGE.HTML
Is it possible to do more than one action on form submit without using javascript. What i want to do is still submit my hidden form but also send 2 emails, now i can write the email code easily, and the form works.
I need the form to submit to the database, and send a form to an email specified in the email on submit. I have searched the forums on this subject, and found memnoch's example below (2nd code)
I was wondering if this same code would apply to what I already have done here. (1st code) (I don't use strHTML and other parameters for example) Code:
Now I know what your saying check all the posts in relation to using one form for two actions etc, etc. I have done this and am still a little confused.
Using ASP & JS, I have 2 actions:
- The first being to insert a record into a table in a DB - The second being passing the form data to the next page
Now I'm new at this so I know there is a simple solution. Currently I can perform one action or the other using the one button as the code illustrates below:
//Inserting data into a table <form method="POST" action="<%=MM_editAction%>" name="form1">
//Sending data to next page <form method="POST" action="test2.asp" name="form1">
How do i get the same button in the same form to perform both actions?
I am working on this intranet website which includes access mdb for storing employee ratings. In this website I am using table which consists of username and paswords of the users who can log in. So whenver there is a login. the ASP code checks this table for matching results nd then it lets the user in.
Im using sessions to keep track of user. For viewing the records through the browser, I am not tracking the user But I want to record any actions by the user if he is updating the employee tables . SO I have created a seperate table for User_Actions...this table will record..timedayusernametable nameaction( insert or update or both)So every time the user updates or appends and the transaction is committed , this table would be populated.
I have form1.asp which contains a form which is posted to and processed by a page called process.asp.I want to create a second form on form2.asp and also post it to process.asp. On process.asp I would execute different stored procedures conditionally based on where the form is submitted from.How can I tell which page the form is submitted from?
I think I should be able to have a hidden form field on my forms and post that to process.asp.Is there a better or preferred method.?Can I combine these three pages on one asp page?
We have a facility on our intranet where users can log problems, comments & suggestions about the site to a DB.
I'm building a page that lists the outstanding entries, and allows use to mark any number of entries as being 'done'
That is, we have a number of rows, with the last field in each row being a checkbox to indicate the entry has been dealt with. At the end, there is an Update button which submits the form.
The question is.. how to handle this...?
The best solution I have thought of so far is to use the record ID as the ID for each checkbox. Then to Split() the resulting Request.Form into an array, loop through the array picking out the record IDs.
It's not a bad solution, but I figured this must be a fairly common procedure and that somebody might have a slicker way of doing it...
I am trying to have a form that has multiple records on it and the user can check a box on which ones to add to the database. I created the form but cannot get the fields to enter into the database.
How do I post an HTML form to multiple ASP pages? I need to do two things with my data at the same time and it would be very helpful if I could spawn the processes when the HTML form is posted, not through downstream ASP handling.
Assuming the following code actually worked, I'd like to take data entered from one form and post it to two different locations. Hypothetically, I have a server in NY and one in LA that I want to get the same information.
basically what im trying to do is create a form to submit some data to an access db.
In the form i want to be able to have two dynamically populated drop downs (so if a user chooses cars in the first field it comes up with a bunch of car manufacturers, or if he chooses boats it comes up with boat builders etc etc.)
Ive searched high and low, and i the best i can find is javascript to make the drop dows. The java script however uses a form to repost the data back to the page to populate the second drop down. This wont work when its inside a form.
I have a client that wants all his products on one screen, where people can enter the quantities of every item they want and only have to hit one "Add to Cart" button.
So I have an array of results for each products ID number, and quantity amount for each product. How do I loop through those results and add multiple rows to the database?
Users enter data using HTML forms and it gets processed by an asp page that enters the data into the database. What I am trying to do is get a "confirm" page set up that will make sure the form was completed properly. If it is completed successfully, then the data from the form needs to be forwarded onto another asp page that will enter the data into the database.
My question is, what is the best way to forward the information on? Currently I am using querystring to handle this, but that doesn't work in some situations especially when one of my forms has a <textarea> box that seems cumbersome to send via querystring.
Is there a method I can use to easily forward the data from the form to subsequent pages after the first one ?
Well i have pictures in database and i display them all on the page. While i display them i put a button with them each. So that they can be deleted.
But the problem is that. as i put the button in a loop while displaying images. The name of the button is same and when i click the button to post the values to the next page where i should have the script to delete image. All the values of all the images go to the next page.
I want to bind that particular image with that button, so that when one specific button is clicked only the id of the picture binded with that will go to next page.
I can do the job by having a delete link with each image and posting the value to other page. But i have to use the BUTTON to do that. But dont know how to use it.
How do I convert this ASP mailer script to accept and mail multiple fields of a form. This will do one field only )iMesg.TextBody = Request.Form("body") and it works great. Code:
I am going to have a form on one page that will have a bunch of options(checkboxes, radio buttons, text areas, text fields, etc.) and these options are going to deal with a certain category. Each category will have different options. Now after this form is filled out they will then proceed to another page to fill out contact information. Name, Addy, State, City, etc.
Now, after they fill this contact form out they will submit it and then it will go through a database and depending on what state and county they are in it will email the information from both forms to the email addresses in the database that match that state and county(as well as category). Now dont worry I aint wondering how to actually search the db and all that yet.
All I want to know right now is how do you remember the first forms information while you go to the second page to fill out the contact information? Using cookies? What? I dont want the form input to be displayed on the second page, just remembered.
So I will select all my options from the first form and fill out all the text areas and fields and all that then click on the Next button or whatever, then fill out contact info.
How do I get it to retain BOTH forms information, and for now just display both of them on a third page(like I said I will worry about the db query and email crap later). I hope this makes sense.
I loop through a recordset to return values that populate a form which the user can then edit and save. However these fields need to be validated first to make sure the data entered is correct. I have a Firstname field that returns 3 records from my recordset which means when I try to validate, I get an error as the page doesn't know which of the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
I have a database generated form that I would like users to be able to update by selecting a checkbox. Say the page displayed has six records on it and the user wants to delete one or more of the records. They would click the checkbox and hit a "delete" button.
Then the database would be updated and the user redirected back to the page that would now show all the records that weren't deleted. Sort of like Yahoo mail, you get a list of all the bulk mail, select the ones that you want to delete, hit a delete button, and the page is updated to show what e-mail is left. How do I do this using ASP?
I've been trying to figure this out for about an hour now but a combination of my own narrow scope and limited experience, coupled with a general lack of information on this sort of thing has this ASP newbie scratching his head. I was told that the issue with receiving multiple instances of the document is relevant to this chunk of code:
I have a form where the user has 2 payment options. Is there a way to add validation to the form to ensure that at least one payment method is selected? This form does not actually process the payment, just sends the information to the recipient.
I have an .asp page with a form to copy job responsibilites form one job to another. It is a hotmail type interface with checkboxes besides each responsibility. After submitting, it should copy the selected resp's to a different job. After that it should renumber that job's responsibilities.
This is the code I am using now to copy:
copySQL4 = "INSERT INTO jambue.RESP(POSCODE,IDCODE1,IDCODE2,RESP_NUM,RESP) SELECT '" & id & "' POSCODE,'" & dept & "' IDCODE1,'" & unit & "' IDCODE2, '999' RESP_NUM, RESP FROM jambue.RESP WHERE (POSCODE = '" & POSCODE & "' AND IDCODE1 = '" & sourceDept & "' AND IDCODE2 = '" & sourceUnit & "') AND RESP_NUM IN (" & Request.Form("chk") & ")"
As you can see the value '999' is hardcoded in there as the new Responsibility Number to go with the copied responsibility. I use this because there are no jobs with that many responsibilities. This works fine if I only select one resp. to copy over. But if I select more than one that part still runs fine but I get an error with the below. It says too many rows would be affected. Of course, this must be because there are now at least 2 responsibilites with the same RESP_NUM. Code:
I am using this script to submit my form fields into the body of my email:
*********************************************** Dim strBody dim ix, formElementName, formElementValue strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf For ix = 1 to Request.Form.Count formElementName = Request.Form.Key(ix) formElementValue = Request.Form.Item(ix) strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf) Next
*********************************************** I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
I have two forms, one on each page. The user fills the first, then the second, then on the third page all the information is displayed for the user to make sure thats what they want to send.
Then they click submit on the third page and it goes through a database and depending on which category, state and county the user selected it will email all the information displayed on that third page to all the emails in the Email field in the database.
Now, I already have the first and second pages(easy enough) and the third page I can get it to display all the info how I want it and now I need to know how to go about emailing that info to the emails that match the specific fields? Right now all I have it doing on the third page, instead of submitting it for emailing, it just displays the info from the forms AND emails that match from the database. Code:
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2.
I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do...
I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
I've got multiple pages on the same server that all have the same drop down boxes in them. It is a list of all our facilities. Every time there is a change, I have to change it on every page. They are in the format below. Is there an easy way to store all that data in a text file so I only have to update it one place?
I have a table that contains all of the function permissions within a given application. These functions are different sections of a site and each has its own permissions (READ, WRITE, UPDATE, DELETE) which are controlled by a web frontend and the table records are manipulated to control the permissions. Code:
Creating a form that allows people to search a ticket database. One criteria I would like to add is to give the people the option to sort the results by selecting criteria for a dropdown.
My first thought was to create 3 dropdowns with the same name, get the data and add it to the SQL string. It worked great except for when someone decided to leave anything blank. Here are my dropdowns here: Code:
I know there really isn't a way to disable the "back button" on the browser BUT ... I'm trying to not allow multiple entries via a form submit when the back button is depressed on the browser.
Basically is there a code snippet that somebody can provide so that when a form is submitted and somebody attempts to go back by hitting the "back" button, that form information just entered won't resubmit into the database?
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
