| Author |
 Topic  |
|
|
stwilson
Junior Member
USA
385 Posts |
 Posted - 05 April 2002 : 14:49:23
|
I just found an issue that I believe may have been on my site for some time now. I tried to change the name of one of the forums on my site and received the following error:
---------------------------------
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/forum/post_info.asp, line 1399
---------------------------------
Any idea what could be causing this? My most recent mods were: Subscriptions, Private Messages, and the Lock-In-Place MOD. Any help you can provide is greatly appreciated.
The code around line 1399 is as follows:
---------------------------------
if Err_Msg = "" then
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "CATEGORY "
strSql = strSql & " SET CAT_NAME = '" & ChkString(Request.Form("Subject"),"SQLString") & "'"
' DEM --> Start of Code added for moderation and subscription functionality
if strModeration <> 0 then
strSql = strSql & ", CAT_MODERATION = " & ChkString(Request.Form("Moderation"), "SQLString")
end if
if strSubscription <> 0 then
strSql = strSql & ", CAT_SUBSCRIPTION = " & ChkString(Request.Form("Subscription"), "SQLString")
end if
' DEM --> End of code added for moderation and subscription functionality
strSql = strSql & " WHERE CAT_ID = " & Cat_ID
my_Conn.Execute (strSql) <<<<<THIS IS LINE 1399
err_Msg= ""
if Err.description <> "" then
Go_Result "There was an error = " & Err.description, 0
Response.End
else
Go_Result "Updated OK", 1
end if
else
---------------------------------
Again, any help you can provide is appreciated.
STW.
Edited by - stwilson on 05 April 2002 14:52:35
Edited by - stwilson on 06 April 2002 00:04:06 |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 06 April 2002 : 00:06:21
|
OK. I must have labled this post wrong cause no one will even read it, let alone reply with assistance.  I have changed the title of the post to reflect the error I am receiving. I hope that helps! Has anyone ever seen this issue?
STW |
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 06 April 2002 : 00:43:45
|
put response.write strSql above that line and then try it. It should spit out an SQL string. Post that.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 30 April 2002 : 17:13:28
|
quote:
put response.write strSql above that line and then try it. It should spit out an SQL string. Post that.
OK, here is what I get now.
-----------------------------------------------
UPDATE FORUM_CATEGORY SET CAT_NAME = 'Notices - Updates & Feedback', CAT_MODERATION = WHERE CAT_ID = 4
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/forum/post_info.asp, line 1399
-----------------------------------------------
Thanks for your help!
STW.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 April 2002 : 19:16:23
|
There is a value missing at the part indicated. Why, I can't tell. Maybe someone familiarized with the mods...
quote:
OK, here is what I get now.
-----------------------------------------------
UPDATE FORUM_CATEGORY SET CAT_NAME = 'Notices - Updates & Feedback', CAT_MODERATION = there should be a value here WHERE CAT_ID = 4
Microsoft JET Database Engine error '80040e14'
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
