Put it in the ZSQL Method; that way we can see *exactly* what it gets. Then: * can you test the ZSQLMethod (with the test tab) and have it work? * can you call the ZSQLMethod w/a hand-crafted URL and does it work? Don't understand the question about an if block? What are you talking about? Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant

-----Original Message----- From: Wayne Pascoe [mailto:wayne.pascoe@ehsrealtime.com] Sent: Wednesday, March 13, 2002 8:42 AM To: Joel Burton Subject: Re: [Zope] Inserting values into db - problems

On 13/3/02 1:26 pm, "Joel Burton" <joel@joelburton.com> wrote:

...

Hmm. I don't see anything wrong.

Try putting a <dtml-raise> in your method with that will show you the value of "client". It might be obvious once you see what it thinks client is.

BTW, small point: now() is deprecated syntax in PostgreSQL. In the future, you want to use CURRENT_TIMESTAMP (not a function, no parens), which is the SQL standard compliant.

Stupid question - Where would I put the dtml-raise ? Does it go in the dtml-document that calls the Z SQL method or does it go in the Z SQL method ?

Also, do I have to use an if block like in the example at Zope ?

Thanks,

-- Wayne Pascoe <wayne.pascoe@ehsrealtime.com>

The price of freedom is eternal vigilance - Thomas Jefferson