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