Hello All,
I have a controller(users_controller) and in the login() function i
call a function called "validateUserLogin" from the User model like
this:

...
$user = $this->Users->validateUserLogin($this->data['User']) )
...

However, when i try to go to this page i get the following error:

Warning (512): SQL 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 'validateUserLogin' at line 1 [CORE/cake/libs/
model/datasources/dbo_source.php, line 512]

Code | Context

$sql    =       "validateUserLogin"
$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 'validateUserLogin' at line 1"
$out    =       null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-
align:left\"><b>SQL Error:</b> {$this->error}</span>",
E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/
dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/
dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/
dbo_source.php, line 338
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php,
line 299
Model::call__() - CORE/cake/libs/model/model.php, line 397
Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 59
AppModel::validateUserLogin() - [internal], line ??
UsersController::login() - APP/controllers/users_controller.php, line
46
Object::dispatchMethod() - CORE/cake/libs/object.php, line 114
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 90

Query: validateUserLogin


Does anyone know how to fix this?  Also, why is a query being run for
this?

Thanks in advance!!


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to