| Author |
 Topic  |
|
|
SeasonedMKTR
Junior Member
United States
107 Posts |
 Posted - 18 October 2008 : 14:05:30
|
Hey folks,
Funny thing here, everytime I go to program something simple on my forum something happens which makes a 5 minute task a 5 hour one. I am still laughing because this never fails(being sarcastic of course). Anyone here mind giving me a hand please? Here is what happened. I went to write a new forum topic and that went well but then I went to write a description in the text of the forum and submit it and whalla, this is the error it gives me now.
===========================================================
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-max-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '' , 30 , '' , 365 , 0, 0, 1 , 0, 1)' at line 1
/forum/post_info.asp, line 1205
===========================================================
Anyone know what I did now? Thanks, and please stay golden... :)
Lance< |
CLICK>> CLICK>> CLICK>> |
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 18 October 2008 : 15:19:56
|
can you do a
Response.Write("Query:<hr/>" & srtSQL & "<hr/>")
Response.Flush()
Response.End() before the line 1205 in post_info.asp and place the complete Query?< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
Edited by - balexandre on 18 October 2008 15:22:14 |
 |
|
|
SeasonedMKTR
Junior Member
United States
107 Posts |
Posted - 18 October 2008 : 16:12:57
|
| Not quite sure how to do that. Is that within my post_info.asp file? This was just the code tha came up when I tried to post the description of the forum topic.< |
CLICK>> CLICK>> CLICK>> |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 18 October 2008 : 17:31:51
|
Right before this line 1205 post_info
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
It will show the whole string. You probably left out a comma or a quote in the values. Should be right in front of '',30< |
_-/Cripto9t\-_ |
|
|
|
SeasonedMKTR
Junior Member
United States
107 Posts |
Posted - 18 October 2008 : 17:59:07
|
Is this it...
txtMessage = ChkString(Request.Form("Message"),"message")
Err_Msg = ""
if txtMessage = " " then
Err_Msg = Err_Msg & "<li>You Must Enter a Message for your Reply</li>"
end if
if Err_Msg = "" then
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strActivePrefix & "REPLY "
strSql = strSql & " SET R_MESSAGE = '" & txtMessage & "'"
if Request.Form("sig") = "yes" and strDSignatures = "1" then
strSql = strSql & ", R_SIG = 1"
else
strSql = strSql & ", R_SIG = 0"
end if
if mLev < 4 and strEditedByDate = "1" then
strSql = strSql & ", R_LAST_EDIT = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", R_LAST_EDITBY = " & MemberID
end if
strSql = strSql & " WHERE REPLY_ID=" & Reply_ID
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords< |
CLICK>> CLICK>> CLICK>> |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 18 October 2008 : 18:15:41
|
quote:
Right before this line 1205 post_info
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
it is in perfect English SeasonedMKTR
just add those 3 lines of code that I mention above (before) the line that executes the code.
and please run the forum again and paste the result.< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
SeasonedMKTR
Junior Member
United States
107 Posts |
Posted - 18 October 2008 : 18:51:40
|
It works! You are ACE! Thanks for the help you two.
SeasonedMktr :)< |
CLICK>> CLICK>> CLICK>> |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 19 October 2008 : 01:29:02
|
| now you lost me ...< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 22 October 2008 : 10:05:25
|
quote:
Originally posted by balexandre
now you lost me ...
Sorry this made me laugh. I know what you are saying here balexandre just funny how it worked out. lol< |
|
|
|
SeasonedMKTR
Junior Member
United States
107 Posts |
Posted - 24 October 2008 : 22:31:46
|
quote:
Originally posted by balexandre
now you lost me ...
Final post to this thread, once again just to clarify, it ALL worked out so thanks. Yes I got it fixed. The simplest way was to restore the original files as there were no mod add-ons yet to my forum. Had there been I would have continued with your suggestions. Anything I can do for you please just ask.< |
CLICK>> CLICK>> CLICK>> |
Edited by - SeasonedMKTR on 24 October 2008 22:34:30 |
|
|
| |
Topic |
|
Topic Locked
