Kamal, I've got an early draft of a chapter of an upcoming book that deals with LoginManager. If you promise not to redistribute it, I can send you a copy. -steve On Monday, November 26, 2001, at 08:49 AM, <hamzatk@3dresearch.com> wrote:

Kamal,

When you tested it, did you put in a value for all three arguments?

Hello Steve, When executed, it actually displayed a form asking me to enter the values for the variable which I did. It displayed the error after clicking on the submit query button.

regards. kamal

On Friday, November 23, 2001, at 01:54 PM, Hamzat kamal wrote:

Hi,

I intend to use Login Manager for user authentication to archive folder on my website. Then I was able to lay my hands on a sample written by dlpierson : Login Manager with an SQL database;

http://www.zope.org/Members/dlpierson/sqlLogin

I followed this strictly but when I was about to test it, I was experiencing problem with this particular Z MySql Method SQL_add_use. The Method has 3 arguments :(member_id, password, member_email).

INSERT INTO member_authorization VALUES (<dtml-sqlvar member_id type=string>, <dtml-sqlvar password type=string>, <dtml-sqlvar member_email type=string>)

<dtml-var sql_delimiter>

INSERT INTO member_role_map VALUES (<dtml-sqlvar member_id type=string>, 'Member')

<dtml-var sql_delimiter>

INSERT INTO member_statistics VALUES (<dtml-sqlvar member-id type=string>, NULL, NULL)

<dtml-var sql_delimiter>

INSERT INTO member_profile VALUES (<dtml-sqlvar member_id type=string>, NULL, NULL)

SQL used: Could not render the query template!

Traceback (innermost last): File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\WebSite\lib\python\Zope\__init__.py, line 226, in zpublisher_exception_hook (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_test) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 400, in manage_test (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 378, in manage_test (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 486, in __call__ (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\DocumentTemplate\DT_String.py, line 544, in __call__ (Object: <string>) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\sqlvar.py, line 171, in render (Object: member_id) Missing Input: (see above)

help to look at it for any assistance you can render.

Thanks.

kamal

Ack.. I should've looked more closely. It's member_id, not member-id! -steve On Monday, November 26, 2001, at 08:49 AM, <hamzatk@3dresearch.com> wrote:

INSERT INTO member_role_map VALUES (<dtml-sqlvar member_id type=string>, 'Member')

<dtml-var sql_delimiter>

INSERT INTO member_statistics VALUES (<dtml-sqlvar member-id type=string>, NULL, NULL)

<dtml-var sql_delimiter>

INSERT INTO member_profile VALUES (<dtml-sqlvar member_id type=string>, NULL, NULL)

SQL used: