[Zope] Pointer to ZSQL Method using the UPDATE call

McDonnell, Larry lmcdonnell@protonenergy.com
Thu, 1 Aug 2002 15:27:32 -0400


Hi,

I have been poking around to try to find the proper syntax to do an UPDATE
within and ZSQL Method. I will need to update several fields within the
call. I tried using the following:

update  field_service_log 
 set  <dtmlsql-var caller_name type="string">
where <dtml-var service_log_num = service_log_num>
 
It will save but produce an error. TIA

Larry McDonnell

Proton Energy Systems
50 Inwood Rd.
Rocky Hill, CT 06067
(860) 571-6533 ext. 531
Email:lmcdonnell@protonenergy.com
www.protonenergy.com