Syntax On Passing Variables From Email Form To Insert A Database...
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
ADVERTISEMENT
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 think this is a simple process but i'm lost on how to format it
page.asp?cnum=Request.form("cnum")something like that?
View Replies
View Related
I'm interested in knowing how to pass the form variables from page 2 to page 3
Page 1
Gathers info via a form from a person.
Page 2
Uses form variables from page 1 to decide what to do next, it then must pass some of the form variables from page 1 to page 3...
Page 3
Uses different Form variables from page 1 which it has been passed by page 2
View Replies
View Related
I having a problem with the CDO syntax I guess. Here's the code :
<%
response.buffer = true
message = "The following data was submitted:"
message = message & vbcrlf & vbcrlf
for each item in request.form
message = message & item & ": " & request.form(item) & vbcrlf
next
'Create message object
Dim objMessage
Set objMessage = Server.CreateObject("CDO.Message")
objMessageTo = "billy_fong@hotmail.com"
objMessageFrom = request.form("email")
objMessageSubject = "Message from the website"
objMessageBody = message
objMessageSend
set objMessage = nothing
response.redirect "confirm.asp?msg=" & Server.URLEncode("You have successfully sent your quote, thank you")
%>
The error was on the objMessageSend. What's wrong with that? Actually there was another form file which called to this asp file.
View Replies
View Related
I am connected to a database which is perfect, and I am displaying the values of the database on my initial ASP page which is cool aswell. However I am trying to also pass these values to other ASP pages. THus I am keeping away from opening up the database connection on the other pages to retrieve the same values.
I have been doing alot of searching on the net but it all seems to be about passing user input between forms. There is no user input in my site. I want to pass database values. I have been using the Form Get or Post methods but cant get it to work. Am I going the right way?
View Replies
View Related
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 ?
View Replies
View Related
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:
View Replies
View Related
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?
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 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
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
Lets say I have a page with 6 different options a user can select, each linking to a registration form. Regardless of what the user picks, they will fill out the same form. The only difference is the title of the Email sent. To avoid having a seperate form page for each option, is there a way to pass a value and put it into the Subject title of the email depending on which link they click?
View Replies
View Related
How to do i send database information to an html email using ASP?
View Replies
View Related
I have a resume form with four separate pages,and on the last page when you submit the form I need it to gather all the information inputed to be sent to an email address.
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
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
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 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:
View Replies
View Related
i made this asp script that should email and insert the data into a database but somehow i don't think I've done it right. Code:
View Replies
View Related
ive made the most simple page in the world in ASP, and I cannot for the life of me figure out why this page doesn work. whenever I try, it comes up woth "syntax error in statement".. Code:
View Replies
View Related
I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ORG/HRM/medewerkertoevoeg.asp, line 50
I treid different solutions but here is the code:
View Replies
View Related
can anyone resolve this syntax error?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon ( at end of SQL statement. Code:
View Replies
View Related
I read through your posts and also other forum about this error and I did what was said but I still get this error:
INSERT INTO feedback ([pname], [email], [comments], [outcome], [additional], [try]) VALUES (
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/room20/survey.asp, line 33
I even put everything in brackets, just to be on the safe side for reserved words.I did not do Word Wrap, so everything is on one line. Complete code is as follows: Code:
View Replies
View Related
Now I know I posted this elsewhere twice but no one seems to even be looking at them. I really am stumped by this problem.
I recieve the error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/quizmaker/admin/create_teacher.asp, line 20
DIM mySQL
mySQL = "INSERT INTO users(user, password) VALUES('"& uname &"', "& pword &")"
USERS1.open mySQL , objConn <----- Line 20.
View Replies
View Related
Syntax error in INSERT INTO statement.
Please download the attachment and unzip it.
I have 4 files:
Starting with "signup.asp" - fill up the registration form. this will forward you to next form.
"signup_process.asp" - process the filled form
"signup_success.asp" - indicate that register successfully
"Database.mdb" - the database file (MS Access 2000 format)
My problem occurs in "signup_process.asp".
The error message found in IE:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/myweb/signup_process.asp, line 31
I look through my code, but found no mistake.
But why still I cannot add the information in the form into the "Database.mdb"?
View Replies
View Related
I've see this error message when I try to submit my form..
Help with Syntax error in INSERT INTO statement. line 153
Here's the SQL Code:
View Replies
View Related
My Code is as follows, im basically trying to get the value from a radio button from another page for a vote, take the value thats allready in the table add 1 to the value and then insert it back into the database, then create a voted cookie and redirect back to the same page to view the vote results. Code:
View Replies
View Related
I am having a problem with an insert statement. I keep getting the following error:
2147217900 Syntax error in INSERT INTO statement. Here is my SQL statement:
INSERT INTO Notes (Note, Submitter, NoteDate, ContactID)
VALUES ('Barb us our Rep', 'DrM', '10/13/2004', '1')
I am not able to seee the error. Are there other problems that could give me this error that are not relative to the SQL Command. If I have made an error please help me to see it.
View Replies
View Related
I keep getting the same error... Syntax error in INSERT INTO statement. (line 14) Code:
View Replies
View Related
Any idea's what's wrong with this statement?
sql_insert = "insert into Specs (ItemID, Title, Value) values ('" & _
ItemID & "', '" & Title & "', '" & Valuesa & "')"
It returns.
Syntax Error in INSERT INTO statement.
Does this have something to do with using "Value" as the field name?
View Replies
View Related
Usually on our server we see or can view source to see where in the INSERT statement something got messed up. I have debugging on but when I run a test, I get the following error:
Syntax error in INSERT INTO statement.
Line 57
It is a very long INSERT statement but for the life of me, I can not see where it is wrong. What I am wondering, if all I am seeing is "Syntax error in INSERT INTO statement. " does this mean it is at the beginning of the statement since i do no see any of the actual data on the error page?
View Replies
View Related
What's the correct syntax here:
(given the recordset myRS with x records
do until myRS.EOF
txtvar & myRS("serial_number") = myRS("serial_name")
myRS.movenext
loop
..asp will not build the dynamic variables
txtvar1 = "Some name"
txtvar2 = "Any name"
txtvar3 = "Your name"
.....
Based on the serial_number in the current recordset.How can I builde the dynamic variables, and give them a value from my recordset?
View Replies
View Related
