Wednesday, October 29, 2008

Re: Find First doesn't append limit 0,1?

Hi Martin,

I tested my app on another cake installation (same version), et voilá,
the "limit 1" is appended...so it seems that there is something odd
going on with my installation...also weired: the debug tells me that
the resulting query is
SELECT TableNick.my_integer_field FROM my_table TableNick WHERE 1 = 1
ORDER BY my_integer_field DESC
(as said in my first post), but "affected" and "num. rows" is both
"1"...so i guess that there is no real problem, just confusing debug-
output..for some reason.
Whatever, thanks for your answer, seems the problem i was afraid of
doesn't really exist :)

On 24 Okt., 10:23, "martin.westin...@gmail.com"
<martin.westin...@gmail.com> wrote:
> Hi leberie,
> I make a quick query like yours and looked at the sql debug.
> I have "LIMIT1" at the end of the query no matter what I do.
> (find('first') empty, and with only a field defined and the both
> field and order)
>
> I am on rc3 so if this was a bug in rc2 it has been fixed. rc3 is also
> a lot faster so you may want to update to get the benefits of that
> aswell.
> There are a few bugs in rc3 though. At least a few can be irritating
> since they delete data for you if you are unlucky.
>
> /Martin
>
> On Oct 24, 9:38 am, leberle <leberkne...@gmx.de> wrote:
>
> > *push*
>
> > just wanna know if this is normal?
--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: