|
Subject:
|
NEW: Microsoft JET Database Engine error'80040e14'
|
|
Posted By:
|
rishinicolai
|
Post Date:
|
12/10/2005 5:13:45 PM
|
Hi Guys... have been stuck on this problem for 4 days now.. just can't seem to solve it. And the problem seems to be an UPDATE statement. This is what the statement looks like and the error:
-------------------------------------------------------------------
Update tdPicUpload SET title='Party', desc='Shreelas 2nd birthday party.1', iso='800', sspeed='30', apature='4.5' WHERE picid ='2005123155615'
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/_photos/uploadlist.asp, line 29
-------------------------------------------------------------------
Here is the code:
-------------------------------------------------------------------
If Trim(Request.QueryString("action")) = "validate" Then
Call OpenDB()
strSQLInfo = "Update tdPicUpload SET title='"& Request.Form("ftitle")&"', desc='"&Request.Form("fdesc")&"', iso='"& Request.Form("fiso")&"', sspeed='"&Request.Form("fspeed")&"', apature='"&Request.Form("fapature")&"' WHERE picid ='"&Trim(Request.QueryString("picid"))&"'"
Response.Write(strSQLInfo)
Set objRS = objConn.Execute(strSQLInfo,,adCmdText)
Call CloseDB()
End If
-------------------------------------------------------------------
The error is being thrown at Set objRS = objConn.Execute(strSQLInfo,,adCmdText), and I have completely no idea why the problem is here, and why it wont go away. If anyone can find the issue, it would be really appreciated if you could email me at rishinicolai@switonline.com. Thankyou everyone in advance.
|
|
Reply By:
|
Imar
|
Reply Date:
|
12/11/2005 9:50:34 AM
|
What are the datatypes of the columns you're updating? Because of the single quotes, you treat them all as text, but maybe some of them are numeric?
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Rob D - Clubbed To Death (kurayamino mix) by The Matrix (Track 4 from the album: The Matrix - Movie Soundtrack) What's This?
|
|
Reply By:
|
rishinicolai
|
Reply Date:
|
12/12/2005 6:09:58 AM
|
Hi Imar,
I fixed the problems earlier today. The only thing is I am not sure why it works now! No, all the datatypes are text, and I was sure that that wasn't the problem. For some reason I suspect that one of the column names is a reserved keyword because it worked when I renamed them all (just added a 's' in front of them all). That is a rather unusual solution becuase I still don't know where exactly the problem lies.
Thanks.
|
|
Reply By:
|
Imar
|
Reply Date:
|
12/12/2005 6:17:33 AM
|
It's probably the DESC column. It's a reserved word to indicate the sort order in a SELECT statement.
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
Reply By:
|
rishinicolai
|
Reply Date:
|
12/13/2005 4:58:09 AM
|
Hi Imar,
Spot on... wow.. i so didn't pick that. but yeah, thanks for helping out.
Cheers.
|
