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...
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
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!!
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 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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.