This topic is locked

Error -2147217900

9/15/2006 4:48:43 PM
ASPRunnerPro General questions
C
chris author

I have sent you an email with my zipped files.
The text of the error screen is below.
Technical information

Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[EmployeeID] ='.

URL /Time_Card_Expenses_add.asp

SQL query select [TimeCardExpenseID], [TimeCardID], [ExpenseDate], [ProjectID], [ExpenseDescription], [ExpenseAmount], [ExpenseCodeID], [ClientID], [EmployeeID], [ReceiptAttachment] From [Time Card Expenses] where (1=0)

Additional info Event: RetVal = BeforeAdd(dict)
Thanks for any help.

Chris.

Sergey Kornilov admin 9/18/2006

Chris,
answered to your personal email, CCing here:
you have a custom BeforeAdd Event which breaks if EmployeeID field was left empty on the Add page. Probably you can make this field required.