Db Insert And Form Email
I have a form that performs a db insert (through a Dreamweaver server behavior) . After the insert, the page is redirected to a page where the form information should be mailed to a specific email address - request.form("dlEmail")
Is it so, that when I do an Insert statement, the request.form - variables get erased or so? I don't manage to get the email working. It inserts the info ok, but when coming to the sendmail.asp page, I try to refernence the different form fields, and they all appear empty.
View Replies
ADVERTISEMENT
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 having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
View Replies
View Related
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
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
How to do i send database information to an html email using ASP?
View Replies
View Related
I have a form that I created via DW that inserts data into a db. I also have code that I want to use which will email the results of the form. However, I have no idea how to combine the two functions (insert and email) into one page of code. Is there a way to merge the two? Where would I put teh email code? Code:
View Replies
View Related
Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:
the variable for the second email address is EmailFrom2
'validation
Dim validationOK
validationOK=true
If (Trim(EmailFrom)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom)
If (Trim(Name)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("nameerror.htm?")
If (Trim(CityState)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("citystateerror.htm?")
If (Trim(SchoolName)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")
View Replies
View Related
here is the script i use:
Set myMail=server.CreateObject("CDO.Message")
myMail.Subject="subject"
myMail.From="me"
myMail.To=request.form("email")
myMail.TextBody="hello"
myMail.Send
set myMail=nothing
this script sends emails to some addresses but not others--and its based on the email service it's sending to. for instance, hotmail email addresses get the email, but mail.com email addresses dont get the email. i have tried sending it to other email hosts, too, and still, some work, some don't. what is going on here?
View Replies
View Related
I am geting this message when INSERTING a form.
Microsoft JET Database Engineerror '80004005'
Operation must use an updateable query. /admin_pportfolio_bl_insert_processor.asp, line 8
the code on "admin_pportfolio_bl_insert_processor.asp" is Code:
View Replies
View Related
Im having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
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
<%@Language=VBScript %>
<%option explicit%>
<%
MESSAGE = (Request.Form("type"))
MESSAGE=MESSAGE & vbcrlf & "Name" & (Request.Form("name"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("address"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("handphone"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("phonenumber"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf & (Request.Form("comments"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf
MESSAGE=MESSAGE & "____________________________________________"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From =Request.Form(email)
objMail.To = "icepricessa@hotmail.com"
objMail.Subject = "Business/Career Enquiries"
objMail.Body = ""&MESSAGE&""
objMail.Send
Set objMail = Nothing
%>
but somehow i'm not able to send the mail....
View Replies
View Related
Someone have a script to insert dynamic items in the form?
For example...
In my default form have 5 textboxes... I need to put a button to users to "add new item"... and add textboxes to the form.
View Replies
View Related
I have about 30 names of workers (and their IDs in hidden fields, that depend on their departments) in one form, beside them there is one dropdown list for each worker, with same items. I want to select item from dropdown list for each worker, that will write item ID in another hidden field... and then I want to submit worker's ID, ID from dropdown list etc....into another .asp page and sql db.
If I use next way :
<%
FOR EACH name IN Request.Form
Response.Write("<BR>")
Response.Write(Request.Form(name))
NEXT
%>
I get only values of IDs from dropdown lists. But I need workers' IDs, too.
View Replies
View Related
How would you go about inserting data from two forms into one record? using access/javascript
View Replies
View Related
I am trying to make a page post.asp with a form that simply submits one text value and two hidden values into a table. I already have the function that takes the 3 parameters, modifies them and successfully inserts them into the table:
I have included this function in this post.asp page ...
View Replies
View Related
I can't seem to get this page to work. Its a basic form (with a lot of fields) and I need to insert part of the data into one table and part into another. Here is what is at the top before the <html>
tripreportR.asp
Code:
set
The form's action is to post to itself. I can't get the data in and I can't even get the page to show now. Any suggestions, ideas, links, resources would be great!
View Replies
View Related
I have a text area on a form. I want the user to be able to type in text and where they want a line break to hit the return key in the text area. On the submission I want to replace those carriage returns with html code like <br /> Can this be done?
View Replies
View Related
has anyone here had problems trying to retrieve form elements from a dreamweaver insert form? Code:
View Replies
View Related
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
View Replies
View Related
I have this page set up at www.kevinhall.org/headcount/headcount.asp
what is the easiest way to check where the user has entered a value
and submit the row to the db. Maybe i'm going about the form wrong.
Each box has its one name but I was hoping i could get around using a
request.form on each one and useing the isEmpty. Its so tedious and
non efficient there has to be an easier way.. Maybe with .net possibly?
View Replies
View Related
I have a project where i have to use an html asp application form to insert records into an sql database. My problem is finding resources online to practice with to learn, i have basic knowledge of ASP and have attended the microsoft 1 week course on Administering a 2000 SQL Database and i have designed a few small sites so i know html and javascript. I have the database side covered its just the VB code to take the form values and post them to the sql database.
I was wondering if anyone could point me in the right direction of sample codes to play around with as i cant seem to find any which relate to this project.
View Replies
View Related
how can I insert a javascript value in to hiddne form field? I have to use this vlaue in a asp page.
View Replies
View Related
I'm trying to insert records into an SQL database coming from a page using the request
..form method. The table "general" has a primary key 'geid .' I get the following error:
Cannot insert the value NULL into column 'geid', table 'general';
column does not allow nulls. INSERT fails.
....not sure how to include the 'geid' field into the scheme.
strSql = "insert into general (firstname,surname,company) values ('"
strSql = StrSql & Request.Form("firstname") & "', '"
strSql = StrSql & Request.Form("surname") & "', '"
strSql = StrSql & Request.Form("company") & "')"
myconn.Execute (StrSql) ....
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
When you submit the form you can see I am trying to get the each row of the form elements into a format such that I can build multiple insert statements. Here is what I am working with:
<%
Dim x
For x = 1 to Request.Form.Count
Response.Write Request.Form.Item(x)
Next
Would I use some type of Mod operator on the value of x to determine my line breaks?
View Replies
View Related
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:
View Replies
View Related
i want to create an email form in ASP that can send emails to one and if possible multiple email addresses.
1. what requirements do i need. ie. web hosting .etc
Is it possible to make a form with a dropdown box for the different email addresses?
does anyone know where i can download a copy of something like this or have a copy themselves?
It can be just a simple type in your name, comments and submit form. just anything that works and how i get it to work.
View Replies
View Related
Does any one have working or sample scripts that will retrieve a form information and send that information to a specified email account? eg. a data request or a user comment form.
View Replies
View Related
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Option Explicit
Response.Expires = 0
'you need to set up a variable (declare variables) for each filed fron your form page
' what I like to do is use the exact same name and add str for string to the beginning of it.
Dim strFirstName
Dim strLastName
Dim strAddress1
Dim strAddress2
Dim strCity
Dim strState
Dim strZip
Dim strEmail
' After you declare the variables you need to assign a value to each one.
' each variable will be assign the corresponding value being sent from the form
'If you need other form fields, declare them above and assign a value here, Just
'follow the same format......
View Replies
View Related
We run a small web ministry.
Our hosting company doesn't allow PERL, only Bamboo.SMTP and JMail asp's. (myhosting.com)
Our need? Turn the prayer request forms to an email that can
1. either send a different email to the requestor OR BCC an autoresponder we can set up.
2. BCC an email exploder on our mail system
3. make the FROM the requestor (done) and the TO: a 3rd email name on our system.
I see someone asked about a BCC function on Bamboo (none found), but the JMAIL set up we put up successfully executes but no emails are sent.
View Replies
View Related