Dennis
|
| Posted: 08/13/2003, 6:26 PM |
|
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 variable name emp_login and emp_password? I can only find the
parameters for the login record sql statement. see after the where clause
='test' it should be emp_name='test'. parameters are not being stripped.
Thanks,
Dennis
|
|
|
 |
DonB
|
| Posted: 08/13/2003, 7:01 PM |
|
You do not have the 'security' configuration set up right - probably the
database connection or the table is wrong. This manifests itself in the SQL
losing the tablename and the column names being omitted from the query
performed during login.
Go to the Project, Settings, Security dialog and check them there.
--
DonB
http://www.gotodon.com/ccbth
"Dennis" <Dennis@automationfx.net> wrote in message
news:bheogj$j4d$1@news.codecharge.com...
> 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 variable name emp_login and emp_password? I can only find the
> parameters for the login record sql statement. see after the where clause
> ='test' it should be emp_name='test'. parameters are not being stripped.
>
> Thanks,
> Dennis
>
>
|
|
|
|
|
