[Zope] zope + sql

[William Herring]

I'll try. 

I have a list of records from a single sql table that are viewed by the 
browser using sql SELECT.  I would like to go down and 'check' or mark 
certain specific records.  Then, for only the records that are 
'checked', I would like to use sql UPDATE to replace the a value for one 
of the variables.  The value replaced for that variable would be the 
same for all of the marked records.

Steve Drees wrote:

> I'm not following your description of the problem.
> Can you give a more specific example?
> 
>> -----Original Message-----
>> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
>> William Herring
>> Sent: Tuesday, April 17, 2001 7:49 AM
>> To: zope@zope.org
>> Subject: [Zope] zope + sql
>> 
>> 
>> I hope someone has an example or suggestion.
>> 
>> Using Znolk, I SELECT from a table and the list is viewed.
>> However, I would
>> like to choose certain records (mark them  from the viewed list) and then
>> change a variable of only the marked records to a single new
>> value.  The new
>> and old variable values are finite, they could come from a pull down list.
>> 
>> So the idea would be to show the  list from SELECT, but have an pull-down
>> menu of new values at the top of the page that should be replaced for the
>> variable to edit.  The user would choose the new value from the pull-down
>> and then go down the page and mark each record for which that
>> value would be
>> UPDATEed in the table
>> 
>> Once this is done the values would be passed back to sql and
>> UPDATE used to
>> replace the old values.  I'm not quite sure how to do this either.  Do you
>> have a loop, where inside the loop the UPDATE is goes through each marked
>> record, or do you loop inside the
>> 
>> UPDATE tablename set
>>     variable=newvalue
>>    where ----loop here with or's------
>> 
>> Any suggestions or similar examples would be appreciated.
>> 
>> --
>> ========================================
>> William Herring
>> Beef Cattle Genetics
>> S-132 Animal Science Research Center
>> University of Missouri, Columbia 65211
>> voice:573.884.6860
>> fax:573.882.4798
>> ========================================
>> 
>> 
>> _______________________________________________
>> 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 )
>> 

-- 
========================================
William Herring
Beef Cattle Genetics
S-132 Animal Science Research Center
University of Missouri, Columbia 65211
voice:573.884.6860
fax:573.882.4798
========================================