Re: Find all Posts WITHOUT Tags (habtm)

2010-06-04 Thread Alexandru Ciobanu
On 5/24/2010 5:55 PM, designv...@gmail.com wrote: Hi All, I'm currently finding all Posts without Tags by querying the join table and getting the unique Post id's then using them in a second query on the Posts table to find all Posts with an id NOT in the first array. What I was wondering is

session related query

2010-06-04 Thread vikasphplernter
hai all I have facing the problem of session management because once I delete or destroy the session in logout page so it will redirect the index page and this process is correct but once I click the back button of the browser it open the welcome page with login the user and there the previous

Re: Order problem with deep association

2010-06-04 Thread shantamg
yes, that about does it.. but what if i want to order by two fields? something like: Person.category_id asc, Person.name asc On Jun 2, 12:21 am, vekija vedran.konto...@gmail.com wrote: Not sure if I understood the question, but if you want Alix to appear before Shantam you can sort the

How to Add/Remove records dyanmically...

2010-06-04 Thread Narendra Padala
Hi i am new to cakephp, here i attached the screen shot off my application please see that attachment, any one having the related sample code please help me out. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this

displaying sql query

2010-06-04 Thread ytbryan
Hi all, Can someone help me with this. I do a query on my database from model. function getResult() { $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123); } I call assign the query result to the view from controller. function index(){

auto refreshing page

2010-06-04 Thread ytbryan
Hi all, How should I go about creating a page in cakephp that can auto refresh by itself. basically, I want to fetch the latest data from the database. I don't want the whole page to refresh. Merely the latest number. Can someone give me some advise? /bryan Check out the new CakePHP Questions

Re: displaying sql query

2010-06-04 Thread Toby Ashley
You never return $result from the getResult function. You need: function getResult() { $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123); return $result; } On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote: Hi all, Can someone help me with

Re: displaying sql query

