ASP :: Insert Form

Insert Form Fields
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.

Multi Form Insert
How would you go about inserting data from two forms into one record? using access/javascript

Using A Form To Insert Into A Table
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 ...

SQL Insert Syntax W/ Form
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!

Insert <br /> From Textarea Form Submission
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?

Dreamweaver Insert And Request.form
has anyone here had problems trying to retrieve form elements from a dreamweaver insert form? Code:

Pass Hidden Form Field Value To Another Form Field To Insert In Db
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:

Check Entered Form Values And Insert Them To Db
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?

ASP Application Form To Insert Records Into SQL Database
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.

Insert A Javascript Value In To Hiddne Form Field
how can I insert a javascript value in to hiddne form field? I have to use this vlaue in a asp page.

Can't Insert Records From Page With Request.form
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) ....

INSERT Multiple Records From Checkbox Form With Unique Ids
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:

Trying To Insert Multiple Records Into Database When Form Is Submitted
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:

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.

Build DB Insert Statement Dynamically - Loop Form Elements
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?

Submit Form Elements To Insert Multiple Records Into A Database
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:

How To Retrieve Form Values, When Form Elements' Names Are (almost) Unknown?
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.

Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".

I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:

File Form Type And Request.Form Problem
I have a form as follows:

<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">

<input type="file" name="FILE1" size="30">

<input type="text" name="def" value="0" size="10">

etc.....

and can't get my asp to recognize data in other form input boxes using Request.Form

Any thoughts?

Javascript Form Validation - Form Action To Another Page
In my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:

<form name="form" method="post" action="RegDetails.asp">

This works fine, the form details are collected by RegDetails.asp

I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:

http://javascript.internet.com/forms/val-pass.html

It works fine in a new blank page with the form action:

<form name=myForm onSubmit="return validatePwd()">

The final stage in this javascript demo form displays an alert box:

