Re: [Zope] Best way to handle SQL update with variable number of fields?

2000-09-11 Thread Dieter Maurer
[EMAIL PROTECTED] writes: The problem - I would like to populate the form with the existing values and then allow the user to change the ones they want to. Some of the fields in the database are empty and it will always be that way. The length of the update statement will change. I do

[Zope] Best way to handle SQL update with variable number of fields?

2000-09-10 Thread [EMAIL PROTECTED]
Hello, I'm creating a number of ZSQL methods to insert, update and delete records from several Oracle tables. Everything is working fine with the insert forms (creating new records) and the delete (of course). However, the best way to do the * update * without locking the user into a *very*