On Sat, 7 Apr 2001, [iso-8859-1] Honey George wrote:
> I have a problem in database connectivity in Zope
> with Postgres. If anybody can help me in this regard
> please reply asap.
> I want to insert a row into a tabel, get a unique
> id from the table and make another entry into another
> table.I am able to insert into the forst table and
> retrieve the unique ID. But while trying to insert
> into the next table, it says no value for the unique
> id retireved.
> Expecting a solution.
You have two tables:
CREATE TABLE A (id SERIAL, name TEXT);
CREATE TABLE B (id INT, name TEXT);
You're able to insert the first table:
ZSQL Method: INSERT_A:
INSERT INTO A (name) VALUES ('foo');
and retrieve the unique value:
ZSQL Method: GET_LAST_A:
(or maybe you say something like SELECT max(id) FROM A, though
the above is faster & safer)
and you want to insert into the second table with that retrieved value:
ZSQL Method: INSERT_B:
INSERT INTO B (id, name)
VALUES ( <dtml-var value_of_A >, 'foo');
and it 'says no value for the unique id retrieved' ?
Where does it say this? Are sure you're passing the retrieved last value
to your GET_LAST_A.
It would help to post your ZSQL methods and your controlling DTML method.
Joel Burton <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
Zope-Dev maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -