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

[hamzatk@3dresearch.com]

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