Re: Doing INNER JOIN with Cake's relationships

2007-09-29 Thread AD7six
On Sep 28, 2:06 am, neromir [EMAIL PROTECTED] wrote: Hi, I've got a few tables that I'm trying to join using Cake's built in relationship setup. I have a users table, comments table, and comment type table. I'm trying to show all of the comments to a moderator and as such have set up a

Re: Unclear as to Path Settings on Cake Install

2007-09-29 Thread AD7six
On Sep 28, 10:15 pm, CakeONaut [EMAIL PROTECTED] wrote: Hi! I am using a Linux host and I'm putting a plain vanilla install of the latest stable Cake here: '/home/net4/public_html/tst/wwwroot/cake' and the app is in the same place: '/home/net4/public_html/tst/wwwroot/app' I have

Re: Why is findAll() not reading one field

2007-09-29 Thread AD7six
On Sep 29, 6:57 am, Conrad [EMAIL PROTECTED] wrote: I have a table that is filled by program. This table contains field named check_num that contains data in the table, but is not being read out. $result = $this-Dailypay-findAll(); $this-set('row',$result); This

Re: Newbie, slow response, wrong tools ?

2007-09-29 Thread AD7six
On Sep 28, 10:09 pm, Phil [EMAIL PROTECTED] wrote: Newbie, slow response, wrong tools ? I use ms access to run a small business and have decided to replace my app with linux, apache2, postgres 8., cakephp 1.2 so far i have got as far as adapting the bookmarks tutorial by graham

Re: Another HABTM self referencing question - cannot save data?

2007-09-29 Thread AD7six
On Sep 28, 11:36 pm, red [EMAIL PROTECTED] wrote: Hello everybody! I want to make something similliar to friend list, so I used self referencing HABTM - users_users. The tables are: users (id, friend_id, bla bla bla) - pk (id, friend_id) // and id of course == friend_id

