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

[Steve Spicklemire]

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
>
>
>
>