Re: find() problem

Thank you for writing back. The error happens on every record. The error is near LEFT JOIN `table1` AS `NotMt` ON(`table2`.`` notmt =`NotMt`.`id`) No error near others ones like LEFT JOIN `table1` AS `Symp` ON (`table2`.`symp` =`Symp`.`id`) Table1 is the 2 records

Re: find() problem

THink I found the problem. A tab in a value in an array of arrays called $belongsto. Not sure, want to test more, but error messages gone. Thank you cricket and John. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this

Re: find() problem

function evFrmCreate($model, $fields, $currentId, $limit='50'){ //the only reason we have limit set is because the Upload Additional Information can have more // than 1 without being wrong. Where we need to se the problem with other forms $record = $this-$model-find('all', array(

Re: find() problem

You're not giving us any hint of what data you're passing in to your function. With recursive = -1 I don't believe you shouldn't be getting any LEFT JOINs automatically so I think you're passing in something strange. On Monday, June 17, 2013 3:14:31 PM UTC+3, first last wrote: function

find() problem

No experience with PHP so sorry for my ignorance. A find() in a CakePHP 1.3 program is making a query with a MySQL syntax error 1064. The part of the query causing the error looks like LEFT JOIN `table1` AS `t1` ON (`table2`.``col1=`t1`.`id`). Col1 is outside of the backquotes. It's a very

Re: find() problem

I have an idea but would rather see the code first. On Fri, Jun 14, 2013 at 2:45 PM, first last van...@gmail.com wrote: No experience with PHP so sorry for my ignorance. A find() in a CakePHP 1.3 program is making a query with a MySQL syntax error 1064. The part of the query causing the

Re: Function Find - problem

Thank you very much. On Aug 11, 8:25 pm, CobaltShark cobaltsharksoftw...@gmail.com wrote: It would be helpful if you posted the actual code of your find(), but it would appear that you are not forming your conditions array correctly. I haven't had any issues using LIKE, and maybe this link

Function Find - problem

i found some difficulties using function find(), / SELECT `Book`.`isbn`, `Book`.`title`, `Book`.`author_name` FROM `books` AS `Book` WHERE `Book`.`title` = 'LIKE 'A%' ORDER BY `Book`.`title` ASC // In this query, i can't retrieve data because the conditions pasted in this

Re: Function Find - problem

It would be helpful if you posted the actual code of your find(), but it would appear that you are not forming your conditions array correctly. I haven't had any issues using LIKE, and maybe this link will help : http://book.cakephp.org/view/74/Complex-Find-Conditions .Book.title LIKE = A% should

Re: Containable recursive find problem

Hi Wilson, thats how my query looks like: $checklist = $this-Checklist-find('first', array('conditions' = array('Checklist.id' = $id), 'contain' = array( 'Product'

Re: Containable recursive find problem

Hi Andreas, I'm trying to this same thing, but without success. Do you mind pasting your find logic here? On Jun 12, 9:20 am, Andreas Derksen andreasderk...@arcor.de wrote: Thanks, Works fine! Thought to complicated... :-) Containable behavior is really nice ;-) greets Andreas Martin

Containable recursive find problem

Hi, im currently developing a checklist application witch has the following Models and relations: Checklist belongsTo Product Checklist hasMany Check Product HABTM Module Module hasMany Subjects Subject belongsTo Module So, what i want to do now is to generate tables like this: Checklist

Re: Containable recursive find problem

You just go: 'contain' = array( 'Product' = array( 'conditions' = array('Product.id' = $productId), 'Module' = array( 'Subject' ) ), 'Check' ) That is: in contain you simply name the nearest associates and in each of those you name furhter associates to return. On Jun

Re: Containable recursive find problem

Thanks, Works fine! Thought to complicated... :-) Containable behavior is really nice ;-) greets Andreas Martin Westin schrieb: You just go: 'contain' = array( 'Product' = array( 'conditions' = array('Product.id' = $productId), 'Module' = array( 'Subject' ) ),

Re: find problem on the associated model

yes the executions table isn't included in the applications query. I will try your code but mine should work, shouldn't it ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group,

Re: find problem on the associated model

Hi wluigi, Set debug to 2 and you will almost certainly see that the execution table isn´t included in the Application query. As you are looking for a specific Execution, why not restructure your code to be of the form: $ExecutionData=$this-Application-Execution-findById($ExecutionId);

find problem on the associated model

I I'm trying to query all my applications with a condition on their associated executions (hasMany relationship). Adding this condition cause an SQL error: SQL Error in model Application: 1109: Unknown table 'Execution' in where clause But this seems to work when I query my executions with a

Re: find problem on the associated model

I'm assuming you do actually have a table called executions...right? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe

Re: find problem on the associated model

yes and an other applications --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL