At 12:19 PM 3/27/01 +0200, Bertrand Croq wrote:
>  I am currently using LoginManager to authenticate users from a MySQL 
>database. I followed the tutorials and it works quite well; but there are 
>other data associated with users in the database that I would like to use in 
>Zope. I have found a solution but I think it is quite complicated:
>- first, I added SQL_id_user (ZSQL-method) in the acl_users:
>select id_user
>from user
>where <dtml-sqltest username column=user_name type=string>
>- then, I added id_user (DTML-method) in the acl_users:
><dtml-in expr="SQL_id_user(username=username)">
>  <dtml-return id_user> 
>- now, when I want to get the id_user value associated with the current
>I need to do:
><dtml-with REQUEST>
> <dtml-var
>  expr = "AUTHENTICATED_USER.id_user(
>  )"
> >
>Isn't there an easier way to get the id_user value?

Yes, there is.  Get rid of the "id_user" DTML method and add the following
to a SkinScript method inside your UserSource:

WITH QUERY SQL_id_user( COMPUTE id_user

You should then be able to do "AUTHENTICATED_USER.id_user" to retrieve the

Zope-Dev maillist  -  [EMAIL PROTECTED]
**  No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to