[Zope-DB] Assign query result(nextval) to variable

[Andrew Veitch]

> select nextval('project_sequence_id_key'::text);
> 
> How do I assign this obtained value to a variable that can be inserted
> into columns?

What you want to do is use currval('project_sequence_id_key') which will
give you the current value.

A

-- 
Logical Progression Ltd, 20 Forth Street, Edinburgh EH1 3LH, UK
Tel: +44 (0)131 550 3733 Web: http://www.logicalprogression.net/