Problems With Inserting Form Values In Database

I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.

I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is

.Fields ("fieldname") = Request.value ("name of text box")
.update

Any suggestions? If someones willing to help me out quick, I will post my code.

View Replies


ADVERTISEMENT

Pass Form Values To A Page After Inserting In Access

I'm using DWMX and Access DB.

i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).

this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..

View Replies View Related

Error Inserting Form Data Into Database

I am trying to insert data from a form into a database and i am getting the following error:

Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.

The code that i used can be seen below: Code:

View Replies View Related

Inserting Values

I m inserting value into sql table from excel. the problem lies that the fiield i.e description contains single qoutes as well as double qoutes. so it is creating probs while inserting value.

set rs2=db.Execute ("insert into entry(description)values('"& ExcelRS("Description")&"');")

I want to remove this quotes but this quotes should be there in sql table I don't know how to that.

View Replies View Related

Inserting 200 Values In Loop

I am reading about 200 records from dbf file in ASP code and inserting into a table. I fetch the records in a recordset and in the recordset loop I have to insert it into the SQL table.
How should I insert the values?
1) Should I use query in ASP page
2) Or call stored procedure (passing each record parameter) for inserting, 200 times in the loop

View Replies View Related

Inserting NULL Values

How do I tell my SQL Server database to insert a NULL value for an empty string. Like if I set a value to null in ASP like this: x = null then it inserts as empty in to the database, how do I get it to insert a reall null value?

View Replies View Related

Inserting Values Into A Table

i have really only been exposed to getting data from aSQL database and displaying it.I want to include a page in my application (like a form in Access i guess)with various text boxes and drop-downs + tick boxes.Then i want to click a submit button that inserts the data (providing is valid) into a SQL Server table.

I have had a search in google but nothing seems to explain this in its most
basic terms (errorchecking and inserting).Could anyone give me an example of this or some background about this functionality.

View Replies View Related

Form Values With A File - Passing Values

I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:

To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:

View Replies View Related

Inserting From A Form...

I am currently trying to build a web app using ASP and MySQl DB. am reading books, surfing the web and reusing other peoples code to get what i want done done Code:

View Replies View Related

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:

View Replies View Related

Inserting Database

I had some Error when i write the update sqlp query


Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"


Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"

View Replies View Related

Inserting Into A Database

I have the folllowing page where a user can add a review to the website. So far the page works fine, but on the review rating section I know that the rating is between 0 - 5.

But its posible for a user to enter 1000 if they wished, which still means the page works but the answer is too high.

Also if they write text in the field it errors the page. How do i code this so that they can only enter a number between 0 and 5 and only a number and not text.

View Replies View Related

Inserting Into Database

I have a problem with inserting the results of which radio button was selected into a database. I have the code for the text fields down with no problems. I guess my question is how to populate the yes/no fields in the access database.

View Replies View Related

Inserting Text Box Into A Form

I'm trying to create a form that allows me to modify the contents of list. When the user clicks on the modify button, it takes them to a page which displays the quantity of items they purchase, and allows them to update that quantity. So the quantity is shown in a textbox, and the content of the text box is drawn from a rs("content").

But the page is crashing when I run it. I'm having trouble getting the response.write textbox line to work. Here's the code:

response.write "<td align=right><input type="text" name="quantity"
value=" & rs("qty") & "></td>"

This is the line that is causing the page to crash. Can't figure out why. Can someone give me some insight into this?

View Replies View Related

Inserting Data From Sub Form

how can i insert data from a sub form to the fields in the parent form. I am currently to do a search from at the parent form by poping out a new form. When i got the search result, i will need to click on the selected search result and populate into the parent form fields without any refreshing process as it might reset my form.

View Replies View Related

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:

View Replies View Related

Trouble Inserting A New Row Into Database

I am having trouble with someone else's code that worked when it was used last, but now it's not. I am new to ASP programming so I not too sure what's happening. Code:

