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
know it was there.  I know I might have a problem with getting more then
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

Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to