Microsoft JET Database Engine error '80040e07'
I always get confused n get this problem. How could I solved it??
This is the error I got :
UPDATE [General] SET [TopicOrder] ='', [ForumTitle] ='Performance Parts', [ForumDesc] ='Buy, Sell or Trading section', [TopicHeader] ='no', [NumTopics] ='', [NumPosts] ='', [PassWord] ='PARTS' WHERE [TopicID] ='7'
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/revolnip/Discussion/Forum_Edit.asp, line 58
______________________________________
My [TopicOrder], [NumTopics] & [NumPosts] is Number datatype. Why it dun seems to write out??
Below is my script. Can someone tell me where i got it wrong?
if Request("update") = "true" then
dim strSQL, TopicHeader
If Request("TopicHeader") = "true" then
TopicHeader = true
ELSE TopicHeader = false
strSQL = "UPDATE [General] SET "
strSQL = strSQL & " [TopicOrder] ='" & Request("TopicOrder") &"',"
strSQL = strSQL & " [ForumTitle] ='" & Request("ForumTitle") & "',"
strSQL = strSQL & " [ForumDesc] ='" & Request("ForumDesc") & "',"
strSQL = strSQL & " [TopicHeader] ='" & Request("TopicHeader") & "',"
strSQL = strSQL & " [NumTopics] ='" & Request("NumTopics")& "',"
strSQL = strSQL & " [NumPosts] ='" & Request("NumPosts")& "',"
strSQL = strSQL & " [PassWord] ='" & Request("PassWord")& "' "
strSQL = strSQL & " WHERE [TopicID] ='" & Request("TopicID")& "' "
Response.Write strSQL
Conn.Execute (strSQL)
end if
end if
|
