[Zope] zope + sql

[Duncan Booth]

> 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.
> 
I did something similar a while back. I display the results of the query, and 
each record has an 'approved' field that may be set to 0 or 1.

The SQL method to do this looks like:

Parameters: fldId fldApproved:int=1
Body:
	UPDATE O_Fixtures
	SET fldApproved = <dtml-sqlvar fldApproved type=int>
	<dtml-sqlgroup where required>
	<dtml-sqltest fldId multiple type=int>
	</dtml-sqlgroup>

The form displays each record, and includes one column in the output that 
looks like:
  <dtml-unless fldApproved>
    <td><INPUT type=checkbox name="fldId:List"
      value="&dtml-fldId;"></td>
  </dtml-unless>

The primary key for each database entry is the value fldId. When the form is 
submitted it includes a variable fldId which is a list of the ids of all records to be 
updated. The SQL method will expand to apply the update to a single record or 
all the selected records as appropriate.

for example, if record 2 is selected the SQL looks like this:
     UPDATE O_Fixtures SET fldApproved = 1 where fldId = 2
but if records 2, 3, and 4 are selected the SQL looks like:
     UPDATE O_Fixtures SET fldApproved = 1 where fldId in (2, 3, 4)

-- 
Duncan Booth                                             duncan@dales.rmplc.co.uk
int month(char *p){return(124864/((p[0]+p[1]-p[2]&0x1f)+1)%12)["\5\x8\3"
"\6\7\xb\1\x9\xa\2\0\4"];} // Who said my code was obscure?
http://dales.rmplc.co.uk/Duncan