This topic is locked

Error number -2147217900

1/15/2008 11:28:54 PM
ASPRunnerPro General questions
R
rayray author

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

Sergey Kornilov admin 1/17/2008

Post your application to Demo Account and send the URL to support@xlinesoft.com along with your order number.