|
pokemon
Junior Member
151 Posts |
 Posted - 11 June 2004 : 14:00:15
|
After i'm importing from access 2000 to MS SQL 2000. Everything is running fine, but when i post new topic or reply topic. I"m getting this error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.
/student/phorum/database_backup/post_info.asp, line 1171
'## Forum_SQL - Update Last Post and count
strSql = "UPDATE " & strActivePrefix & "TOPICS "
strSql = strSql & " SET T_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", T_REPLIES = T_REPLIES + 1 "
strSql = strSql & ", T_LAST_POST_AUTHOR = " & rs("MEMBER_ID")
strSql = strSql & ", T_LAST_POST_REPLY_ID = " & NewReplyID
if Request.Form("lock") = 1 and ForumChkSkipAllowed = 1 then
strSql = strSql & ", T_STATUS = 0 "
end if
strSql = strSql & " WHERE TOPIC_ID = " & Topic_ID
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
would anyone knows how to fix this problem?
Also, Would you please explain what is the different between. Import in DTS SQL 2000 and upsizing tool. I don't know if I dit anything wrong when importing. Thanks for any help
|
Edited by - ruirib on 11 June 2004 17:19:16 |
|
Topic Locked
