[Zope] delete multiple records sql python etc

Garry Steedman gs@styrax.com
Thu, 6 Dec 2001 11:17:51 +0000


Hi Todd,

at the risk of being gratuitous, wouldn't it be easier to make a 
primary key on user_accounts something like user_accounts_id ?

cheers,

Garry

On 5 Dec 2001, at 22:49, Todd Graham wrote:

From:           	"Todd Graham" <tgraham@speakeasy.net>
To:             	<zope@zope.org>
Subject:        	[Zope] delete multiple records sql python etc
Date sent:      	Wed, 5 Dec 2001 22:49:57 -0800

> I've looked through the archives and seen similar posts but none of
> the replies seem to solve my problem.  Here goes...
> 
> I've got a  table called user_accounts that has user_id, application,
> username that make up the primary key, this is a child table to the
> user_info table which has user_id as the primary key.
> 
> As part of the application I want my users to be able to delete
> multiple rows from the user_accounts table  that are displayed in a
> form via a zsql method that looks like :
> 
> select * from user_accounts
> where user_id = <dtml-sqlvar user_id>
> 
> Based on the result sets of the sql method I build a form that lists
> the username, user_id, application etc, with one checkbox for each
> record.
> 
> My question is how do I pass the all the values from one or more rows
> to a python script based on whether or not the box is checked.  I've
> tried several combinations of using record(s) converters and list
> converters but at this point I'm stumped.
> 
> 
> Thanks in advance,
> 
> Todd
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )


+-------------------------------------------+
  Garry Steedman      mailto:gs@styrax.com  
  Styrax Associates  http://www.styrax.com/ 

  "The Good Man has no shape."            
+-------------------------------------------+