Re: [Zope] Zope Pgsql 7.0/SQL Schema HeLp!

2000-05-22 Thread Richard Moon
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

Re: [Zope] Zope Pgsql 7.0/SQL Schema HeLp!

2000-05-22 Thread 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,