View Replies View Related

Inserting Into Database Question

I have a table in access that contains to primary keys, they are both defined as numbers and I want to insert data into them in ASP:

I've tried a couple of statements as follows:

strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID , & strObjID

This tells me that an end of statement is expected:

and this:

strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID & "','" & strObjID & "')"

just doesn't work (page cannot be displayed)I'm sure it's a sytnax problem, something to do with integers? but I've searched loads of sites and can't find any that are using simliar code:

The values are pulled from a form as follows:

strLessonPlanID = cInt(request.Form("LPID"))
strObjID = cInt(request.Form("OBJID"))

View Replies View Related

Inserting Records Into Database

what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships.

On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?

View Replies View Related

Inserting Into An Access Database

I have a page setup where a user can login and add news to a site.

I had to write a small function to eliminate any apostrophies or dashes in the SQL insert statemnet to prevent any errors or confusion.

My question is, is there an easier way to do this? ....

View Replies View Related

Inserting Into Database Issue

I have simple form that sends data to an access database. The action is listed below. Am i missing a connector somewhere? Code:

View Replies View Related

Inserting Image Into Database

Anyone there can help suggest to me where i can find out more about Inserting image into a database.

View Replies View Related

Inserting Records In Database

I want to insert multiple records in my SQL database. I was wondering if this is the right way to do it: PHP Code:

 set insertRecords = Server.CreateObject("ADODB.Recordset")
insertRecords.ActiveConnection = mlConn

For i = 0 To 5
    insertRecords.Source = "INSERT INTO Info (Name, Age) VALUES (" & getName & ", 20)"
    insertRecords.Open()
Next 

View Replies View Related

Database Connections And Inserting

I am currently developing a coursework for uni that involves inserting some values into a Access database. I know how to do this, however I am trying to use different insert statements to insert data into different tables, however all the input field are on the same page. Code:

View Replies View Related

Inserting Simple Form To Access Db

I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.

I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.Has anyone out there done this before and can notice a step that im missing. Do i need to setup a recordset? because ive tried that as well and no success.

View Replies View Related

Inserting Data Into Bit Field In An Sql Database

I have an ASP variable called IRNvar:

If IRNvar(0,num) = "True" then
IRNvar(0,num) = 1
else
IRNvar(0,num) = 0
end if

In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement:

SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')"

Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.

View Replies View Related

Inserting Data Into A Database Table

i am trying to use the 'Insert into' sql query to insert data in an asp file but having some errors...this is the eror i got from the browser..

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/AddConfirm.asp, line 46, column 36
sql="INSERT INTO tblMembers VALUES("8"," & DateJoined & "",""& Title& "",""& LastName& "",""&FirstName& "",""& DOB & "",""& AddressUnit&"""

this is the code i have in my asp file....

Code:

View Replies View Related

Inserting Random Passwords Into Database

I have a ASP/vbscript program that generates random passwords. The problem is I need to insert those passwords into an Access database of 327 clients. I have the random password program generating the 327 passwords, but have had no luck inserting them. Code:

View Replies View Related

Inserting Value From List Box Into Database Field

My question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:

View Replies View Related

Inserting Messy Text Into Database?

I'm trying to put some text into the database using ADODB.Command object. Seems like a reasonable thing to do and I can do it. But in this instance my text is an HTML code which contains many quotes. But i have to save it as is into the database field.

I use:

INSERT INTO (f1, f2) VALUES (v1, v2) comand. But since my v2 contains some quotes in it, (many quotes), I get an error. (it works otherwise). Is there any way ?

View Replies View Related

Inserting Data Using A Form Into Two Access Tables

I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.

View Replies View Related

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....

View Replies View Related

How To Get Data From An Excel File And Inserting Them Into A Database Using Asp?

I would like to know if there are any tutorials out there or websites that can explain more about this? can this be done in asp?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved