[Zope] Error, Missing Input: Missing input variable, member_id

[Hamzat kamal]

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