Re: Theory again - mysql_query(INSERT INTO table...

2007-09-29 Thread AD7six
On Sep 29, 7:30 am, Conrad [EMAIL PROTECTED] wrote: I am not finding the logic in doing the equiv. of an INSERT query. I am not seeing how $this-Model-save($this-data) knows which it is, an insert or an update. Can anyone spell it out for me, Sometimes I think I am somewhat simple

Re: Theory again - mysql_query(INSERT INTO table...

2007-09-29 Thread Conrad
In other words, if you don't pass a 'id', or pass 'id' = null, it will do an insert, otherwise if there is a non-null value for id it will update. ??? Conrad On Sep 29, 12:25 am, AD7six [EMAIL PROTECTED] wrote: On Sep 29, 7:30 am, Conrad [EMAIL PROTECTED] wrote: I am not finding the logic

Re: Why is findAll() not reading one field

2007-09-29 Thread Conrad
Deleted tmp (cache/models - only files there) and swiched debug to 2. No difference noted. Conrad On Sep 29, 12:10 am, AD7six [EMAIL PROTECTED] wrote: On Sep 29, 6:57 am, Conrad [EMAIL PROTECTED] wrote: I have a table that is filled by program. This table contains field named check_num

Re: Why is findAll() not reading one field

2007-09-29 Thread Conrad
I tried using the straight php code: $resultID = mysql_query(SELECT * FROM dailypays); for ($x= 0; $x mysql_num_rows($resultID); $x++) { $row = mysql_fetch_assoc($resultID); ...

Re: Another HABTM self referencing question - cannot save data?

2007-09-29 Thread red
It's a bit closer, but now I get in debug: SELECT COUNT(id) AS count FROM `users` WHERE `id` = 5 SELECT COUNT(id) AS count FROM `users` WHERE `id` = 5 UPDATE `users` SET `id` = 5 WHERE `id` IN (5) DELETE FROM `users_users` WHERE user_id = '5' INSERT INTO `users_users` (user_id,friend_id) VALUES

Re: create subdomain.

2007-09-29 Thread Isaac Raja
Hi, I have done it actually. i also use cake php to power it. My domain is www.indiandrs.in i'll tell you what i have done. I spoke with my web hoster and told him to add a wildcard entry for my domain *.indiandrs.in after that, in before filter of u r application, u should extract the

Re: Theory again - mysql_query(INSERT INTO table...

2007-09-29 Thread AD7six
On Sep 29, 8:29 am, Conrad [EMAIL PROTECTED] wrote: In other words, if you don't pass a 'id', or pass 'id' = null, it will do an insert, otherwise if there is a non-null value for id it will update. ??? That isn't what I said. If it isn't clear try it. One thing to note depending on your

Re: Another HABTM self referencing question - cannot save data?

2007-09-29 Thread AD7six
On Sep 29, 10:13 am, red [EMAIL PROTECTED] wrote: It's a bit closer, but now I get in debug: SELECT COUNT(id) AS count FROM `users` WHERE `id` = 5 SELECT COUNT(id) AS count FROM `users` WHERE `id` = 5 UPDATE `users` SET `id` = 5 WHERE `id` IN (5) DELETE FROM `users_users` WHERE user_id =

Re: Why is findAll() not reading one field

2007-09-29 Thread AD7six
On Sep 29, 9:12 am, Conrad [EMAIL PROTECTED] wrote: I tried using the straight php code: $resultID = mysql_query(SELECT * FROM dailypays); for ($x= 0; $x mysql_num_rows($resultID); $x++) { $row = mysql_fetch_assoc($resultID);

Question About Router,Friendly URL.

2007-09-29 Thread TGG008
Hi,everyone! I've been involed in this problem days... in my routes.php I defined : Router::connect('/google/:id/*', array('controller' = 'users', 'action' = 'view')); when browse /google/123[any number] it display the page of 'controller' = 'users', 'action' = 'index'

How to generate URL without ':' that has argument.

2007-09-29 Thread TGG008
It'known that with router: -- start--- Router::connectNamed(array('id')); Router::connect('/something/*', array('controller' = 'users', 'action' = 'view')); ---

Re: Another HABTM self referencing question - cannot save data?

2007-09-29 Thread red
On 29 Wrz, 12:23, AD7six [EMAIL PROTECTED] wrote: ... which is by design, otherwise how could you (easily) delete an association. There are a few posts/threads/bakery articles/etc. around with working with habtm in the title, after a quick google I am sure you will find the info you are

Re: How to generate URL without ':' that has argument.

2007-09-29 Thread cakeFreak
Why in your users/something function you don't write function something($id = null) { if (!$id) { $this-Session-setFlash(record not existent); $this-redirect(array('action'='index'), null, true); exit;

Re: Best way to handle GUESTS with ACL and groups

2007-09-29 Thread cakeFreak
Cheers Geoff! With all answers you gave me I own you a couple of beers ;0) By the way you therefore do -ROOT ---Admins -Editors Users And then you deny all actions (or just all, but read) to ROOT? Dan --~--~-~--~~~---~--~~ You received this

SimpleTesting

2007-09-29 Thread Changoso
Hello, I did a system using cake that handles logins and mainly the basic things that you get by baking (add, delete, view, edit) I have to do som tests using simpletest php (http://simpletest.org/) To check if a member is logged i thought that by doing an if function such as:

Using blank in Data Validation

2007-09-29 Thread Ahsan
Hi guys, I was going through all the built-in rules for data validation in 1.2. I was just wondering whats the use of the blank rule? Since it is there, I am sure it has a use, but I am not being able to figure it out. Any ideas? Thanks. -- Regards Ahsanul Bari

Re: SimpleTesting

2007-09-29 Thread Changoso
Also, If I want to check if I delete a file, I check if the delete link exists but dont really check the actuall deleting, is there a way to check this? thanks On Sep 29, 8:23 am, Changoso [EMAIL PROTECTED] wrote: Hello, I did a system using cake that handles logins and mainly the basic

belongsTo association bug?

2007-09-29 Thread Toad
Hi i have an error in the cake produced SQL when defining belongsTo association with conditions. Here the technical details: I have a table Comments CREATE TABLE `comments` ( `id` int(64) NOT NULL auto_increment, `parentobject_id` int(64) NOT NULL default '0', `parentobject_lookup`

findAll() + custom field

2007-09-29 Thread unvs
Hi everyone! First of all I'm new to Cake (which you'll probably see) - my question is this: $this-set('invoices', $this-Invoice-findAll()); does exactly what I want it to do, except that I also want to incorporate a custom field into the query. That field would be

no values in bake.php script

2007-09-29 Thread Jacob83
Hi out there, i get a problem problem in cake.php... i dont get the name of the fields in my database. It the same in associations.. What goes wrong? Regards, Jacob www.avr-projects.info snippet: Would you like to supply validation criteria for the fields in your model? (y/n) [y] Name: Type:

Re: Using blank in Data Validation

2007-09-29 Thread FallenJehova
Hi, I think this article will help you: http://cakebaker.42dh.com/2007/01/03/validation-with-cakephp-12/ Good luck! On 29 sep, 10:49, Ahsan [EMAIL PROTECTED] wrote: Hi guys, I was going through all the built-in rules for data validation in 1.2. I was just wondering whats the use of the

Re: Using blank in Data Validation

2007-09-29 Thread Ahsan
Thanks FallernJehova. I have already gone through the article, and this is what is has to say about blank: blank validates that a field is blank or contains only whitespace characters like tabs or spaces. It doesn't look very useful to me. I know what it does, but what I wanted to know was any

How do I removed header CakePHP Rapid Development in my page

2007-09-29 Thread firdzak
Hi I'm very new in php or cake I have try examples of cake in manual and its look cool but at the top of the page, it has a header CakePHP Rapid Development and at th bottom of the page it has an icon link to cakephp how do i remove this? --~--~-~--~~~---~--~~

Re: How do I removed header CakePHP Rapid Development in my page

2007-09-29 Thread cakeFreak
In your website installation go to: cake\libs\view\templates\layouts copy the file dafault.ctp (cake 1.2 - or default.thtml cake 1.1) in your app\views\layouts Open it and edit it according to your need. Dan --~--~-~--~~~---~--~~ You received this message

Re: How do I removed header CakePHP Rapid Development in my page

2007-09-29 Thread firdzak
tq for ur help. its cool On Sep 30, 1:01 am, cakeFreak [EMAIL PROTECTED] wrote: In your website installation go to: cake\libs\view\templates\layouts copy the file dafault.ctp (cake 1.2 - or default.thtml cake 1.1) in your app\views\layouts Open it and edit it according to your need.

Re: Newbie, slow response, wrong tools ?

2007-09-29 Thread Phil
Will do, thanks for the suggestion On 29 Sep, 04:37, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Phil, The problem isn't the amount of records, it's that you're trying to display too many results on a single page at the same time. For this, there is pagination. Read this on how to

Re: Newbie, slow response, wrong tools ?

2007-09-29 Thread Phil
More stuff to learn then, at least it is encouraging to know moving from msaccess is a good idea Thanks for the help phil On 29 Sep, 07:21, AD7six [EMAIL PROTECTED] wrote: On Sep 28, 10:09 pm, Phil [EMAIL PROTECTED] wrote: Newbie, slow response, wrong tools ? I use ms access to run a

Re: How do I removed header CakePHP Rapid Development in my page

2007-09-29 Thread ihti
edit default layout page (/app/views/layouts/default.ctp) On Sep 29, 6:45 pm, firdzak [EMAIL PROTECTED] wrote: Hi I'm very new in php or cake I have try examples of cake in manual and its look cool but at the top of the page, it has a header CakePHP Rapid Development and at th bottom of

Re: Why is findAll() not reading one field

2007-09-29 Thread Conrad
AD, Using EITHER Cake or normal PHP, the value in the 'check_num' field, although valid in the table, is not being read. The field is filled IN THE TABLE, but not in the associative array (either $this-data, or $row = mysql_fetch_assoc() ) This does not appear to be a cake problem, as normal

Re: Why is findAll() not reading one field

2007-09-29 Thread Conrad
I was trying to read a field named 'check_num'. I changed the field name to 'draft' (and throughout the logic) and it all works now. Go Figure! Conrad On Sep 29, 1:43 pm, Conrad [EMAIL PROTECTED] wrote: AD, Using EITHER Cake or normal PHP, the value in the 'check_num' field, although valid

Re: Another HABTM self referencing question - cannot save data?

2007-09-29 Thread red
I think that I worked out better solution for this. The model relation: var $hasAndBelongsToMany = array( 'Friend' = array('className' = 'User', 'joinTable' = 'users_users',

Edit Action in Cake 1.2 Crashes Apache (XAMPP) on Windows

2007-09-29 Thread Tom.Maiaroto
It seems that any normal edit action in any controller is crashing my apache server. Found out when upgrading from 1.1 to 1.2. At first I thought maybe some error popped up in a bad way from the html-input's being changed to form-input's and other deprecated code ... logical. It was the only

Re: How to generate URL without ':' that has argument.

2007-09-29 Thread JadB
Overwrite the 'router.php' file found in /cake/libs with a copy of it in your /app/ folder and then change the following: /** * Separator used to join/split/detect named arguments * * @var string * @access private */ var $__argSeparator = ':'; Just replace it with whatever

Like DEBUG 2: x queries took y ms without warnings and queries?

2007-09-29 Thread bigbass
Hi happy bakers, is there an easy way to display the line 'x queries took y ms' in my app (cake 1.1.x) without warnings and the queries-table? (Just like DEBUG set to 2) I didn't dig into the code yet, (and don't like core-mods anyway) but it would be cool to have that for debugging purpose.

Re: Why is findAll() not reading one field

2007-09-29 Thread Mike Green
Is it ok that we call moma rodriques on that number??? On 29/09/2007, Conrad [EMAIL PROTECTED] wrote: I was trying to read a field named 'check_num'. I changed the field name to 'draft' (and throughout the logic) and it all works now. Go Figure! Conrad On Sep 29, 1:43 pm, Conrad

Re: Edit Action in Cake 1.2 Crashes Apache (XAMPP) on Windows

2007-09-29 Thread Tom.Maiaroto
more specifically than $html-tagValue() it's where/how that is used. ?php echo $html-link($html-image(admin/page_delete.gif) . ' Delete','/settings/delete/' . $html-tagValue('Setting/id'), array(style=text-decoration: none;), 'Are you sure you want to delete: id ', false);? On Sep 29, 7:10 pm,

Re: Edit Action in Cake 1.2 Crashes Apache (XAMPP) on Windows

2007-09-29 Thread Tom.Maiaroto
$html-tagValue() is what caused the crash for me. Yes, it is deprecated in 1.2, but I would have thought a warning/error message would have popped up like most other things that are deprecated - rather than just crashing apache. Yes it was my code at fault (as suspected)...but a good note for

GoogleBot gets a 404 on site with out index.php

2007-09-29 Thread Alex Jeffery
Hi, I have a strange issue where I have installed cakePHP and it looks like it works fine. If I browse to http://AlexJeffery.org/ I see what I would expect. How ever googlesite maps says it gets a 404 on http://AlexJeffery.org/ I have tried several spiders to generate a sitemap and they all get

can't get CRUD to run

2007-09-29 Thread SIXS
Hi, I have installed a new version or XAMPP and Cakephp. I get the cake page with and database found Http://localhost/cake/ I build the controllers players_controller.php and teams_controller.php. I build the models player.php and team.php I run Http://localhost/cake/teams/add and I get and error