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.
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!
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?
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 ?
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:
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?
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:
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.
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:
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?
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.
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.
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 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:
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:
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:
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
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon ( at end of SQL statement. Code:
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:
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"?
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:
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.
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?
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?