2010-06-04 Thread Dilip Godhani
try this function getResult() { $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123); print_r($result); } On Fri, Jun 4, 2010 at 3:16 PM, Toby Ashley lowpi...@gmail.com wrote: You never return $result from the getResult function. You need: function getResult() {

Re: auto refreshing page

2010-06-04 Thread Bharadwaj Parthasarathy
Hi Bryan, I assume you want to build something like 'x' number of ipads sold. You can use the Javascript setinterval function to make an ajax call. This ajax call can update the div to show the latest number in your case. Thanks, Bharadwaj http://webhostingangel.com On 04-Jun-10, at 4:42

Cake console shell

2010-06-04 Thread Edwin
Hi all, When trying to run /path_to/cake/console/cake mail in shell I get the following error: Error: Class MailShell could not be loaded. Can anybody perhaps point me in the right direction why i get this error? Thanks! Check out the new CakePHP Questions site http://cakeqs.org and help

Re: Cake console shell

2010-06-04 Thread euromark
just type cake and you will see the available shells yours is not in that list i guess On 4 Jun., 12:20, Edwin edwink...@gmail.com wrote: Hi all, When trying to run /path_to/cake/console/cake mail in shell I get the following error: Error: Class MailShell could not be loaded. Can anybody

Re: Cake console shell

2010-06-04 Thread Edwin
Thanks, got it working! I forgot to add the -app parameter. Is there any parameter or way that i can dissable any output from the console? E.g. don't display the Welcome to CakePHP v1.3.0 Console etc. Thanks again On Jun 4, 12:38 pm, euromark dereurom...@googlemail.com wrote: just type cake

Message Model with Sender and Recipient from User-Table

2010-06-04 Thread nils
Hi all, I've got a messages model with two fields called sender and recipient which I'd like to link to the users table. I tried: -- var $hasOne = array( 'User' = array( 'className' = 'User', 'foreignKey' = 'sender',

Re: Message Model with Sender and Recipient from User-Table

2010-06-04 Thread Jeremy Burns
Try: var $hasOne = array( 'Sender' = array( 'className' = 'User', 'foreignKey' = 'sender', 'conditions' = 'User.id = Message.sender', 'fields' = '', 'order' =

Re: Cake console shell

2010-06-04 Thread euromark
why does it bother you? :) just ignore it On 4 Jun., 13:59, Edwin edwink...@gmail.com wrote: Thanks, got it working! I forgot to add the -app parameter. Is there any parameter or way that i can dissable any output from the console? E.g. don't display the Welcome to CakePHP v1.3.0 Console

Re: Message Model with Sender and Recipient from User-Table

2010-06-04 Thread nils
nah, doesn't work.. :/ 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

Re: Message Model with Sender and Recipient from User-Table

2010-06-04 Thread Jeremy Burns
Actually, looking at this a bit more, I'd like to pose a few questions. The general way of relating one table to another twice is that you give each a different class name - in your case Sender and Recipient. You then do a normal join, specifying the class name (User in your case) of the

Re: Cake console shell

2010-06-04 Thread euromark
PS: you would need to override startup() in all shell scripts - even the core ones... On 4 Jun., 15:27, euromark dereurom...@googlemail.com wrote: why does it bother you? :) just ignore it On 4 Jun., 13:59, Edwin edwink...@gmail.com wrote: Thanks, got it working! I forgot to add the

Query Results, Empty Array

2010-06-04 Thread DragonFlyEye
I've searched the group a bit and haven't found anything that seems to exactly solve my problem. Let me begin with the basics: This is a website which I am transitioning from an old ASP site into CakePHP. The site is driven by an MS-SQL database and being served from a Macintosh XServer running

Re: Message Model with Sender and Recipient from User-Table

2010-06-04 Thread nils
Jeremy, thanks for the link, it was a bit buried in the depths of The Book, so I didn't find it at first. Will check there now.. - Initial test wasn't working, but I'll be getting there (I hope)! ;) cheers! nils On 4 Jun., 15:28, Jeremy Burns jeremybu...@me.com wrote: Actually, looking at

Re: Query Results, Empty Array

2010-06-04 Thread Jeremy Burns
Hmmm. So you say that Cake is creating a SQL query that works, but the array that collects the results has empty elements where you would expect data? Here's a couple of suggestions. Remove recursive completely - not ideal for production, but a good check to see if it is somehow limiting it.

Removal of post

2010-06-04 Thread Jayesh Wadhwani
Hello, Per terms and conditions of Google groups please remove all postings related to me. My email is jwadhw...@gmail.com Thanks Jayesh Wadhwani Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because

solve the problem in cakephp

2010-06-04 Thread asar
when I want to see users/index page I can see the list and everything is normal but it's not display in blue color box in first four row. but if I want to see users/add page the server says the requested address was not found on this server . Check out the new CakePHP Questions site

Keine Daten in $this-data

2010-06-04 Thread Christoph
Hallo, ich habe ein großes Problem mit meinem Formular. Ich bekomme die Daten des Formulars in $this-params['form'] übergeben und nicht in $this- data. Hier der Code: print $form-create(Checkout, array( url = array(controller = checkout, action = step2),

No form data

2010-06-04 Thread Christoph
hi, i have a little bit trouble because i don't get any form data in $this- data. i only get the data in $this-params['form']. is there a way to change that? that my form: print $form-create(Checkout, array( url = array(controller = checkout, action = step2),

Re: Removal of post

2010-06-04 Thread Larry E. Masters aka PhpNut
All post directly from you have been removed per your request. If you have any further questions please direct them to google. http://groups.google.com/support/bin/answer.py?hl=enanswer=46452 -- /** * @author Larry E. Masters * @var string $userName * @param string $realName * @returns string

Validate data md5

2010-06-04 Thread Chrriss
Hi, I have a form to add a user and I use an md5 encryption when I save the password in the database. I use $validate to check if the email address is valid. If it's not, the form shows the data again with the error message but the password is not the right one in this case. It's the hashed

Re: Redirecting from javascript

2010-06-04 Thread calvin
Are you asking how to redirect to a different page in JavaScript? That's not really Cake-related, but it's window.location = 'your new page'. On Jun 3, 9:49 pm, [-Cheluis-] tangu...@gmail.com wrote: Hi! I was wondering if there is a way to redirect from one action to another via javascript. I

Re: Cake console shell

2010-06-04 Thread Edwin
Because I'm using it for email piping. When I'm running the shell it will reply the email with the CakePHP Console message. Will give the overriding startups a try.. but there must be a better solution? Thanks! On Jun 4, 3:27 pm, euromark dereurom...@googlemail.com wrote: why does it bother

Re: session related query

2010-06-04 Thread calvin
That's a browser caching problem. You can use the pragma, cache- control, and expires headers: http://book.cakephp.org/view/350/Obtaining-Request-Information If you use all 3, then that should prevent most standards-compliant browsers (and IE5 and later) from caching the page. On Jun 4, 12:26 

Re: How to Add/Remove records dyanmically...

2010-06-04 Thread calvin
Is sample code a euphemism for please write the code for me for free? Unless this is an open source project (in which case, please provide a link to the public repository where the codebase is located), don't expect others to do your work for you. If you're not going to try and solve a simple

Re: No form data

2010-06-04 Thread John Andersen
Please take your time to read the CakePHP manual at: http://book.cakephp.org/view/1390/Automagic-Form-Elements so that you understand how to use the Form helper input method! There is clearly stated that the Form helper input method expects the following parameters: input(string $fieldName,

Re: Query Results, Empty Array

2010-06-04 Thread calvin
^I'm pretty sure that debug() doesn't have a return value. So I usually just call debug($page);die;. DragonFlyEye: How many queries are in the query table? Are you sure you're looking at the right one? Is there some kind of command-line client for MS-SQL that you can use to see exactly what each

Re: No form data

2010-06-04 Thread calvin
1. Controllers are plural. So it would be 'checkouts' not 'checkout'. 2. Read the Cookbook; you're not using $form-input() correctly. On Jun 4, 6:47 am, Christoph christophwe...@googlemail.com wrote: hi, i have a little bit trouble because i don't get any form data in $this-data. i only get

Re: Query Results, Empty Array

2010-06-04 Thread Jeremy Burns
@calvin: Not sure I understand you. die(debug($page)); will return the contents of $page and then stop the code. Works every time. Jeremy Burns jeremybu...@me.com On 4 Jun 2010, at 16:24, calvin wrote: ^I'm pretty sure that debug() doesn't have a return value. So I usually just call

Re: Cookie name problem

2010-06-04 Thread calvin
What do you mean the cookie stops working? Are you not able to store new cookie data or just forgetting the old data stored before changing the cookie name? If it's the latter, that's normal. If you were saving information in $_COOKIE['cakephp'] before, and then you tell CakePHP to get that

Re: Updating One-to-Many Relations

2010-06-04 Thread calvin
I think the exception is when you have a many-to-many relationship and the 'unique' property is set (by default). Then it will delete all of the associated records in the join table before performing the add operations. On Jun 3, 7:21 am, John Andersen j.andersen...@gmail.com wrote: The saveAll

Re: How do I save a field on my User without breaking the ACL?

2010-06-04 Thread stefano
i have the same problem :( any idea?? On May 24, 9:25 pm, Jon Chin port23u...@gmail.com wrote: I tried that and have the same result.  Do I need to unbind a relationship or something? On Mon, May 24, 2010 at 2:06 PM, Filipe Teles Rodrigues filipe.t2...@gmail.com wrote: I use

DHMLX

2010-06-04 Thread Alexsandro
Hello! Personal'm starting with cake and had a question. I use DHTMLX to create windows and layouts, but they do not know how to use it in cake we need a helper? or just call in the index? Sincerely, André Alexsandro Brazil / Joinville-SC (55) (47) 8825-0133 Check out the new CakePHP Questions

Re: CakePHP development firm

2010-06-04 Thread calvin
LOL, the CakePHP community is a developers community. If you ask us for recommendations, (aside from CakeDC, as gmansilla mentioned) people are going to recommend that you go with them or their own firm. This isn't like the Magento community, where a lot of the members are end-users rather than

Re: Query Results, Empty Array

2010-06-04 Thread calvin
Yes, it does the same thing, because PHP still evaluates debug($page). I'm just saying that debug() doesn't have a return value; it just prints out the variable dump directly. Usually when people call die(expression), it's because they want die() to print out {expression} as the termination

Re: DHMLX

2010-06-04 Thread calvin
Who is they? The DHTMLX developers? A helper is just an object with a set of functions that save you time when creating your views (e.g. eliminate repetitive code, convenience functions, etc.). You might want to write a helper for DHTMLX, but it's not necessary. You probably want to start off by

Saving multiple rows of key-value pairs during a single update?

2010-06-04 Thread mwaterous
Well my last question here turned out to be between keyboard and chair, so hopefully this isn't quite as silly a question! I am learning Cake and building a custom user authentication system (who isn't?). I am trying to use two separate tables to store data, the User Model table as parent which

Re: Validate data md5

2010-06-04 Thread vekija
When you have an error on the registration form, it is a best practice to clear the password value and force the user to renter that info. So, in the controller... if($this-User-save($this-data)) { // ... whatever you do after user had registered successfully } else { // ... there was an

Re: solve the problem in cakephp

2010-06-04 Thread cricket
On Jun 4, 6:23 am, asar asarudeen1...@gmail.com wrote: when I want to see users/index page I can see the list and everything is normal but it's not display in blue color box in first four row. but if I want to see users/add page the server says the requested address  was not found on this

Query question(s)

2010-06-04 Thread Ed Propsner
I was checking out the book on complex queries and not really finding what I'm looking for. I'm trying to create a query that covers both a basic and advanced search. The form may be submitting all or just some of the options available on the page depending on what the user chooses. Once the

Re: How do I save a field on my User without breaking the ACL?

2010-06-04 Thread alaxos
Hi ! If you used the code given in the Simple Acl controlled application, it doesn't work out of the box if you save only one User's field. The parentNode() function check if the group_id field is not empty, and if it is, it returns null. This makes the Acl component think the User doesn't have

Re: Saving multiple rows of key-value pairs during a single update?

2010-06-04 Thread vekija
I think the easier way to accomplish this would be to adapt the view, like this: echo $this-Form-input('MetaUser.0.meta_key', array('type' = 'hidden', 'value' = 'activation_code')); echo $this-Form-input('MetaUser.0.meta_value', array('label' = 'Activation code')); On Jun 4, 6:48 pm,

Re: Order problem with deep association

2010-06-04 Thread vekija
Not really sure if it would work but you can try this $this-Shift-find('all', array( 'contain' = array( 'Assignment' = array( )); On Jun 4, 11:29 am, shantamg jason.galu...@gmail.com wrote: yes, that about does it.. but what if i want to order by two fields? something like:

Re: Order problem with deep association

2010-06-04 Thread vekija
Sorry about that, acidently posted before I finished :) $this-Shift-find('all', array( 'contain' = array( 'Assignment' = array( 'Person' = array( 'order' = 'Person.category_id ASC, Person.name ASC' ) ) ) )); On Jun 4, 11:29 am,

Re: Miles J Uploader help

2010-06-04 Thread bradmaxs
Hey Miles or Anyone??, I feel like I found the problem with the uploader not accepting the birthdate array and before scrapping this uploader and moving to something different or changing the datetime field (I want to try and stick to cake's automagic form elements) I am going for one last

Re: Redirecting from javascript

2010-06-04 Thread [-Cheluis-]
How to redirect to another controller/function. From html you can do something like: ?php echo $html-link('Message', array('controller'='x','action'='y',$parm); ? How can I do this from js? window.location is enough? Thanks On Jun 4, 10:43 am, calvin cal...@rottenrecords.com wrote: Are you

Re: How do I save a field on my User without breaking the ACL?

2010-06-04 Thread stefano
try with $this-data[User][group_id] = $this-Session- read(Auth.User.group_id); :) s. On May 24, 10:59 am, Jon Chin port23u...@gmail.com wrote: I'm using Auth and db ACL, but I have an action that screws up my ACL records every time.  I have ACL set up just like the Book instructs.  I'm

Re: email component - sending mail via smtp fails on own server!

2010-06-04 Thread Jonathon Musters
I would suspect that or php/apche may need to be rebuilt to include mail On 6/3/10, euromark dereurom...@googlemail.com wrote: as i mentioned above, php mails via mail() are working both cake and pure php based using my good old phpmailer from the days before cake i get a similar error

Re: Order problem with deep association

2010-06-04 Thread shantamg
yes, but now we're back to the same problem: we are sorting only the one person record inside of each assignment, and we want to sort the assignments. the programatic way you suggested works (i included what I did below), but unlike contain, Set::sort() only takes one sort parameter. if

Re: How do I save a field on my User without breaking the ACL?

2010-06-04 Thread alaxos
The point is that Session is not defined in models. So if you do like this, you will have to do it each time you want to save a User without the group_id field, in each of your controller's actions. Doing it directly in the model allows you to care about the presence of the group_id field only

Re: Validate data md5

2010-06-04 Thread alaxos
If you don't want to reenter the password, you can use a different name for the password input. For instance: View: $this-Form-input('new_password', array('type' = 'password')); Controller: if(!empty($this-data['User']['new_password'])) { $this-data['User']['password'] =

Re: Order problem with deep association

2010-06-04 Thread vekija
Try this. The code is dirty so you should refactor it :) //sort assignments by person category $data['Assignment'] = Set::sort($data['Assignment'], '{n}.Person.category', 'ASC'); //group assignments by person category //person name is used here as

Re: Validate data md5

2010-06-04 Thread calvin
I don't get that. I think that presents a false sense of security. It's best practice to use a secure connection whenever you're transmitting passwords. And if you're handling the request over secure http, then it doesn't matter if you send the password back to the user. On Jun 4, 10:08 am,

Re: Redirecting from javascript

2010-06-04 Thread calvin
I don't think you're understanding how a webpage works. JavaScript can't invoke PHP functions or any server-side functions. JavaScript is client-side. It's executed in the browser. The browser can send requests to the web server for web _pages_. That's what window.location does--it tells the

Re: Saving multiple rows of key-value pairs during a single update?

2010-06-04 Thread calvin
Did you define the relationship between User and MetaUser? i.e. in the User model: $hasMany = array('MetaUser' = array()); Because both, your approach and vekija's, should work. On Jun 4, 9:48 am, mwaterous m...@watero.us wrote: Well my last question here turned out to be between keyboard and

Re: Query question(s)

2010-06-04 Thread calvin
POST requests are generally not cached, but you can force it to be cached using the Cache-Control and Expires headers. However, I've never tried this so I don't know if the browser will still show the form submission dialog (it may need to resend the form data to check to see if the document has

Re: Query question(s)

2010-06-04 Thread Ed Propsner
Thanks Calvin, point well taken. I'll just stick with GET like I always have for searches. I tweaked the routing and got things cleaned up a bit so I guess I'm okay with it. I'm not quite sure what I was expecting in the first place? 8-) The search uses a lot of checkboxes and results in