else {
alert('Nice job.');
return true;

When I change the first line of my original form to:

<form name=myForm onSubmit="return validatePwd()">

how do I get my original action of - action="RegDetails.asp" instead of this alert box?

How To Access Variables (form Text Box Values) On Same Form?
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.

The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:

Insert In DB
I have a form which the user fills and submits.i have insert statement there.
When i submit the form to itself ,the values get submitted and inserted in DB easily.

<form method="post" action="Infoviewagentver212.asp" name="form">

Now when i want the user to hit submit and go to other page i change the above to:
<form method="post" action="newpage.asp" name="form">

but here what happens is my values are not getting inserted in the DB??
How do i do this?

INSERT INTO
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:
Code:

INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')

Insert Into
I am very new at this and ding this in context of a course. I am getting an error stating
Error Type:

Microsoft VBScript compilation (0x800A03EE)
Expected ')'

Can you please look at this and tell me where I went wrong ?

Code:

Insert Into A Db...
Our graphic designer has just finished redeveloping our website. On the
site, we use SSL to secure the area where a user enters their personal
information to order items from us. (we do not do many transactions - maybe
1 per day...) We are a log home mfg company so they would only order plan
books, maybe a video etc...

When the user clicks "Submit Order", we want to encrypt each data item
(because of new legislation governing customer personal info etc...) and
write a record to an access db. From here it will be imported into our
Customer DB leads database...

I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in
many ways...

Does someone have a good ASP script for encrypting data? And, if so, is it
fairly strong encryption?

Also, is there any trick to writing an "insert" SQL script in ASP or is it
exactly the same as I would do in VB or Access? Maybe someone has an
"insert" script handy they could pass along including the command to
actually execute it?

Insert In SQL ASP
i have got a data base which contain more than one tables
one for student one for teacher and one for books

i make a fourm to read the input from the user Code:

Insert All At Once
Code:
mySQL="INSERT INTO products (sku, youtube, description, details) VALUES ('" &pSku& "','" &pYoutube& "','" &pDescription& "','" & pDetails& "')"
call updateDatabase(mySQL, rstemp, "insert1")

that's shortly the way i'm inserting new records.
using mysql and asp functions.

The prob is that inserting only one record every time.
if i got data for 3 records how can i make it at once
to add 3 new records in some given order into the db

ADO Insert
What is the best way to see if a record has inserted correctly into the datase in ASP?
Also, how to tell the user what the error is.
I am inserting like this with the ADO command object:
Dim sInsert, objCmd
set objCmd = Server.CreateObject("ADODB.Command")
sInsert = "sp_ADS_Insert_Driver_General_Data "
on error resume next
With objCmd
.ActiveConnection = oConnEnergy
.CommandText = sInsert
.CommandType = adCmdStoredProc
.Execute , , adExecuteNoRecords

DB Insert
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.

Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.

INSERT INTO
I have a database in which I have to on a daily basis enter the information for that day.I would like to update this on a bi-hourly basis to prevent any possible data loss.

Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.

SQL Insert Into
When the following code runs it produces no errors but doesn't give proper results:

sql = "INSERT INTO TableName (Line1, Line2, Line3, Line4) VALUES ('" & lines(0) & "', '" & lines(1) & "', '" & lines(2) & "', '" & lines(3) & "')"
Response.Write(sql)
SET RS = Conn.Execute(sql)

lines() contains nothing but strings and is never empty.

The Response.Write(sql) shows the proper values going into the proper locations.

However, only Lines(0) actually populates the table. Line2, Line3, and Line4 never receive any values despite the SQL showing the proper syntax.

Insert
i have this insert statement that is giving me trouble, the problem is with expiration_date field the error i'm getting is:

Syntax error in date in query expression '##'.Code:

SQL_Insert = "Insert INTO TableName(ColumnX, ColumnY, ColumnZ, ColumnZZ, ColumnXX, ColunmYY, Expiration_Date) values ('" & _
ColumnX& "', '" & ColumnY & "', '" & ColumnZ & "', '" & ColumnZZ & "', '" & ColumnXX& "', '" & ColunmYY & "', #" & Expiration_Date & "#)"

SQL Insert
I'm using a list in a form in which users can select up to three items. When they submit the form, they are of course being inserted into one field as comma delimited. I can split the data to display, but I was wondering if that data could be inserted to the table as its own record. So, instead of being inserted as one record with three comma delimited choices, I would like three records with one choice in each. Here is a sample of my code:

conn.execute=("INSERT INTO Submitted_Information (PreferredGrade, PreferredSubject, Sponsor) Values (" &_

"'" & PreferredGrade + "', " &_
"'" & PreferredSubject + "', " &_
"'" & Sponsor + "')" )
conn.close
%>

Preferred Grade and Preferred subject can have up to three selections each.

Odd Insert Into MS SQL
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works?

I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.

Insert Into
how do I insert file.filename into the access database when i upload a file it saves to uploads folder see code that doesn't work below

file.SaveAs("/johnny/Uploads/" insert into pics1 set rspic = '" & file.filename& "' where author = '" & session("variable") & "'")

SQL INSERT
I have some data I want to put into the database. My question is twofold. What is the best/most efficient way to do this? I've heard of the Execute method, but I can't seem to get it to work. Why won't it let me close the recordset object when I insert a record?

Code:

[vbs]
sqlTxt = "INSERT INTO tablename VALUES ('ShopperID', '" & Date &"', '"& Cust_Name &"', '"& Cust_Password &"')"

set rs = server.CreateObject("adodb.recordset")
rs.Open sqlTxt,conn
[/vbs]

Whenever I use rs.Close, it tells me that the operation cant continue while the recordset is closed.

SQL Insert
I am getting syntax errors when trying to insert my form. This is what I am doing:

INSERTSQL="INSERT INTO EPR_PTS_ISSUE_TRACKING (Issue_Type, Request, Issue_Title, Issue_Desc, Application, Status, Created_By, Date_Entered) "
INSERTSQL=INSERTSQL & "VALUES ("
INSERTSQL=INSERTSQL & "'" & Issue_Type & "', "
INSERTSQL=INSERTSQL & "'" & RequestNum & "', "
INSERTSQL=INSERTSQL & "'" & Issue_Title & "', "
INSERTSQL=INSERTSQL & "'" & Issue_Desc & "', "
INSERTSQL=INSERTSQL & "'" & txtApplication & "', "
INSERTSQL=INSERTSQL & "1, " - The error is between this line
INSERTSQL=INSERTSQL & "'" & Created_By & "', " - and this line.
INSERTSQL=INSERTSQL & "sysdate,"') "
set rs=cn.execute(INSERTSQL)

Get Last Insert?
How can i get the last inserted record in an ASP ACCESS combination? Code:

Merging Upload Form And Email Form
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:

ASP Repeating Form Fields In An Email Form
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.

Sending Email With Values Form A Form
<%@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....

Submit Form Data And Refresh Form
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.

My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?

Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.

Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?

Loop Form - Extract Display 'value' As Well As Form Value?
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?

Request.Form Doesn't Return Form Data
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:

Insert Problem
I have a 2 asp pages for a registration form. The first one is where the user types the data, and the second one has a form that requests the data from the 1st one and then sends it to the database. Both are sending the data correctly (I've seen it on the error page) but it's not feeding the DB.

Insert Problem
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15

What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?

Insert An Image
I have a website I am working on that I did not create. It is ASP and SQL based. There is a content management system created using ASP and saving in the SQL server database. A user can enter a news article into a big text box/area, and choose to add an image. The text and image are stored in the database via ASP and pulled out to the website via ASP.

The image shows up in the website to the top left of the article. I need to make it so the user can enter an image where their cursor is in the paragraph (like a word document) and have it also show up there on the website. Any ideas?

Insert ASP Code In JS
I have a problem. I have ASP code and Javascript code. Now, I want to access ASP code inside javascript code. Here is the ASP code:

INSERT INTO Problem
This is on my HTML page

<td align=center>
<textarea cols="85" rows="7" name=""Problem"></textarea>
</td>

User" enters information into this box.

If they use either a quote or double quote, but SQL statement bombs. Is
there a way quick way to fix this beforehand?
Conn.execute ("INSERT INTO PROBLEMS (Problem) VALUES ('" & Problem & "')")

Insert Form

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:

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: