Just uploaded 3.2 alpha 1 and started to configure it for a new site on local PWS without any email component. Don't know if the error also applies to previous versions. This is not critical
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/www1.istanbulmuzesi.org/forum/admin_config_email.asp, line 84
I did response.write to sqlstr:
UPDATE FORUM_CONFIG SET C_STREMAIL = , C_STRMAILMODE = 'None', C_STRMAILSERVER = 'your.mailserver.com', C_STRSENDER = 'your.email@yourserver.com', C_STRUNIQUEEMAIL = 1, C_STRLOGONFORMAIL = 1
It seems that the problem is with strEmail radio button value, which are disabled in this case.
If I change the following code around line #71
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "CONFIG "
strSql = strSql & " SET C_STREMAIL = " & Request.Form("strEmail") & ""
strSql = strSql & ", C_STRMAILMODE = '" & Request.Form("strMailMode") & "'"
....
to handle the case where strEmail is empty and take all the commas in sql to the end of the previous line:
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "CONFIG "
strSql = strSql & " SET "
if Request.Form("strEmail") <> "" then
strSql = strSql & " C_STREMAIL = " & Request.Form("strEmail") & ", "
end if
strSql = strSql & " C_STRMAILMODE = '" & Request.Form("strMailMode") & "', "
if Request.Form("strMailServer") <> "" then
strSql = strSql & " C_STRMAILSERVER = '" & Request.Form("strMailServer") & "', "
end if
if Request.Form("strSender") <> "" then
strSql = strSql & " C_STRSENDER = '" & Request.Form("strSender") & "', "
end if
strSql = strSql & " C_STRUNIQUEEMAIL = " & Request.Form("strUniqueEmail") & ", "
strSql = strSql & " C_STRLOGONFORMAIL = " & Request.Form("strLogonForMail") & ""
It works.
Bulent Ozden
History Foundation of Turkey
bozden@tarihvakfi.org.tr
Forum Locked
Topic Locked
Posted - 25 February 2001 : 16:55:51
