On Fri, May 1, 2009 at 9:14 AM, Nate Abele wrote:
> This may or may not fix your problem, but your query syntax is wrong.
Thanks, Nate. Yes, after really digging around, including an attempt
to upgrade, I figured out there was a syntax issue. I was able to get
it working for now, but at least I
Date: Thu, 30 Apr 2009 11:10:16 -0400
From: Randal Rust
To: NYPHP Talk
Subject: [nyphp-talk] Help with a CakePHP View
[snip]
$whereClause = '`District`.`id` = "' .
$this->mrClean->sql($this->passedArgs[0]) . '"';
$this->set('district', $thi
On Thu, Apr 30, 2009 at 4:17 PM, Daniel Convissor
wrote:
> But what's the difference between the two types of records?
It ended up, for now at least, not having anything to do with the SQL
queries. After working from the end of the process back to the very
beginning, I found that the error was h
On Thu, Apr 30, 2009 at 03:13:40PM -0400, Randal Rust wrote:
>
> Yeah, already did that too. I even modified the *broken* record to see
> if I could get it to work. No luck.
But what's the difference between the two types of records?
> > A possibility is that the query is doing an (inner) JOIN
On Thu, Apr 30, 2009 at 3:07 PM, Daniel Convissor
wrote:
> So chances are the data inside the table is the problem, not the query.
> Do a very careful comparison of a record that works vs one that doesn't.
Yeah, already did that too. I even modified the *broken* record to see
if I could get it t
On Thu, Apr 30, 2009 at 02:46:00PM -0400, Randal Rust wrote:
>
> You owe me a beer:)
Cool! Hey, double or nothing...
> I've checked all of that. What's even more strange is that I found out
> that for 3 of the 20 records the view will actually work. The others,
> no luck.
So chances are the d
On Thu, Apr 30, 2009 at 2:37 PM, Daniel Convissor
wrote:
>> $whereClause = '`District`.`id` = "' .
>> $this->mrClean->sql($this->passedArgs[0]) . '"';
>> $this->set('district', $this->District->find($whereClause));
> I'll bet you a beer that it's because there's no record in the database
> with
On Thu, Apr 30, 2009 at 11:10:16AM -0400, Randal Rust wrote:
>
> $whereClause = '`District`.`id` = "' .
> $this->mrClean->sql($this->passedArgs[0]) . '"';
> $this->set('district', $this->District->find($whereClause));
...
> If I remove $whereClause from the second line, the view works. But I
> get
We have inherited a Cake app that needs to be up and running by the
end of next week. I downloaded the application and installed it
locally. While running through testing, I discovered that some things
work, and some don't. The particular piece of code that is being
troublesome is this:
$whereClau
