RE: [Zope] Pointer to ZSQL Method using the UPDATE call

I'm guessing that what you really mean is something like: update field_service_log set caller_name = <dtmlsql-var caller_name type="string"> where service_log_num = <dtml-var service_log_num> you have to specify the database fields to be updated (and compared in the where statement) outside of the <dtml-var>. Charlie

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