[Zope] login with a login page [Q]

[Ross J. Reedstrom]

On Wed, Nov 17, 1999 at 03:20:36PM -0300, Bruno Mattarollo wrote:
> Hello..
> 
>     Thanks..
> 
>     I have downloaded and installed it on a temporary folder. Now I am
> trying to make it work, but I have an annoying problem... Our user tables
> are "splitted" -some designer would say normalized (i presume that is the
> translation in english)- ;-) and I cannot insert user data over one ZSQL
> method. Anyone has some other way to insert data for the UserDB
> "sqlAddQuery" method?
> 

I think what you're missing is the sql_delimiter variable. That'll
let you do more than one SQL query inside a ZSQL method. The only 
restriction is that only one of the SQL queries can be a SELECT: i.e.
return anything.

Used as so:

UPDATE some_table SET some_field = <dtml-var some_value> 
 WHERE some_other_field = <dtml-var some_other_value>

<dtml-var sql-delimiter>

UPDATE some_other_table SET some_field = <dtml-var some_value> 
 WHERE some_other_field = <dtml-var some_other_value>

HTH,
Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005