and did you tried to drop your table "Attribute" and export it again?
is there a column field id? (check with phpMyAdmin)
On 14 Aug., 14:49, habi <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
