Hi,
I create an event template from ASPRunner event template without changing any variables or settings but I encountered this Error number -2147217900 when I clicked on the Subjects heading under view_list.asp
Error number
-2147217900
Error description
[Microsoft][ODBC Microsoft Access Driver] Syntax error in WHERE clause.
URL
/yyssevent/events_view.asp
SQL query
select [EventID], [Category], [Subject], [Description], [FromDate], [ToDate], [FromTime], [ToTime], [Location], [Price], [Map], [Note], [Image], month(fromdate) & ' ' & year(fromdate) as monthname From [events] where [EventID]=1
Solution
Please help~ Many Thanks in advance