Thursday, April 2, 2009

What's wrong here?

Guys, this is driving me mad...

I have two models that are connected with the $hasMany and $belongsTo
variables:

class Invoice extends AppModel {
var $name = 'Invoice';
var $hasMany = array('InvoiceProduct');
}

and

class InvoiceProduct extends AppModel {
var $name = 'InvoiceProduct';
var $belongsTo = array('Invoice');

function myFind() {
return $this->find('all');
}
}

OK. Now in the InvoicesController I have this call:

$things = $this->Invoice->InvoiceProduct->myFind();

Of cource, the myFind() is implemented in the InvoiceProduct model,
for a simple examle:

function myFind() {
return $this->find('all');
}

And it doesn't work. I get this message:

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 'myFind' at line 1

When I click on the Warning and then on the context I get this:

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


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

No comments: