Sending Data To Processor Page For Use In SQL Statement?
I have a form page with a drop down menu of article types that can be submitted. On my processor page where I enter the article, I want to be able to send an email to the person who is responsible for those article types, letting them know a new article has been submitted. I have a table set up in my access database, with an article type and email associated with that which I would like to send an email to.
On my processor page, i would like a SQL statement something to the effect of:
SELECT * FROM table_artemail WHERE art_type = request.form(art_type)
but i can not seem to get it to work.
Also, when I get that working, i plan on using cdonts to send the email. can I just create a variable called "mailto" and have a statement such as: Code:
View Replies
ADVERTISEMENT
I've been setting up an online payment system for our site, and it all works fine except for one part. When it submits to the merchant's site, the customer is greeted with a blank page for a few seconds while it verifies the card. Then it redirects to our site.
Is there any way to do a form POST to another site without actually making the browser go to that page?
View Replies
View Related
I have a SelectBoxes.asp page that is working with multiple selection
dropdown boxes to extract data and total the selection prices.
Tom & Bob were kind enough to give me a big help getting this page
working and it's working just fine, no problems with this page.
However I then would like this data e-mailed using jmail (my host insists
on this method) and that is the function of the sendEMail2.asp page.
This is failing and only giving me a HTTP 500 - Internal server error and
I'm at a loss as to what's wrong. Code:
View Replies
View Related
my asp application is running slow . I was just wondering what are the requirement as far as ram and processor.
View Replies
View Related
On a heavily visited site, .ASP pages stop being processed/displayed, but .htm files are processed and displayed just fine. IIS appears to be running OK. No errors or logs anywhere to be found. Reboot clears it up, for a few days. Any clues?
View Replies
View Related
I have a form with dynamic checkboxes, and normal text boxes. If the user doesn't fill out the required items and submits the form they get returned back to the form with their checkbox selection gets lost.
How do i retrieve the values already checked and placed them back.
View Replies
View Related
i used a check box in a loop:
<input type="checkbox" name="Inv" id="Inv" value="<%= rstMain("TR_ID")
%>">
n transfered the value to the next page...wats the best way to transfer
the data to a 3rd page
View Replies
View Related
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
View Replies
View Related
How can I through asp figure out if a page is opend through a regular link
or from form post method like this :
<form action="something.asp" method=post>
//code...
<input type="submit" value="Ok">
</form>
View Replies
View Related
Right i got the login page working, on my main page i have a big table in the middle with a few small tables either side of it, one of the smaller tables has a form where you can search a database, is it possible to have the results of the search appear in the main table? and is it difficult?
View Replies
View Related
Does anyone know how i could send bulk info from a database to an email? Like an order confirmation for more than one product? or where i could find some info?
View Replies
View Related
I've been asked to take data from a form and then send it to a vbscript. The client
has made a vbscript that performs a calculation (i haven't been told a great deal
about it yet) and now they wish to put it online, so that when a user enters
data into a form, it sends the data to the relevant fields in the vbscript.
I don't know a great deal about Visual Basic, so if anyone could explain how i might be able to go about this ..
View Replies
View Related
Im doing an asp.net-application where we have an external asp-form in a iframe on the mainpage. On submit, the form sends its data through method="get" to a page with a frameset (i couldnt get the data through POST).
In the framsetpage, the data is receieved in the frameset and then sent to the lower frame through querystrings. The lower frame is also an external asp-page.
My problem is this, the .NET-platform is using utf-8 and some other way of URL-decode things then the old platform did. So for example the swedish letter 'Ö' is in .NET URLdecode '%c3%96' and in the old asp-way '%D6'. The asp-page has no idea what '%c3%96' means so the formdata is a bit corrupted on arrival.
What i was wondering is if there are any ways of convert the new way of urldecode strings to the old way? Preferably in C# since thats the site's main programming language.
View Replies
View Related
The following script sends form results in an html email. It causes each form field result to have exactly the same html. I need it to have unique html for each form field result. Can you help???? I tried changing the for each statement to a for statement but couldn't figure it out.
The original code is : (from Brainjar.com - I emailed them but they did not respond)
body = "<table border=""0"" cellpadding=""2"" cellspacing=""0"">" & vbCrLf
for each name in fieldOrder
body = body _
& "<tr valign=""top"">" _
& "<td><b>" & name & ":</b></td>" _
& "<td>" & Request.Form(name) & "</td>" _
& "</tr>" & vbCrLf
next
body = body & "</table>" & vbCrLf
View Replies
View Related
I have sent form data through email using .asp before but I have never done it when you are using a form that has createelements involved. I have a form w/ 3 inputs, two text inputs and one select combo box. if i click an add user button it will appear with another row of 2 text boxes and a combo box, and you can repeat up to as many as you need. I am trying to figure out how to mail all of those values to someone. Is there an easy way. Below I will attach the code that I use to name the fields when they are generated maybe it will help....
<SCRIPT language="javascript">
counter = 1
function addRow(id){
var tbody = document.getElementById(id).getElementsByTagName("TBODY")[0];
var row = document.createElement("TR");
row.setAttribute("id","tr"+counter);
var td2 = document.createElement("TD");
var input2 = document.createElement("INPUT");
input2.setAttribute("type","text");
input2.setAttribute("name","pName"+counter);
input2.setAttribute("id","name"+counter);
td2.appendChild(input2);
var td3 = document.createElement("TD");
var input3 = document.createElement("INPUT");
input3.setAttribute("type","text");
input3.setAttribute("name","userName"+counter);
input3.setAttribute("id","prc"+counter);
td3.appendChild(input3);
var td4 = document.createElement("TD");
var input4 = document.createElement("select");
input4.name = "Role"+counter;
input4.id = "Role"+counter;
option = document.createElement("OPTION");
option.value ="Admin";
option.text = "Admin";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read";
option.text = "Read";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read/Write";
option.text = "Read/Write";
input4.add(option);
td4.appendChild(input4);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
tbody.appendChild(row);
counter++;
}
</SCRIPT>
View Replies
View Related
I have a form that is being sent over to an asp page. About 5% of the time, the form fields are blank when the ASP page is reading them. But when the user hit the submit button, they were not blank, because I have client-side validation that will not allow the submit to occur if any of the fields are blank. When this occurs, all the fields in the request.form object are blank?
View Replies
View Related
I have a member registration form that when the user clicks the submit button the form info is sent to a file name validate.asp.
The file validate.asp checks all the information to see if it correct and now I would like to have the data that was submitted added to an access database named members into a table that I named reginfo (registration info) and I have tried numerous ways to do this and spent countless hours browsing through websites but cant seem to get it to work. Code:
View Replies
View Related
I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).
Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.
View Replies
View Related
im a bit of a rookie and i couldnt find anything using search,how can i have a statement which selects only the records which contain data.
Code:
sSQL = "SELECT * FROM VIEW_COLLECTION " &_
"WHERE (BusinessID = 20) AND (Parentid = " & objRScats("CategoryID") & ") " &_"ORDER BY CollectionName"
Thats what i currently have. This is for the page navigation - and i dont want a those collections that do not have any data to be diaplyed - but i do not want to delete these records altogether just yet.
View Replies
View Related
I'm trying to "post" a form in asp to a script off the main site.
I suppose I could do a response.redirect to the script, but am wondering if there is a more direct way to do it. Something like the XMLHttp obj in js.
View Replies
View Related
I'm working on a few intranet pages and have a doubt on how to send e-mails ( i have the aspemail component installed) to outside clients including the invoice for services payment.So differently from Intranet issues where you easily provide a link embeedded on the e-mail, I can't figure how to show the info from outside offices network.
Does anyone knows how to do it? perhaps printingscreen the html page by code and then send to the client as a embedded image or something....?
View Replies
View Related
Is there any simple way of doing this? I want to redirect my end users to a
"results" page that lists the details of their order, but I also want to
e-mail them the exact same think (not a link). All of my end users have
HTML e-mail enabled, and I know that I could just create an e-mail manually.
But, I was curious whether I could do this in a much easier fashion.
View Replies
View Related
I want to send mail from my ASP site but my ISP do not allow local mail servers. How do I do to relay mail through ISP:s mail server?
View Replies
View Related
I have an ASP page that sends an email using JMail:
set msg = Server.CreateOBject( "JMail.Message" )
It works fine in my local server, but when I send my ASP page to Network Solutions it doesn't work. I guess it is because I can not run the JMail installation program at their server, therefor the object can not be created. Is there another tools I can use instead. Something that doesn't require installation, I guess.
View Replies
View Related
What I am trying to do is send a variable from one page to another. Now my first page is setup as follows: Code:
View Replies
View Related
i going to execute this sql statement...and the error come up.. why?
Select * From members Where ID = '123'
pls note that the type of ID is autonumber
is it becoz of type of ID is autonumber? how to solve this problem??
View Replies
View Related
I'm having trouble with this Len statement. I want it to check to see if a user entered more than 3 characters in the input field. This works, except if the user doesn't enter anything... which I'm assuming is 0. Code:
View Replies
View Related
when sending my search criteria with a percent sign to a page that opens an excel sheet, it doesn't recognize the percent sign
ex. i enter %ABC but the value sent to the next page is just ABC
here is my excel button that sends the info to the next page. how do i handle cases where a percent sign is entered? is it handled in this page or would it be handled in the page that handles the excel? ....
View Replies
View Related
I have a page that allows user input. On click of the submit button I call a javascript function that verifies that all of the fields are filled out and then submits the form. I need to add code after the verification that creates and sends an email. I know how to do this in VBscript, but don't know how to call a vbscript function from a jscript function (is this even possible?).
View Replies
View Related
I have data from page 1 that I want to pass to page 2, either in a querystring or a form. I got that part.
Once I'm on page 2, I can retrieve that data with Response.Form or Reponse.Querystring in the vbscript code I have up in the header, but if I write
Document.Form1.Textbox1.value=response.form("passedData"), nothing happens.
So I thought that the code up in the header doesn't "see" the textbox, because as I dimly understand it, the textbox is client-side and the script is server-side. So then I thought I should put the same line down in the html where the form is defined (enclosed in <% tags). But that triggers an error because the code down there doesn't seem to know what response.form is anymore! I tried using a variable as a go-between, but it didn't change the results.
So how in the world do I get my incoming parameter (whether form or query string) to go and live in a textbox in the target page? I need it there (don't I?) so that I can later pass it along to page three (among other reasons).
In short, I can get strings passed from page 1 to page 2, but then page 2 doesn't seem able to put them into controls or pass them along to page 3.
I have scoured google and forums and seen some responses that involve about 30 lines of code (which I don't understand). Surely it can't be that complicated to pass a string from page 1 to page 2 and then have it available to pass along to page 3.
View Replies
View Related
when sending my search criteria with a percent sign to a page that opens an excel sheet, it doesn't recognize the percent sign
ex. i enter %ABC but the value sent to the next page is just ABC
here is my excel button that sends the info to the next page. how do i handle cases where a percent sign is entered? is it handled in this page or would it be handled in the page that handles the excel? Code:
View Replies
View Related
I'm trying to send mail from my asp page and I get this error:
CDO.Message.1error '80040213'
The transport failed to connect to the server.
/Action_Item/action_items/post_new_action.asp, line 50
I tested it from home and it works fine the my local machine but when I tried to use it on the win2k server at work I get this error.
Here is the code: .....
View Replies
View Related
I wrote an ASP code to send email in ENglish and it works fine but when I try to use the same code to create an email message in another language, it doesn't work. (I tried to define the code page also but the email message just displays question marks in outlook express.
View Replies
View Related
