[Zope] Zope Pgsql 7.0/SQL Schema HeLp!

[ozric]

--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,  I just wanted to isolate
the per_id from person during an Insert so that end users would not need
to
know it was there.  I know I might have a problem with getting more then
one
return for just first and last,  I might add more WHERE statements in
there. I am
just happy to get moving on with my little project.

Thanks for the help
Richad