--snip--
Yes, I like the Idea of picking from a list if you get a return > 1.
off topic:
The main point of this whole little project was to design a SQL
database and make a Web interface to it. One of my main goals
was to learn the how and why's of SQL. My Zope skill are sub par
also, so
ozric wrote:
> 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 from person
> WHERE last = '$1'
> AND first = '$2';
>
> $1-6 will be supplied by us
