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) ....
View Replies
ADVERTISEMENT
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
has anyone here had problems trying to retrieve form elements from a dreamweaver insert form? Code:
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 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
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'm trying to display the username by requesting the cookie from the login page and I'm getting a page that only display "Hello" and not the username. Code:
View Replies
View Related
Request.Form and Request.BinaryRead cannot be called after each other as it causes errors.
I need the BinaryRead and I also need to access other form values, but I cannot call them after one another. What do I do?
View Replies
View Related
I am trying to figure out a way to insert all the records from a dynamic table - repeat region into one table as individual records. On the 1st page users select which items they want from a large list. When they click submit it passes the values ( IDs ) with a URL par to the next form. This form has a recordset that uses the URL par from the last page and creates a new dynamic table - repeat regon with all the records they chose. I need to do this so I can then add up rates for those selected items. I need to find a way to the add all those selected records now into one table. Also I need to have them insert each record at a time. So if 4 records are in the recordset and repeat region, I need to have it add 4 records into the table. Hope that makes since. Im a bit lost on this one.
View Replies
View Related
Is it possible when you insert a record in a database to only insert max 5 records. Can i make it delete the oldest one when i want to insert record #6 and so on?
View Replies
View Related
Anyone know if it is possible to update/insert a database record into a dynamically specified field.
The code I have here holds data in an asp session, ownerId, storeid and product type.
I can insert a record into the Productcat table, fields OwnerId and surfboards, no problem.
But what I would like is to insert the ownerid then insert poduct type into the field sepcified in the session variable (session("prodtype")) and/or strprodtpye
For Example
Insert OwnerId + product type into productcat into fileds ownerId and field labled ''strprodtype'' (variable, surfboard, wetsuit, boots, etc)
SQLstatement = "INSERT INTO Productcat (Ownerid,'"&strprodtype&"') "
I have tried using different methods, but the closest I got was IIS error msg ='field not found ("Surfboards", "wetsuits", "boots", etc)' Code:
View Replies
View Related
I'm trying to set up a form whereby users can select a variety of different subject mailing lists they'd like to be added to.
Each subject is in a different table so I want the FROM part of my SQL statement to loop through the values selected from the list box which I've loaded into an array.
But I'm getting a Type mismatch error.Code:
Dim strSQL
Dim subjects
Dim subjArray
Dim iLoop
subjects = Request.Form("subjects")
subjArray = split(subjects)
strSQL = "SELECT firstName, lastName, address1, address2, city, state, pcode, country, email FROM"
For iLoop = LBound(subjArray) to UBound(subjArray)
subjArray(iLoop)
View Replies
View Related
I am workin on a project at home,asp vbscript website, n im having problems with inserting records into my database .. I am using a dsn-less ADODB connection, but it seems that some kind of security is preventing me from writing in the db.. i can access n retrieve, but NOT WRITE.. ive tried disabling every type of security, still doesnt work..
View Replies
View Related
I have a recordset that contains multiple records of product a user is purchasing. For clarity, I converted the recordset fields to variables. I need to take that entire recordset and insert it into another table on a remote server. The below code only inserts 1 record. How do I change the code to get all records inserted?
<%
Dim DataConn2
Set DataConn2 = Server.CreateObject("ADODB.Connection")
DataConn2.Open MM_kasKSS_STRING
SQL = "INSERT INTO wsOrderDetails (OrderID, OrderNo, Description, Qty,
PriceEach, Priceline) "
SQL = SQL & "Values ('" & iod_OrderID & "', '" & iod_OrderNo & "', '" &
iod_Description & "', " & iod_Qty & ", " & iod_PriceEach & ", " &
iod_Priceline & ")"
DataConn2.Execute(SQL)
%>
View Replies
View Related
I get this following error while inserting recoed in ms-acces db :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/mis/add_iteminfo.asp, line 35
This thing is making me go crazy as i'm running windows platform & running the app on localhost. The have several times but the db isn't read-only, not even in the iis. Don't know what to do .
View Replies
View Related
i have learned database connectivity. I am facing some problems in inserting records to database using SQL. Please tell me the way to insert records using SQL. I received error about wrong arguments on following line.
Rs.Open Query, DBConn, adOpenStatic, adLockOptimistic
where Rs is the RecordSet object, Query contains they SQL String, and DBConn is the Connection to my Microsoft Access database. I easily connected to the database and retrieved records using following command:
Rs.Open Query, DBConn, 3
View Replies
View Related
What is the most efficient way of inserting multiple records into a database ? At the moment, I'm grabbing data and inserting each record with a loop. The only thing is on each loop I'm opening a connection to the db (SQL Server), inserting a record, then closing it.
Is there a way of inserting all the data with either one command or by keeping the connection and looping the command instead. The situation is the user entering email addresses into a textarea, one per line, then process each of those emails as a record.
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
How to do i send database information to an html email using ASP?
View Replies
View Related
how to insert multiple records in database?? i have this problem like i have this one form and there are three fields like the (quantity,unit,item name)..the item that will be inputted will vary, depending on the number of item to be inputted..
Ex.
enter the number of item: 3
qty unit item_name
1. 2 pcs pencil
2. 2 pcs glue stick
3. 2 pcs clip
(SUMBIT)
what should i do in order that these items will be inserted in just one insert statement?
View Replies
View Related
I need help to solve this situation....
House 1 (1 photo)
House 2 (4 photos)
Example:
Table1
idHouse....#auto
House.......text
Addr..........Memo
Table2
idPhoto.....#auto
idHouse....num
Photo........text
I need insert multiple records into a single field of the Table2 and
insert the idHouse too. How do I do this?
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
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
View Replies
View Related
I need to insert atleast 10000 records at a time but if the user stops the process i need to rollback the transaction.
View Replies
View Related
when the asp page is Request("txtName").i can use "testpage.aspx?txtName=User1" to post the value.but when i use Request.Form("txtName").i cannot use that method,what can i do to solve that problem.(as i cannot modifty the request.form syntax but i need to post data to that web page, is there any method so that i can pass that parameter?)
View Replies
View Related
can anyone teach me how to use request.form? i normally search through the internet is normally request from the same page. what if i request from different page?
how can i write?
the first top page izzit i write execno = request.form("execno") ???
View Replies
View Related
Select Case request.form("posted")
case 1
case 2
case 3
case else
end select
Here is my case statment each case has a form, which holds a varible named posted. There is a problem however, once the refresh button is pressed it &*#$# up. I need to set request.form("posted") to nothing and it would be good to know how to set all of request.form.
View Replies
View Related
.From = Request.Form("txtAMITENTE_1")
The problem is, I always do not know what the name of the field can be. But I know that it ends with a "_1"
Is there anyway I can do it..Like a right function to check the last letter and select the fild name. So even if it is "sun_1" or "moon_1" I can use it..
View Replies
View Related
I want to pass a Request.Form variable to an ASP form, through the url
for example lets say i have a form with a textfiled called "txtName" if i
click the submit button for example the asp page reads the content of this
txtName as Request.Form("txtName")
I want to achieve that the asp form is accessed through a URL where i can
pass the value of txtName without going to the page of the form and clicking
the submit button
View Replies
View Related
If the value in the field in the form is like this:
<%Response.Write recordset("InstructName")%>">
When you Request.Form will it not pass the value?
View Replies
View Related
Is there a way to name a text file with Request.Form or naming it after a variable?
I have a form with a field "name". What I would like to do is create a .txt-file called "x.txt" where x is the value typed in the box.Something like this probably really stupid attempt.
Code:
If Obj.FileExists(Server.MapPath("Request.Form('name').txt") = False Then
View Replies
View Related