On 18 July 2012 12:33, Ashraf Mansour <ad...@aqar-riyadh.com> wrote:
> *Hi, All:*
> *
> *
> *Having these two tables*
>
> *db.define_table(*
> * 'salescompany',*
> * Field('name') )*
> *
> *
> *db.define_table(*
> * 'salescompany_user',*
> * Field('user_id', db.auth_user , unique = True ),*
> * Field('salescompany_id', db.salescompany ) )*
>
> *in these three lines*
>
> * current_user_id = auth.user.id*
> * *
> * xsalescompany_id=db(db.salescompany_user.user_id ==
> current_user_id).select(db.salescompany_user.salescompany_id).first()*
> * *
>
Try
*xsalescompany_id=db(db.salescompany_user.user_id ==
current_user_id).select(db.salescompany_user.salescompany_id).first().id
.first() brings you the full record.
Regards
Johann
*
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
