Re: Mysql GROUP in containable not working
eeks... nobody at all? :( On Wed, Sep 29, 2010 at 1:21 PM, Bryan Paddock bryanpadd...@gmail.comwrote: Hey all, Trying to use GROUP by in containable behaviour and it's not working as expected. Ratings model has fields: *Rating.id, Rating.restaurant_id, Rating.rating (1-5)* I have a query (which amongst other things) fetches the average + total ratings for a restaurant: $restaurant = $this-Restaurant-find('first', array( 'fields' = array(Restaurant.x, Restaurant.y, Restaurant.z), 'contain' = array( 'model1' = array(x, y, z), *'Rating' = array(* * 'fields' = array(* *'AVG(Rating.rating)',* *'COUNT(Rating.id)'* * )* *),* 'model2' = ... ) )); It works fine on my mysql version 5.0 on my dev server but as soon as I upload it onto live site mysql 4.1 I get error saying I *cannot mix group columns (avg, sum, etc) is illegal without a GROUPBY field.* So ok fair play, I'm not including a groupby field. I jumped in and added one: $restaurants = $this-Restaurant-find('all', array( 'fields' = array(Restaurant.x, Restaurant.y, Restaurant.z), 'contain' = array( 'model1' = array(x, y, z), *'Rating' = array(* * 'fields' = array(* *'AVG(Rating.rating)',* *'COUNT(Rating.id)'* * ),* * 'group' = 'Restaurant.id' // I also tried 'group' = 'id'* *),* 'model2' = ... ) )); Which I would figure works but it doesn't. I get an error saying that *there is no column called 'group'* and it is trying to execute this query: SELECT `Rating`.`restaurant_id`, AVG(`Rating`.`rating`), COUNT(`Rating`.`id`), `Rating`.`group` FROM `ratings` AS `Rating` WHERE `Rating`.`restaurant_id` = (5) Am I using containable incorrectly? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Mysql GROUP in containable not working
Hey all, Trying to use GROUP by in containable behaviour and it's not working as expected. Ratings model has fields: *Rating.id, Rating.restaurant_id, Rating.rating (1-5)* I have a query (which amongst other things) fetches the average + total ratings for a restaurant: $restaurant = $this-Restaurant-find('first', array( 'fields' = array(Restaurant.x, Restaurant.y, Restaurant.z), 'contain' = array( 'model1' = array(x, y, z), *'Rating' = array(* * 'fields' = array(* *'AVG(Rating.rating)',* *'COUNT(Rating.id)'* * )* *),* 'model2' = ... ) )); It works fine on my mysql version 5.0 on my dev server but as soon as I upload it onto live site mysql 4.1 I get error saying I *cannot mix group columns (avg, sum, etc) is illegal without a GROUPBY field.* So ok fair play, I'm not including a groupby field. I jumped in and added one: $restaurants = $this-Restaurant-find('all', array( 'fields' = array(Restaurant.x, Restaurant.y, Restaurant.z), 'contain' = array( 'model1' = array(x, y, z), *'Rating' = array(* * 'fields' = array(* *'AVG(Rating.rating)',* *'COUNT(Rating.id)'* * ),* * 'group' = 'Restaurant.id' // I also tried 'group' = 'id'* *),* 'model2' = ... ) )); Which I would figure works but it doesn't. I get an error saying that *there is no column called 'group'* and it is trying to execute this query: SELECT `Rating`.`restaurant_id`, AVG(`Rating`.`rating`), COUNT(`Rating`.`id`), `Rating`.`group` FROM `ratings` AS `Rating` WHERE `Rating`.`restaurant_id` = (5) Am I using containable incorrectly? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Dynamic menu based on deep relationships
Hey all, I've looked through pretty much every menu tutorial out there for cakephp and have sat for ages to try and think up how I can achieve this but to no avail. I have a semi-complex database structure of establishments (restaurants, hotels etc). Province - Region - Suburb - Establishment as well as Category - Subcategory - Establishment Now the user needs to be able to select the province from the list, have it show the regions under that province, then the suburbs, then a list of subcategories under that province that contain establishments. I can handle the fetching the data (eg how to pull out the list using containable etc) but it's the starting foundation I'm having problems figuring out. IT will be done in ajax but the actual ajax part I could probably do myself. I would like to have the menu also build itself from the page that the user is on (eg the user can browse around the menu in itself but if he also goes to the a related page (eg suburbs/view/cape-town) then the menu should know where the user is) I honestly can't think of even where I should start here. Building a menu is simple in plain php with simple relationships but it's getting pretty tricky with all the extra levels. Does anyone have any advice on a starting point which I could work with... I'm trying to make it extendable in the sense that I don't want to hard code anything. I'm starting to think it may be better off to handle the menu separately in a menu model and update the menu on each of the related models afterSave(), etc callback but that seems a bit unnecessary as it would just be duplicated data. Thanks in advance! Bryan Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Custom prefix route not working with pagination when named parameters present
Hey guys, Having a weird problem here. Have a basic function judge_index($type = null) that spits out a simple listing. Basic $this-paginate(); function. In the view I have: $paginator-options(array('url'=array_merge(array('judge' = true), $this-passedArgs))); The judge_index gets called 2 ways. One with the $type variable and one without. The $type variable simply adds one extra condition to the paginator variable. The paginator correctly renders the next/back links with the custom judge route only when there are no other passedArgs present. Without named parameters I get: /judge/judgings/index/page:2 With parameters I get: /judgings/index/page:2/type:disqualified/judge:1 How can I get it to correctly add the custom route with parameters? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Containable pagination query
Ah dang. Yeah in the end I made some custom queries to accomplish it. Yoh what a pain. On Tue, Apr 27, 2010 at 10:52 AM, WebbedIT p...@webbedit.co.uk wrote: Your not going to have a massive amount of joy with running calculations of this nature on the fly so I would be looking at counterCache and possibly implementing your own afterSave/Delete callback methods to add COUNT and SUM values direct into your tables that you can then easily group and order your values by. HTH Paul Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Containable pagination query
Hey all, I've almost reached the end of application and this last little bit is really getting to me! Can anyone shed some light? Models: Submission hasMany Judging which belongsTo Judge (and submission) The submissions are entries submitted by students. Judgings stores each judges scores they have entered for each submission. (score_originality, score_overall, score_objective, score_technical) Judges stores each judges info. Submission table contains a semifinalist tinyint. Judging contains a disqualified tinyint. What I'm trying to do is perform a query to fetch all the submissions and the total score as well as the number of judges that judged that submission. Then I also need to fetch the top25/top50/top100 scoring submissions as well as the number of judges+total score. I've tried every combination of containable I can think of but I'm about to pull my hair out here... thanks guys! Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Correct places to insert authentication code
Hey guys, I'm having some difficulties with my authentication code. I'm wondering if anyone can point me in the right direction. I have 3 routes set. admin / adminjudge / judge. admin + adminjudge are hardcoded logins as they will never change and use the User model to authenticate. judge uses the Judge model. I have the judge working nicely and it uses the Judge model alright. But something is a bit awol in my beforeFilter and isAuthorized etc code. Where is the best place to put the code for my login process? Upon logging in I need to ensure that I have set the correct layout (each route uses its own layout) and I need to redirect the user to the correct place upon login. Where should it all go? At the moment I have very messy code in the beforeFilter and isAuthorized but I'm not 100% clued up on where it should all go. Could someone shed some light on the situation? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Ajax Helper not respecting routes
Hey all, Weird problem. I have a ajax search form and retrieves submissions and inserts them into a div. The ajax is working although the controller does not respect the prefix. ?php echo $form-create('Submission'); echo $form-input('search', array('class' = 'quicksearch')); echo $ajax-submit('Submit', array( 'class' = 'quicksearchsubmit', 'url'= '/judge/submissions/search', 'update' = 'submissions-list')); echo $form-end(); ? When I submit I get the cake error in the div with the full layout saying that the search function is not available in the submissions controller. Nothing about judge_search. Routes are definitely working as I am logging in and using the routes properly. Anyone having this same prob? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Quick habtm problem
Hey all, Going a bit crazy here I think I need a break from this. Anyways, I have the following tables + relationships Judges MediaSegments (a category that the judge is selected to judge) JudgesMediaSegments (contains judge_id and media_segment_id) How would I find all the judges that belong to a specific media segment? I know its something really simple I just cannot seem to get it right. Thanks Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
Re: Multiple prefix routes. Second route not working.
Damn, still trying to figure this out. I did make some headway although I still get the error where its looking for the prefixroute_controller instead of the real_controller with the prefixroute_action function. Anybody with any ideas? On Wed, Apr 14, 2010 at 2:02 AM, Bryan Paddock bryanpadd...@gmail.comwrote: Hey all, I have an application that has been running for a while using admin routing. There are normal users as well as admin users. Now the application is growing and I need to create separate judging routes for judges that will log in and moderate the submissions. In my *core.php* I have the following line: Configure::write('Routing.admin', 'admin'); To which I added the new one: Configure::write('Routing.judge', 'judge'); In my *routes.php* I have the following route: Router::connect('/admin', array('controller' = 'submissions', 'action' = 'control', 'admin' = true), array('language' = 'us')); To which I added the judging one: Router::connect('/judge', array('controller' = 'submissions', 'action' = 'control', 'judge' = true), array('language' = 'us')); *submissions_controller.php* has the admin_control function which works. The judge_control does not. In fact the whole route is broken. Upon trying to access *site.com/judge* I get the error about SubmissionsController:control() not found. Does anyone know why it would not be trying to access SubmissionsController:judge_control() ? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
Re: Quick habtm problem
Ah! Thank you! After a while of tinkering with your code I realised I had the $actsAs in the controller and not the model :( Works like a charm. I've modified all of my code now to use containable behaviour. Gone with recursive = -1. On Wed, Apr 14, 2010 at 3:45 PM, Jeremy Burns jeremybu...@me.com wrote: Are you using Containable behaviour? You should be! Try this...(typed without testing - so go easy on me if it's wrong!)... From the MediaSegment controller: $this-MediaSegment-find( 'all', array( 'contain' = array( 'Judge' ), 'conditions' =array( 'MediaSegment.id' = $id ) ) ); From the judges controller: $this-Judge-MediaSegment-find( 'all', array( 'contain' = array( 'Judge' ), 'conditions' =array( 'MediaSegment.id' = $id ) ) ); From within a model, just omit the first Model in the find statement (so $this-find()) Jeremy Burns jeremybu...@me.com jeremybu...@mac.com On 14 Apr 2010, at 14:37, Bryan Paddock wrote: Hey all, Going a bit crazy here I think I need a break from this. Anyways, I have the following tables + relationships Judges MediaSegments (a category that the judge is selected to judge) JudgesMediaSegments (contains judge_id and media_segment_id) How would I find all the judges that belong to a specific media segment? I know its something really simple I just cannot seem to get it right. Thanks Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
Multiple prefix routes. Second route not working.
Hey all, I have an application that has been running for a while using admin routing. There are normal users as well as admin users. Now the application is growing and I need to create separate judging routes for judges that will log in and moderate the submissions. In my *core.php* I have the following line: Configure::write('Routing.admin', 'admin'); To which I added the new one: Configure::write('Routing.judge', 'judge'); In my *routes.php* I have the following route: Router::connect('/admin', array('controller' = 'submissions', 'action' = 'control', 'admin' = true), array('language' = 'us')); To which I added the judging one: Router::connect('/judge', array('controller' = 'submissions', 'action' = 'control', 'judge' = true), array('language' = 'us')); *submissions_controller.php* has the admin_control function which works. The judge_control does not. In fact the whole route is broken. Upon trying to access *site.com/judge* I get the error about SubmissionsController:control() not found. Does anyone know why it would not be trying to access SubmissionsController:judge_control() ? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
Re: Containable query
Aahhh.. good idea... I'll try that in the morning and see how it works out... thanks! On Sat, Dec 5, 2009 at 2:35 PM, Tonu Tusk lvot...@googlemail.com wrote: ok - probably not the most efficient, but the following should work if your relationships are setup in the models $submissions = $this-Submission-find('all', array('fields' = array ('DISTINCT student_id'), 'recursive' = -1); $student_ids =Set::extract($submissions, '/Submission/student_id'); // this gets an array of student Ids that do have submissions $contains = array('User' = array('fields' = array('id'))); // whatever other fields you want from your User record in here, or just leave the fields parameter out to retrieve all User fields $conditions = array('NOT' = array('Student.id' = $student_ids)); $students = $this-Student-find('all', array('conditions' = $conditions, 'contain' = $contains, 'fields' = array('id))); // this gets the Student records (trimmed down to just id) whose ids are not in the list of student ids with submissions // the resulting dataset for each student will also have a User entry relating to the related associated User record. // change the find call on the Student Model to list if you only want ids, or alter the containable parameters if you are working on the resulting dataset directly // OR use some set::extract functions to tailor the results you need. On Dec 4, 5:15 pm, abryant a...@tysonsteele.com wrote: You might also try (from the book.cakephp.org page on Containable) $list = $this-User-find('all', array( 'contain' = array( 'Student' = array( 'Submission.student_id' = null ) ) )); At least according to the examples in the manual this is an appropriate way to filter conditionally on a specific field in a contained relationship -- View this message in context: http://n2.nabble.com/Containable-query-tp4057992p4113719.html Sent from the CakePHP mailing list archive at Nabble.com. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Containable query
Hmm... nobody have any ideas? On Tue, Nov 24, 2009 at 4:05 PM, Bryan Paddock bryanpadd...@gmail.comwrote: Hey all, I have this relationship in question: User - hasOne Student - hasMany Submission I'm a bit stumped on how I can fetch all the users who do not have any submissions linked to their name. I've tried: $list = $this-User-find('all', array( 'contain' = array( 'Student' = array( 'Submission' = array( 'conditions' = array( 'Submission.student_id' = null ) ), ) ) )); I have the actAs in the model so the containable behaviour is functioning - there is just a problem with my specific query. Any ideas? thanks! Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Containable query
Hey all, I have this relationship in question: User - hasOne Student - hasMany Submission I'm a bit stumped on how I can fetch all the users who do not have any submissions linked to their name. I've tried: $list = $this-User-find('all', array( 'contain' = array( 'Student' = array( 'Submission' = array( 'conditions' = array( 'Submission.student_id' = null ) ), ) ) )); I have the actAs in the model so the containable behaviour is functioning - there is just a problem with my specific query. Any ideas? thanks! -- You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-...@googlegroups.com. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cake-php?hl=en.
Grouping query
Hey guys, I'm trying to figure out how best to go about doing reports for my current project. It's a website where artists upload their work and then judges make rate + comment etc. My query is in the reporting section. The main model is the Submission model. Submission belongsTo Student, Category, Competition Student belongsTo User, Country I'm trying to find out how to group by school (Student.school field). Each submission is tied to the student row by a Submission.student_id field. ie show each unique school and how many submissions there are for that school. Thanks, Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Grouping query
Basically I'm just looking for a little finger pointing in the right direction... output of a submission - http://pastebin.com/f221f94c1 I'm trying to do some reporting based on a few related model fields eg by school, by country, by category etc. each must also be grouped by all the years too. I'm dreading the submissions by week report... Any pointers would be great... I'm trying to leave as much up to the sq On Thu, Oct 15, 2009 at 4:18 PM, Bryan Paddock bryanpadd...@gmail.comwrote: Hey guys, I'm trying to figure out how best to go about doing reports for my current project. It's a website where artists upload their work and then judges make rate + comment etc. My query is in the reporting section. The main model is the Submission model. Submission belongsTo Student, Category, Competition Student belongsTo User, Country I'm trying to find out how to group by school (Student.school field). Each submission is tied to the student row by a Submission.student_id field. ie show each unique school and how many submissions there are for that school. Thanks, Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Grouping query
argh gmail hotkeys irritate me... continuing mail... Im trying to leave as much up to the sql server as possible and reduce the number of separate queries I run. I could probably accomplish all of these reports with 100's of queries all handled in the controller but that would get progressively slower should the db fill up... thanks! On Thu, Oct 15, 2009 at 4:54 PM, Bryan Paddock bryanpadd...@gmail.comwrote: Basically I'm just looking for a little finger pointing in the right direction... output of a submission - http://pastebin.com/f221f94c1 I'm trying to do some reporting based on a few related model fields eg by school, by country, by category etc. each must also be grouped by all the years too. I'm dreading the submissions by week report... Any pointers would be great... I'm trying to leave as much up to the sq On Thu, Oct 15, 2009 at 4:18 PM, Bryan Paddock bryanpadd...@gmail.comwrote: Hey guys, I'm trying to figure out how best to go about doing reports for my current project. It's a website where artists upload their work and then judges make rate + comment etc. My query is in the reporting section. The main model is the Submission model. Submission belongsTo Student, Category, Competition Student belongsTo User, Country I'm trying to find out how to group by school (Student.school field). Each submission is tied to the student row by a Submission.student_id field. ie show each unique school and how many submissions there are for that school. Thanks, Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Finding deeply related models
Ah-ha! Containable worked a charm! thanks! On Wed, Sep 9, 2009 at 5:42 PM, Dave Maharaj :: WidePixels.com d...@widepixels.com wrote: Why not use contain? 'contain' = array( 'Property' = array( 'conditions' = array( 'Property.id' = $foo), 'fields' = array( 'Property.field1, 'Property.field2')), 'Country' = array( 'fields' = array( 'Country.name'; Something along those lines. -- *From:* Bryan Paddock [mailto:bryanpadd...@gmail.com] *Sent:* September-09-09 12:42 PM *To:* cake-php@googlegroups.com *Subject:* Re: Finding deeply related models Oh no ways Hmm.. $this-Property-recursive = 1; pr($this-Property-find('all')); and it prints out the properties without extended associated data... $this-Property-recursive = 2; pr($this-Property-find('all')); and it returns nothing at all... hmmm let me look through my models - maybe I have some code in the callbacks which is causing problems... On Wed, Sep 9, 2009 at 5:07 PM, grigri j...@hendersonwebdesign.com wrote: Where on earth did you get that idea? See: http://book.cakephp.org/view/439/recursive Check the model tests in the source, there are many examples of setting recursive to 2, 3, and even 6 (in the testReadFakeThread method). hth grigri On Sep 9, 4:01 pm, Bryan Paddock bryanpadd...@gmail.com wrote: recursive only accepts 3 values... -1 / 0 / 1 Tried that :( On Wed, Sep 9, 2009 at 4:57 PM, grigri j...@hendersonwebdesign.com wrote: Set recursive to 2? On Sep 9, 3:21 pm, Bryan Paddock bryanpadd...@gmail.com wrote: Hey all, How can I get cake to retrieve deeply related info? *Property *belongsTo *Location *which in turn belongsTo *Country* How can I get $this-Property-find(xx) to return the Country as well? I'm having the same problem with *Property *belongsTo *Seller *which belongsTo *User *(every time I retrieve data for property I have to fetch the User row manually) Its happening in all of my finds - It only goes one level deep... Any ideas? I've tried setting recursive to 1... Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Finding deeply related models
Hey all, How can I get cake to retrieve deeply related info? *Property *belongsTo *Location *which in turn belongsTo *Country* How can I get $this-Property-find(xx) to return the Country as well? I'm having the same problem with *Property *belongsTo *Seller *which belongsTo *User *(every time I retrieve data for property I have to fetch the User row manually) Its happening in all of my finds - It only goes one level deep... Any ideas? I've tried setting recursive to 1... Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Finding deeply related models
recursive only accepts 3 values... -1 / 0 / 1 Tried that :( On Wed, Sep 9, 2009 at 4:57 PM, grigri j...@hendersonwebdesign.com wrote: Set recursive to 2? On Sep 9, 3:21 pm, Bryan Paddock bryanpadd...@gmail.com wrote: Hey all, How can I get cake to retrieve deeply related info? *Property *belongsTo *Location *which in turn belongsTo *Country* How can I get $this-Property-find(xx) to return the Country as well? I'm having the same problem with *Property *belongsTo *Seller *which belongsTo *User *(every time I retrieve data for property I have to fetch the User row manually) Its happening in all of my finds - It only goes one level deep... Any ideas? I've tried setting recursive to 1... Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Finding deeply related models
Oh no ways Hmm.. $this-Property-recursive = 1; pr($this-Property-find('all')); and it prints out the properties without extended associated data... $this-Property-recursive = 2; pr($this-Property-find('all')); and it returns nothing at all... hmmm let me look through my models - maybe I have some code in the callbacks which is causing problems... On Wed, Sep 9, 2009 at 5:07 PM, grigri j...@hendersonwebdesign.com wrote: Where on earth did you get that idea? See: http://book.cakephp.org/view/439/recursive Check the model tests in the source, there are many examples of setting recursive to 2, 3, and even 6 (in the testReadFakeThread method). hth grigri On Sep 9, 4:01 pm, Bryan Paddock bryanpadd...@gmail.com wrote: recursive only accepts 3 values... -1 / 0 / 1 Tried that :( On Wed, Sep 9, 2009 at 4:57 PM, grigri j...@hendersonwebdesign.com wrote: Set recursive to 2? On Sep 9, 3:21 pm, Bryan Paddock bryanpadd...@gmail.com wrote: Hey all, How can I get cake to retrieve deeply related info? *Property *belongsTo *Location *which in turn belongsTo *Country* How can I get $this-Property-find(xx) to return the Country as well? I'm having the same problem with *Property *belongsTo *Seller *which belongsTo *User *(every time I retrieve data for property I have to fetch the User row manually) Its happening in all of my finds - It only goes one level deep... Any ideas? I've tried setting recursive to 1... Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Regex validation problem.
Ah in the end I removed the validation completely... realized that putting such restrictions on names is not the best idea (eg unicode chinese/jap names etc) On Mon, Aug 31, 2009 at 5:14 PM, Dr. Loboto drlob...@gmail.com wrote: Your function does all right - alphanumeric values only as you did nothing with it. '/^[a-zA-Z0-9_-]+$/' --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Pulling in another table in a find query
I have a slight workaround at the moment... I'm converting the area geometry box to a text field and then performing the search $area = $this-Property-Seller-Agency-Channel-Area-find('first', array( 'conditions' = array('Area.id' = $areaId), 'fields' = 'AsText(ExteriorRing(`Area`.`area_box`)) as polygon, Country.name, Area.*', )); then $this-paginate['conditions'] = array('MBRContains(' .$area[0]['polygon'] . ',`Location`.`location_point`)'); $data = $this-paginate('Property'); But ideally it would be better to perform just one query instead of two... On Mon, Aug 31, 2009 at 10:28 AM, Bryan Paddock bryanpadd...@gmail.comwrote: Hi there, No, properties do not have an associated area ID. Properties are located via their location_id. Area ID's are used in another portion of the site but in this case it is necessary to do a search on area's instead of locations. Lemme give the full picture to explain it more... Properties are located by a location ID pointing to a location table which has the geomeotric points store in it. Those are single addresses of each property. Now agencies can request channels where they can purchase different suburbs. Those suburbs are stored in the areas table and assigned to each channel via a join areas_channels. What I need to accomplish now is I need to be able to search for all properties that belong to an agencies channel that are in the channel's areas they have purchased. Hence the area not being directly related to the properties. I can't assign an area_id to a property as the area has nothing to do with the property. I'm thinking I may need to do some custom sql magic here On Fri, Aug 28, 2009 at 5:22 PM, brian bally.z...@gmail.com wrote: - What I need to do now is to fetch all the properties which are inside a certain area id. Property belongsTo Area. That is, the properties table should have an area_id column. On Fri, Aug 28, 2009 at 7:02 AM, Bryan Paddockbryanpadd...@gmail.com wrote: Hey all, I'm trying to execute a query including a table which is not related. I'm not sure how I can go about doing this... 3 models in question: property (which has a location_id field) location (which has a location_point field stored as geometry point) area (which has an area_box field stored as a polygon) The location table is used to store single one to one locations for the properties. The area table is used to store suburbs etc for another part of the site. What I need to do now is to fetch all the properties which are inside a certain area id. Sounds simple enough but I just cant figure it out. Area has no relation to property and should not. The query would be something like this (I'm just writing out what the sql should look like... I'm not using raw sql in my cake app) select p.*, a.*, l.* from properties p, areas a left join location l on p.location_id = l.id where a.id = 5 and MBRContains(a.area_box, l.location_point) so bascially fetch all properties where it's associated locations.location_point is inside a specific unassociated areas.area_box identified by its areas.id. In my property query conditions I have set array('Area.id' = 5) but because it is not a directly related model cake isn't including that table in the query so its failing with an unknown table Area... Even if I add Area.area_box to the 'fields' array for the paginator it still doesn't know to fetch info from the area table. How do I tell cakephp to include an unrelated table into the query? var $uses = array('Area') was useless --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Regex validation problem.
Hey guys, Having a weird problem here... In my validation everything was working fine except now I needed to change the first + surname validation fields to allow for spaces + dashes. It was originally just working on only alphanumeric characters. The dashes + underscores was an extra addition added now. Here is the first name section of the $this-validation variable: (copied directly from the cakephp book even...) *// First name:* *// - cannot be empty* *// - must be alphanumeric* * * *'name_first' = array(* * 'name_first-1' = array(* *'rule' = 'alphaNumericDashUnderscore',* *'message'= 'First name can only contain alphanumeric characters and dashes'* * ),* * * * 'name_first-2' = array(* *'rule' = 'notEmpty',* *'message' = 'Please enter your firstname'* * )* *)* and I have the function: * function alphaNumericDashUnderscore($data)* * {* *$value = array_values($data);* *$value = $value[0];* ** *return preg_match('/^[a-zA-Z0-9]+$/', $value);* * }* Yet the validation still comes back as a failure each time... I can't figure this out... it should be rather simple but I just can't get it... --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: redirect after download dialog
If you really need to do that you may be able to accomplish it by providing the file download inside an iframe and then redirecting the main window... I haven't tried this... it's just an idea... On Fri, Aug 28, 2009 at 3:15 AM, brian bally.z...@gmail.com wrote: You can't. In order to have the browser present the user with a save dialog, certain headers need to be sent. By the time that's happened, it's too late to send a redirect header. On Thu, Aug 27, 2009 at 5:35 PM, Martin Radostamartinrado...@gmail.com wrote: Let's say I have a view that renders an excel file to download. It presents a download dialog to the user. This user can decide to save the file to the local drive, to open the file or to cancel the operation. Now I need to redirect somewhere else after any operation with the download dialog. Does anybody knows how to do this? Thnks MARTIN --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Pulling in another table in a find query
Hey all, I'm trying to execute a query including a table which is not related. I'm not sure how I can go about doing this... 3 models in question: property (which has a location_id field) location (which has a location_point field stored as geometry point) area (which has an area_box field stored as a polygon) The location table is used to store single one to one locations for the properties. The area table is used to store suburbs etc for another part of the site. What I need to do now is to fetch all the properties which are inside a certain area id. Sounds simple enough but I just cant figure it out. Area has no relation to property and should not. The query would be something like this (I'm just writing out what the sql should look like... I'm not using raw sql in my cake app) select p.*, a.*, l.* from properties p, areas a left join location l on p.location_id = l.id where a.id = 5 and MBRContains(a.area_box, l.location_point) so bascially fetch all properties where it's associated locations.location_point is inside a specific unassociated areas.area_box identified by its areas.id. In my property query conditions I have set array('Area.id' = 5) but because it is not a directly related model cake isn't including that table in the query so its failing with an unknown table Area... Even if I add Area.area_box to the 'fields' array for the paginator it still doesn't know to fetch info from the area table. How do I tell cakephp to include an unrelated table into the query? var $uses = array('Area') was useless --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
HABTM not saving
Hey all, Ok I'm pulling my hair out here. HABTM save/edit/removes are not happening. I have two models. Channel and Area. The model definitions are configured properly (channel: *var $hasAndBelongsToMany = array( 'Area' )* and area: *var $hasAndBelongsToMany = array( 'Channel' )* ) I have no clue why this is not working because I am not getting any error messages back from cake at all. I am calling validates() before save() and it validates but it does not save. I am trying to save this array $data = Array ( [Channel] = Array ( [id] = 16 ) [Area] = Array ( [0] = Array ( [id] = 14 ) ) ) I have tried saving this too Array ( [Channel] = Array ( [id] = 16 ) [Area] = Array ( [0] = 14 ) ) Is there something I am doing incorrectly? When I push debug level up to 3 I can see cake is not even trying to do any of the habtm queries. --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
HABTM Delete problem
Hey all, I'm having a strange problem - My HABTM relationship seems to be working out alright except I cannot remove the last remaining entry. This is the situation: areas channels areas_channels I have no problem in adding ares to channels. I can remove areas from channels too... I just cannot remove the last area assigned to a channel. I have: $channel = [Channel] = Array( [id], etc etc ) [Area] = Array( ) $this-Channel-save($channel); And that saves without a problem except it does not remove all the areas from that channel. Is there something I am missing? --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
CakePHP and mysql spatial data types
Hey all, Anyone had any joy with the mysql spatial extensions data types? eg POINT/ LINE/ etc? I can't see any way around this other than custom sql commands... Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting up table ID's
What is the purpose of the UUID? The database generates a unique ID for each user anyways so if it's just for internal usage then just use the ID. If you need a UUID then i'd recommend adding an extra field in the db for it. The correct way to go about it would involve the use of foregin keys. --- Users --- id uuid name email other_fields Profiles - id user_id - foreign key for the User.id field other_fields Galleries --- id user_id - foreign key for the User.id field gallery_name Albums -- id gallery_id- foreign key for the Gallery.id field album_name --- If you need to fetch the users galleries then you'll call $this-User-Gallery-find('all', array('conditions' = array( 'Gallery.user_id' = $this-Auth-user('id') ) ); And if your model's are associated properly then you'll fetch all the albums related to that gallery too. Hope this helps. On Mon, Jul 13, 2009 at 9:36 PM, Dave Maharaj :: WidePixels.com d...@widepixels.com wrote: I am setting up am app and trying UUID for each user but question I have is: So a User.id is a UUID that User hasOne Profile.id which will be the User.id correct? User.id = same as = Profile.id And say a User hasOne Gallery which hasMany Albums and each Album hasMany Photos Would the Gallery.id be the User.id? the Album has its own ID, gallery_id which would be the same UUID? User.id = same as = Gallery.id Album.id = int(11) Album.gallery_id = the users UUID Photos.id = int(11) Photos.album_id = int(11) and Photos would have their own ID but relate back to the album_id whichc would trace back to the Gallery.id and back to its original owner? Hope that makes sense Is that the right way to do it? Thanks, Dave --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Simple relationship problem
Hey JD, Ah... I'm confused as to why I would need a HABTM and a join table for a fairly simple relationship. example of the structure: Seller.id Seller.name Seller.agency_id etc and Agency.id Agency.name etc Each seller can only belong to one agency. Each agency can have any number of sellers. I've defined $hasOne and $belongsTo but cake complains that there is no agency.seller_id field which is correct because that would imply that each agency can only have one seller. Hm. On Mon, Jun 29, 2009 at 8:25 PM, JD Danielsj...@internetguys.ca wrote: You need to look at hasAndBelongsToMany http://book.cakephp.org/view/83/hasAndBelongsToMany-HABTM Bryan Paddock wrote: Argh.. I hate gmail shortcut keys. Anyways continuing mail: Heya all, Theres something I'm not doing right here... I have a User model which has one Seller model linked to it which in turn can have an Agency model linked to it. User Model: hasOne seller. Seller Model: belongsTo user Agency Model: belongsTo seller Now when I call $this-User-find('all') it complains that there is no foreign key in the agency table. That would be impossible because then that would mean only one agency can belong to one seller. How do I set it up so that any number of agencies can belong to any number of sellers? I'm missing something really stupid here Thanks! Bryan On Mon, Jun 29, 2009 at 7:06 PM, Bryan Paddockbryanpadd...@gmail.com wrote: Heya all, Theres something I'm not doing right here... I have a User model which has one Seller model linked to it which in turn can have an Agency model linked to it. User Model: hasOne seller. Seller Model: belongsTo user Agency Model: belongsTo seller --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Pagination not respecting page numbers
Heya, Ahh I figured out what the problem was... I had $data = $this-paginate('Property', $conditions, $fields, $theorder, $resultsperpage, $page); but the paginate function doesn't take those parameters... I had to use: $this-paginate = array( 'limit' = $resultsperpage, 'order' = $theorder, 'fields'= $fields, 'page' = $page ); $data = $this-paginate('Property'); oops! On Wed, Jun 24, 2009 at 9:16 PM, schneimimichael.schne...@arcor.de wrote: Hi, I am not sure about your problem, but I also use named params and can tell you how to pass them to the next pages without a session workaround. Well, but you can also do it with the session, the only thing you have to do, is to pass the named parameters to the pagination functions with the url option. For not using the session, you can define the options in the controller with the incoming params like this $this-set('paginationOptions', array('url' = array('title:'. $this-params['named']['title'], 'year:'.$this-params['named']['year']))); and then pass the options to the pagination functions that you use in the view, like $paginator-numbers($options),... Hope this helps, Michael On 24 Jun., 20:44, Bryan Paddock bryanpadd...@gmail.com wrote: Hey all, I was using the paginator and it was working pretty well for me when I was using all the search criteria as named url parameters. I discovered that the paginator didn't send the parameters to the next pages so implemented sessions to store the criteria. The arrays I create from the session (critera/order) generate fine and the page number variable I take from the named url parameter. examples of values follow $conditions = Array ( [sale] = 1 ) $theorder = Array ( [created_date_time] = DESC ) $resultsperpage = 10; $page = 1; // or 2, 3, etc My paginator call is: $data = $this-paginate('Property', $conditions, $theorder, $resultsperpage, $page); For some reason it respects the conditions, order and results per page but NOT the page number. Anyone have any ideas why? I test the value of the $page variable and it does correctly change but the data received from the model remains the same. Am I doing something wrong here? I can't figure out what's going on thanks! bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Simple relationship problem
Heya all, Theres something I'm not doing right here... I have a User model which has one Seller model linked to it which in turn can have an Agency model linked to it. User Model: hasOne seller. Seller Model: belongsTo user Agency Model: belongsTo seller --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Simple relationship problem
Argh.. I hate gmail shortcut keys. Anyways continuing mail: Heya all, Theres something I'm not doing right here... I have a User model which has one Seller model linked to it which in turn can have an Agency model linked to it. User Model: hasOne seller. Seller Model: belongsTo user Agency Model: belongsTo seller Now when I call $this-User-find('all') it complains that there is no foreign key in the agency table. That would be impossible because then that would mean only one agency can belong to one seller. How do I set it up so that any number of agencies can belong to any number of sellers? I'm missing something really stupid here Thanks! Bryan On Mon, Jun 29, 2009 at 7:06 PM, Bryan Paddockbryanpadd...@gmail.com wrote: Heya all, Theres something I'm not doing right here... I have a User model which has one Seller model linked to it which in turn can have an Agency model linked to it. User Model: hasOne seller. Seller Model: belongsTo user Agency Model: belongsTo seller --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Cakephp 1.2 + swfupload
hey man thanks for the heads up... tried searching through there again.. still no luck... It's a weird problem.. swfupload appears to be working 99%... I get the file upload box, I can upload a file and it displayed the progress etc as the file gets uploaded... but theres just no data appearing at the other side in the controller function... no matter how big/small the file is... Has nobody else experienced this problem? On Fri, Jun 19, 2009 at 10:06 PM, rod rodrigo.z...@gmail.com wrote: I'm sure you can find something on this group: http://groups.google.com/group/cake-php/search?group=cake-phpq=swfuploadqt_g=Search+this+group or at swfupload website: http://swfupload.org/search/node/cakeph I've been using a similar one, Uploadify: www.uploadify.com On Jun 18, 1:38 pm, Bryan Paddock bryanpadd...@gmail.com wrote: Hey guys, I've been sitting with this swfupload module for days and just cant seem to get it right. In my js to create the uploader i have this setting: upload_url: /properties/uploadvideo, and I have my function uploadvideo() in my properties controller I've done some simple debugging like so: $fp = fopen('/tmp/debug', 'w'); fwrite($fp, print_r($this-params['form'], true)); fclose($fp); swfupload successfully sends the file to the server althought all that finds its way to the debug file is array() cakephp is not handling the file upload... any ideas? has anyone here got it working successfully? bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Pagination not respecting page numbers
Hey all, I was using the paginator and it was working pretty well for me when I was using all the search criteria as named url parameters. I discovered that the paginator didn't send the parameters to the next pages so implemented sessions to store the criteria. The arrays I create from the session (critera/order) generate fine and the page number variable I take from the named url parameter. examples of values follow $conditions = Array ( [sale] = 1 ) $theorder = Array ( [created_date_time] = DESC ) $resultsperpage = 10; $page = 1; // or 2, 3, etc My paginator call is: $data = $this-paginate('Property', $conditions, $theorder, $resultsperpage, $page); For some reason it respects the conditions, order and results per page but NOT the page number. Anyone have any ideas why? I test the value of the $page variable and it does correctly change but the data received from the model remains the same. Am I doing something wrong here? I can't figure out what's going on thanks! bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Cakephp 1.2 + swfupload
Hey guys, I've been sitting with this swfupload module for days and just cant seem to get it right. In my js to create the uploader i have this setting: upload_url: /properties/uploadvideo, and I have my function uploadvideo() in my properties controller I've done some simple debugging like so: $fp = fopen('/tmp/debug', 'w'); fwrite($fp, print_r($this-params['form'], true)); fclose($fp); swfupload successfully sends the file to the server althought all that finds its way to the debug file is array() cakephp is not handling the file upload... any ideas? has anyone here got it working successfully? bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Accessing auth information from within model class
Hey all, I can't seem to find out how to access the Auth class from within the model? I have models/property.php where in the afterfind() function I need to perform certain functions based on the user_id if the user is logged in. $this-Auth-user() is not within the scope. I can't use $this-Session either. Any ideas on how I can access either of them? thanks! Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
hooking onto the find() query
hey guys, is it possible to hook onto the database queries? ie: each time i call a $this-Property-find() or findById() etc etc I would like to perform certain functions on the data returned and include them in the results.. I know I can create my own function for pulling data out but I was hoping there was a way to do it without creating too many of my own functions... bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: hooking onto the find() query
*shoots himself for not seeing that... thanks man... On Mon, Jun 1, 2009 at 6:33 PM, Eber Freitas Dias eber.frei...@gmail.comwrote: I guess this is what you need: http://book.cakephp.org/view/76/Callback-Methods On Mon, Jun 1, 2009 at 1:30 PM, Bryan Paddock bryanpadd...@gmail.comwrote: hey guys, is it possible to hook onto the database queries? ie: each time i call a $this-Property-find() or findById() etc etc I would like to perform certain functions on the data returned and include them in the results.. I know I can create my own function for pulling data out but I was hoping there was a way to do it without creating too many of my own functions... bryan -- Éber Freitas Dias www.eberfdias.com www.dejamps.net --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Need help on password generation
Hi Gangzheng, Use the core ajax helper for that. in your controller: var $helpers = array('Ajax', 'Javascript') var $components = array('RequestHandler') in the view that is going to hold the link, create the link with the ajax helper instead of the html helper: echo $ajax-link( 'Generate Password', array( 'controller' = 'controllername', 'action' = 'generatePassword', array( 'update' = 'id_of_div_to_be_updated', 'complete' = 'alert(Your password has been generated) ' ) ); then in your generatepassword controller function make sure you send the generated password to the view which you'll create in your views/controller folder $this-set('password', $new_password); so you can print out the password in your view with echo $password; hope this helps! bryan On Wed, May 27, 2009 at 8:39 AM, liaogz82 liaog...@gmail.com wrote: Hi all, I need help on the cakePHP coding. I have a function called generatePassword() in the controller. I want to create an ajax link in such a way that user can click on the link and it will talk to the method, take the password and display it on the textbox. Can this be done? Gangzheng --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
geo-location database
hey guys, not really a cake specific question but related nonetheless... have any of you worked with international location databases? know of any pay-for or free? busy working on a property site and the requirement is to have it be internationalized with country-state/suburb/county/etc selectable for the whole world... it's quite a requirement but it must have been done before... --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: How to redirect to login page
Hi Bharani, Read through the cakephp cookbook http://book.cakephp.org More specifically the section on auth: http://book.cakephp.org/view/172/Authentication Pointers: http://book.cakephp.org/view/172/Authentication - set up the Auth component in your app_controller and add setup settings in the beforeFilter() function - set which pages you are allowed anonymous access to using $this-Auth-allow('index', 'posts', 'etc', 'etc); (in beforeFilter()) - add login() and logout() functions to your controller(s) you wish to do auth... the cookbook has rather detailed explanations bryan On Tue, May 26, 2009 at 11:11 AM, lakers fan lakersfa...@msn.com wrote: Hello, I m new to cakephp.. I want to check in every page whether a user has logged in or not.. If not I want to redirect him to login page. Is there a way to do it in a common place like app_controller? Thanks, Bharani -- Windows Live™: Keep your life in sync. Check it out.http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009 --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Problem with retrieving data with relationships
ahhh awesome thanks man... still getting to grips with cakephp here! On Sat, May 23, 2009 at 8:45 PM, Ricky Paz ricky...@gmail.com wrote: Hi, You have to use belongsTo and hasMany for 1-n relationship, and not hasOne and hasMany. In your PropertiesModel, put $belongsTo = 'Seller, and, inside SellerModel, put hasMany = 'Property'. --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Problem with retrieving data with relationships
Hi all, Just started learning cakephp last week so a bit scratchy and still learning... There are two tables in question here: property - stores rows of properties seller - stores sellers of the properties. - one property can only have one seller - one seller can have many properties property model has its hasone definition: // one property has one seller var $hasOne = array( 'Seller' = array( 'className'= 'Seller', 'foreignKey'= 'id' ) ); seller model has its hasmany defintion: // one seller can have any number of favourites and properties var $hasMany = array( 'Favourite' = array( 'className' = 'Favourite', 'foreignKey'= 'seller_id', 'dependent'= true ), 'Property' = array( 'className' = 'Property', 'foreignKey' = 'seller_id' ) ); ignore the favourites table for now... property table contains 'seller_id' property table id seller_id x seller table --- id xx (I do have $useTable defined in each model to ensure table names are correct) In my browse function of the propertiescontroller I have the standard code: $this-pageTitle = 'Browse All Properties'; $this-paginate['limit'] = 25; $data = $this-paginate('Property'); $this-set('properties', $data); It returns the properties but blank seller information.. it has the full seller array with all the database fields but no values for any of them... Can anyone shed some light on this? I'm quite stuck here! - Bryan --~--~-~--~~~---~--~~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---