[Zope] ZSQL update operations

[Lee Marzke]

On 12-Mar-01 Casey Duncan wrote:
> Lee Marzke wrote:
>> 
>> Hi,
>> 
>> I'm displaying a set of data from a ZSQL method.  The showStatus
>> method below works just fine.  I would now like to have a link
>> on each data item allowing an ZSQL update or delete operation.
>> 
>> Can this be done by passing args to the ZSQL method vai the
>> URL?    I'm a beginner with Zope/ZSQL btw...
>> 
>> I am partly unsure when the ZSQL method should define a parameter
>> ( for instance to pass something by a URL, does that variable need
>>   to be a paramenter )
>> 
>> Thanks,
>> 
>> Lee Marzke <lmarzke@kns.com>
>> 
>> == statusALL  DTML method ==
>> <dtml-in "objectValues('Folder')">
>>   <dtml-var showStatus>
>> </dtml-in>
>> 
>> The following method shows data where the revname column is equal
>> == showStatus DTML Method ==
>> <h3><!--#var title_or_id--></h3>
>> <table width="80%" border=0 cellpadding=5 cellspacing=0>
>> <tr><th>ID</th><th>Name</th><th>Begin</th><th>End</th><th>Status</th></tr>
>> <!--#in "show_pending()" -->
>>    <!--#if sequence-even -->
>>      <tr bgcolor="#eeeeee">
>>    <!--#else -->
>>      <tr bgcolor="#ffffff">
>>    <!--#/if -->
>>       <td><!--#var requestid --></td>
>>       <td><!--#var username --></td>
>>       <td><!--#var starttime --></td>
>>       <td><!--#var endtime --></td>
>>       <td><!--#var comment --></td>
>>       <td><a href="<!--#var
>>       "updateRequest.absolute_url()"-->">Update</a></td>
>>   </tr>
>> <!--#/in -->
>> </table>
>> 
>> ===showPending()  ZSQL method ===
>> SELECT requestid, revname, username, starttime, endtime, comment, status
>> FROM tableR <!--#sqlgroup where-->
>>   <!--#sqltest revname op=eq type=string -->
>>   <!--#and -->
>>   status = 0
>> <!--#/sqlgroup-->
>> 
>> Lee Marzke <lmarzke@kns.com>             12-Mar-01, 10:58:07
>> Kulicke & Soffa Industries
>> 2101 Blair Mill Rd                       +1 215 784-6217
>> Willow Grove, PA 19090                   +1 215 784-6014 fax
>> 
> 
> Anything you want passed to your ZSQL method must be defined as an
> argument. They come from the REQUEST object, so they can be passed
> directly from a URL defined variable.
> 

Unfortunatly, since the "Update" links are created in a loop I can't
rely on passin or pushing any variable.  I think I need a way of adding
this information onto the links URL, but I don't know how to
get this to work.




> -- 
>| Casey Duncan
>| Kaivo, Inc.
>| cduncan@kaivo.com
> `------------------>


Lee Marzke <lmarzke@kns.com>             12-Mar-01, 16:38:19
Kulicke & Soffa Industries
2101 Blair Mill Rd                       +1 215 784-6217
Willow Grove, PA 19090                   +1 215 784-6014 fax