Re: Error, Missing Input: Missing input variable, member_id
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
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
Oops.. Sorry folks.. That was obviously not meant for the whole list. <shame.. shame.. shame.. > -steve On Monday, November 26, 2001, at 08:51 AM, Steve Spicklemire wrote:
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
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:
participants (2)
-
hamzatk@3dresearch.com -
Steve Spicklemire