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 message

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 debug(

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: 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. T

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 Ap