hi all
I'm new to this forum & software
I'm trying to display details of whichever field i select.
Now this software managed to do wonders in all setup but i'm stuck at a stage where its showing this error.
PHP error happened
Technical information
Error type 2
Error description odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect
URL localhost/demo/Index_view.php?editid1=14%20MOWBRAY%20ROAD%20&editid2=ACC%20%26%20C%2FC&editid3=2004%20TO%202006&editid4=9.0
Error file C:\xampp\htdocs\demo\include\dbconnection.php
Error line 25
SQL query SELECT DESCRIPTION, [YEAR], BOX, CLIENT FROM [Index] where CLIENT='14 MOWBRAY ROAD ' and DESCRIPTION='ACC & C/C' and [YEAR]='2004 TO 2006' and BOX='9.0'
Solution This is a general error. It occurs when there is an error in event code or in SQL.
I don;t have any technical knowledge. Can anyone help me to connect this. I'm using Access 2003 mdb file.
I have selected ODBC system dsn (this sftware doesnot allow me to create a dsn within the software , so i had to create one manually.) And I'm using XAMPP for web server.
Thank you.