Search results for query: *

lovejaeeun, I tried that and it gives me the returned page but it doesn't update the database or display the sql statement. I ran the sql query in access and it works but when i out in the name value (booth) it brings up an input box asking me to enter a perameter value with the value in the...

lovejaeeun, I tried that and it is bringing up the the following error: Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /dbstudents/lcbooth/writeable/addtest.asp, line 39 I've checked the permissions on the database/folder and they're full...

lovejaeeun, I have taken your advice and started a new database (which I can connect to and retrieve data) with 1 table. I then re-wrote the code (as below) and ran it as usual but it still comes up with the same error: Error Type: Microsoft VBScript compilation (0x800A03EE) Expected ')'...

Hi everyone, I've been playing around with this again to see if I can get it working but it keeps returning the following error: Error Type: Microsoft VBScript compilation (0x800A03EE) Expected ')' lcbooth/writeable/addnew.asp, line 44, column 135 Line 44 is my sql statement (I've attached...

Tony, I looked at this and have moved the file and database into a different folder (think there could have been an issue with thr server permissions) but am now getting the following error: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required...

Hi, Can you let me know how you checked the inetpub folder? I'm having trouble adding a new record and could do with any suggestions!! Lucy

That gives me this error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /dbstudents/lcbooth/FinalProject/Deliverable/addnew.asp, line 47 Line 47 of the code is: oConn.Execute sSQL

Also, I changed the requests to request.form too. This is right isn't it?

We're a bit closer I think!! This returns the page and puts all the values I entered in the address bar at the top but doesn't show the message to say it has added the record to the database (it does show the link back though) and it doesn't add the data in either!! Thanks, Lucy.

Tony, I tried that and still the same error message!! Is there any other way of writing an SQL statement like this? i.e. rather than all field names then all requested field names? Maybe it would be better to try and start again with the SQL statement!!

Cheers!! I got it working. Thanks for the suggestion Lucy.

Tony, I have put the quote back onto the fields and have checked the database. There is no security on the database and everything is set to full access. I am also able to update records whilst in the database. I'm runnig out of ideas!! Lucy

Hi, I've tried that and it's STILL returning the same error!! If these are referred to as Int do they need to be changed anywhere else? They are set as text in the DB and text in the form (<input type="text" name="CategoryNo" >). Could this be the problem? Sorry to keep bugging you!! Lucy

Tony, I have taken the single quotes off the fields which are numbers but it is still returning the same error Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. /dbstudents/lcbooth/FinalProject/Deliverable/addnew.asp, line 31 The SQL statement now...

Hi Tony, I tried that (see code below) but it returns the error: Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. /dbstudents/lcbooth/FinalProject/Deliverable/addnew.asp, line 31 This is how I've done it: If Request("submit") = "submit" Then...

Hi everyone. Below is the code I've got so far. It executes the asp page and retuns a message saying the data has been added to the database but the database (Access) hasn't actually been updated. Form user fills in: <form method="GET" action="addnew.asp"> Objective ID:<input type="text"...

Hi all, I've got the following (asp) code for a search function but it doesn't seem to be linking to the database (Access). I've tested it wiht names that definately exist within the database but it's not retuning any records. This is the form the user has to fill out: <Form method=post...

I think it was reference wrong! Thanks again. Lx

I've done it!! The problem was with the SQL statement not line 12 as the error message was saying. Thanks anyway. Lx

I don't really have much code to go off so far but I've been told I need an inc page which links to an asp page. Is this right? What's the reason for this? Cheers, Lx