Hi
I am new to this forum. Can anyone help with the following error message. I am running a software package called easyGen, which creates the PHP script for me. I have in the past used this software to create projects using ASP which have all worked fine. However I have been advised that I need to use PHP for this project as it will later on require the user to upload images.(That is what I have been told!)
My project at the momement consists of three pages Login, AdminStart and CustStart. The Login page uses a SetSession and basically if the session is equal to 1 it should go to AdminStart anything else goes to CustStart. I have set this up using True and False statements.
The error message I receive is:-
PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft JET Database Engine
Description: Data type mismatch in criteria expression.' in C:\Inetpub\wwwroot\adminstart.php:43 Stack trace: #0 C:\Inetpub\wwwroot\adminstart.php(43): com->Execute('SELECT [easyGen...') #1 {main} thrown in C:\Inetpub\wwwroot\adminstart.php on line 43
I think the statement that points to the problem is Data type mismatch in critera expression.
I have tried a test page which simply displays some text without setting sessions and that runs OK. The Database I am connecting to is Access.
Hope somebody can help.