Dennis
|
| Posted: 08/12/2003, 1:39 AM |
|
Well, I can't seem to use my login form anymore and I cant figure out how to fix it. It was generated with a new stand-alone application project with login authentication. I now have three sub sites under the original one and during the development cycle I have broken the link and cant locate the fix spot..
can anyone figure out the solution?
This is what I get when I login with valid account info:
------------------------------------
Database error: Invalid SQL: SELECT FROM employees WHERE ='test' AND ='passtest'
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM employees WHERE ='test' AND ='passtest'' at line 1)
Session halted.
------------------------------------
From the error message, it appears that my login form is not passing the parameters? I can only find the parameters for the login record sql statement.
Thanks,
Dennis
|
|
|
 |
Rene
|
| Posted: 08/12/2003, 3:25 AM |
|
i think the error is in your SQL statement .. in the where clause .. it should be
Where test = 'test' and passtest = 'passtest'
so that there is a comparison
Hope this helps....
|
|
|
|
|
