Here is a ZSQL Method (called insert_author) which inserts into a
PostgreSQL table which has a serial column called author_id.
Arguments
surname
search_name
initials
known_name
user_id
notes
Query Template
--
insert into author
--snip--
I got help from one of our DBA's today here is what I was missing. This
in not in Bruce's Book.
INSERT INTO address (per_id,street_num,city,state,zip)
SELECT per_id,'$3','$4','$5','$6'
FROM person
WHERE last = '$1'
AND first = '$2';
$1-6 will be supplied by user input from Zope,