lstep@mail.dotcom.fr wrote:
Hello,
I'm trying to use PostGreSQL with Zope, but I'm having problems using the SQL INSERT method in Z methods which require parameters.
For example, I make a Z SQL Method named 'foo'. In it: INSERT INTO messages VALUES (<!--#sqlvar auteur type="string"-->, 'blahblahblah', 'now', 'f')
I write the name auteur in the 'arguments' form.
Next I create a DTML document with: <form action="foo" method="GET"> Auteur: <input width="30" name="auteur" value=""><br>
why no type=text ?
<input type="submit" name="SUBMIT" value="Envoyer"> <form>
When submitting the form, it displays me a new page (generated by Zope) asking me again the auteur parameter, as if the auteur variable wasn't passed to the Z SQL method :-(
Someone posted a mail recently with an example use of INSERT, where he put '(auteur)' after the 'INSERT INTO messages' text: INSERT INTO messages (auteur) ...
When I try this, I get:
Error, pg.error: server fatal error. Please report to your db administrator.
A good to test your SQL is using psql. And upgrading to PyGreSQL 2.3 or later, which return proper sql messages
SQL used:
INSERT INTO messages (auteur) VALUES ('testing again', 'blahblahblah', 'now', 'f')
This is definitely wrong ;( something like INSERT INTO messages (auteur,title,bookdate,any_good) VALUES ('testing again', 'blahblahblah', 'now', 'f') might have worked. You may also mean current_date or current_time instead of now or now()