22 May
2000
22 May
'00
7:07 p.m.
--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