How To Display Multiple Form Fields In Email Using This Script?
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:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
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?
View Replies
ADVERTISEMENT
I have created an email form in which all fields must be completed. If all the fields are not completed "submit" causes a refresh using response.redirect, Problem is allthe fields that were previously filled in are empty.How do I keep the values of the fields on refresh?
View Replies
View Related
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.
View Replies
View Related
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
View Replies
View Related
i already create a code to request all fields from a previous page form using the next function y separate the fields with the value of each one. Code:
View Replies
View Related
I finally figured out how to get my form to its database and have an
email come my way. However I am now trying to set up the body of the
email to include the form details. However the body of the email that
is sent only includes the last line of the "body" tag and has no
details next to it. Code:
View Replies
View Related
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
I need to set up my front end app to update multiple fields with the same entry. See below.
Database: Testing
Columns:
Recdte
Invdte
So in this case, the user would need to update the Invdte with the current date for all rows where the Recdte is a given value. I know how to do this in SQL but not in ASP.
View Replies
View Related
I want to build a site that I can manipulate from Access and have the changes show up on the ASP page.
For Example:
I have Table A that has four fields in it.
ID
Name
Date
Phone
I change the table to include another field, say SSN.
Is there a way that I can build my ASP page to do a loop everytime it opens to looke for new fields and display that as another part of the page?
I understand loops and If statements I just need to know the right code for listing the fields of the recordsource.
View Replies
View Related
I have been given the task to create a search page to search on of the tables in the sql database. I have been asked that the user should be able to search any field(which I
have done) but he should also be able to customise the form to display or hide any feilds in the results.
My table has about 20 feilds and different users wanting to you the search page will like to see different set of fields.
View Replies
View Related
how to inner join multiple fields.
I have 1 table SCHEMA1 wich contains:
id|wedstrijd|speler1|speler2|speler3|speler4
1 1 1 2 3 4
2 2 2 1 4 3
The other table SPELERS contains
id|speler|naam
1 1 Jan
2 2 Piet
3 3 Klaas
4 4 Henk
I would like to have te next result:
wedstrijd|speler1|speler2|speler3|speler4
1 jan piet klaas henk
2 piet jan henk klaas
Can anybody help, because i'm lost......?
View Replies
View Related
Is it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies
View Related
how do i add afew items into a database of only a field name?
for example if there is only item_1.. it will add item_1 only. but if there is item_1 & item_2. how do i add them to the database name ("Items No")?
View Replies
View Related
i have two tables:
Employee
TokenID (pk)
...
..
Rating
TokenID (pfk)
...
...
I want to display all fields from both tables ..
but TokenID should come once as it a foreign key in Rating table..
what would be the resultant query
View Replies
View Related
I have 4 number fields in the same table and need to display the lowest number from all 4 fields, is this possible?
View Replies
View Related
I have 4 tables first table category (category_id and category name in it)
second table artist (artist_id, category_id, artistname in it)
third table album (id, artist_id, album_title in it)
forth table song (id, album_id, title in it)
I'm selecting category in first page
I'm selecting artist in second page
I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page
2- artist name when I was selected in second page
3- album name when I was selected in third page
View Replies
View Related
I've got 4 records in my lovely database table. The table contains 5 fields, lets say: id, number, name, age and sex. All I want to do is to get all the values (form all 4 records) of the "number" field and put all 4 of the values in to one variable.
The output have to look something like this : numbers: 001, 002, 003, 004.
I tired, honestly, I really did. But didn't find a solution.
View Replies
View Related
How to create multiple text fields and will be submit when press a "enter key" ...
View Replies
View Related
Is there any way that I can break up text in a text field to spread across multiple fields in an access database? I've got a FAQ section that I want admins to be able to edit via an online interface. Unfortunately, it often doesn't fit into the 255 character restriction that access has. Any ideas?
View Replies
View Related
I'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies
View Related
I have multiple fields (BLM, WHM, RNG, MNK) each with a numeric value. How can I search across these fields for each record and find the highest number.
Example:
Name BLM WHM RNG MNK
----------------------------------
Jason 19 52 33 18
What I want it to do is return and display Jason WHM 52
And I want to do this for every record in the table.
View Replies
View Related
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies
View Related
Can anybody give me some tips on the best and/or easiest way to display
multiple lines in a field. The data is collected from a "textarea" field
when the form is submitted, and I want to display all of the data (multiple
lines) in a resulting HTML page. The data displays on a single line
(obviously) and does not wrap without manipulation of the string variable.
Is there an easier way to display the data?
View Replies
View Related
The object I have is a barcode:
<%
RMABarCode = Session("rmaID")
IF Len(RMABarCode) Then
response.write "<img src='barcode.asp?code=" & RMABarCode &
"&height=25&width=1&mode=code39'>"
End If
%>
But I need to be able to display that barcode multiple times.
Say the user needs 4 displayed, he/she will enter the number and it
shows that many.
View Replies
View Related
how can I display multiple access data on hyperlink in ASP?? For example like I click on Monday link it will only display all the informaton about Monday and click tuesday will only display tuesday information on same page.
View Replies
View Related
I have let say 100 record from database, then I wanted to display in 4 columns, so each column will have 25 records. hot to d that?
View Replies
View Related
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour
2. user selects minute
3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
Here is the asp code for the form: ......
View Replies
View Related
I have an asp page which has a number of form fields on it (about 50). 2/3rds of these fields are used to store username (windows username) and date (todays date). I want these fields to be locked so the user cannot enter any info into them. The infor will be grabbed from the current user and the current date.
However, I only want these fields to be populated only when the left most field is changed. Once the fields have been populated the username and date fields will change with however is logged in and the new date.
View Replies
View Related
I have a form that will be filled out by users, what I would like to do is when the user selects a state from a dropdown list i want to have the City field show select options based on their state. I know this can be done but I dont remember how.
View Replies
View Related
I am having a problem formatting an email message which comes from a form.
I am currently having difficulty with the <br> tag which I am using for line spaces within my email. I am getting an expected statement error message which is pointing to the line which is underlined below. I can't think what is causing this.
The code for my processing page is below:-
View Replies
View Related
While I can extract the option value from the following:
<Select name='Keystring' MULTIPLE>
<option value='1' name='status'>Pending</option>
.....
</select>
I cannot seem to extract the corresponding 'display' value when I do a
For...Next Loop:
for each keystring in Request.Form("Keystring")
keystring=request("keystring")
Next
How do I aslo get hold of that 'display' value eg 'Pending'...is it
possible?
View Replies
View Related
I need to loop through all submitted form fields and place them all into 1 variable but i have no idea how. Here's what I have so far:
for each item in request.form
myVariable = "formfieldname:" & item & "formfieldvalue:" & request(item)
next
response.write(myVariable)
The problem with that is that response.write(myVariable) only prints the last field in the form.
I know that if I move the response.write(myVariable) INSIDE of the loop it will print correctly but I am not trying to print the form fields BUT I AM TRYING to store them in ONE variable.
For example:
myVariable = formfield1name:formfield1value:formfield2name:formfield2value:formfield3name:f ormfield3value:ETC ETC
View Replies
View Related