Hi,
there is not much more... The $limit and $offset is a fix value at the
moment (20 for limit, 1 for offset). But changing that values doesn't
make a difference at all. What sourcecode do you need?
Timo
On Aug 14, 1:54 pm, Jonas Schnelli <[EMAIL PROTECTED]> wrote:
> please post more code...
> especial the variables: $limit and $start
>
> On 13 Aug., 10:03, habi <[EMAIL PROTECTED]> wrote:
>
> > Hi all,
>
> > i'm using the sfDoctrine plugin as database layer. Everythings seems
> > pretty fine until i tried to get a limited result over more than one
> > table.
>
> > Here is my schema.yml
>
> > Attribute:
> > tableName: attribute
> > i18n: {class: AttributeI18n, cultureField: culture}
> > columns:
>
> > AttributeI18n:
> > tableName: attribute_i18n
> > columns:
> > name: string(200)
>
> > And i'm trying the following:
>
> > $table = sfDoctrine::getTable('Attribute');
> > $q = $table->createQuery();
> > $result = $q->from('Attribute a')
> > ->orderby('a.AttributeI18n.name ASC')
> > ->limit($limit)
> > ->offset($start)
> > ->execute();
>
> > But this results in the following error:
>
> > [Doctrine_Connection_Mysql_Exception]
> > SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.id' in
> > 'field list'
>
> > If i remove the limit/offset part of the query everything is fine.
>
> > Any help?
>
> > Timo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
