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