Re: [Zope] skinscript and ZSQL

2000-12-17 Thread Steve Spicklemire
Hi Aaron, Since we communicated privately and I now have a much better understanding of your problem, I realized that my last message to the list was unclear so I thought I'd take a moment to try to clarify the 'gotchas' that got you, as I see them, so that other folks might not so easily fal

Re: [Zope] skinscript and ZSQL

2000-12-16 Thread Steve Spicklemire
This set works for me: -- WHEN OBJECT ADDED CALL sqlInsertProduct(client_name=self.id, email=self.email, rate=self.rate, last_payment=self.last_payment, primary=self.primary, services=self.services) WHEN OBJECT CHANGED STORE

[Zope] skinscript and ZSQL

2000-12-16 Thread Aaron Payne
Hi all, I'm trying to use Gadfly as storage for a Zpatterns rack. With the following skinscript trigger I can view records in the database. But I can't insert a new one. WHEN OBJECT ADDED CALL sqlInsertProduct() WITH QUERY lookup_product(client_name=self.id) COMPUTE client_name,email,rate,