--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
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
(surname,search_name,initials,
- Original Message -
From: Richard Smith <[EMAIL PROTECTED]>
> INSERT INTO address (per_id,street,city,state,zip)
> VALUES ('SELECT per_id FROM person WHERE first = ''
> AND last = ''','','
> ...etc;
You are allowed to place literal values in a select list, so the following
often works:
Lindell Alderman wrote:
>
> > I have Zope all set, and I can run all your standard SELECT, INSERT,
> > UPDATE stuff.
> > But I have one hitch, I can't seem to figure out how to make it so an
> > end user
> > could add a name and email address without knowing about the PKEY
> > number. This is no
This is going to be a long winded questions.
Ok I have been hacking around with Zope and Pgsql for awhile now.
I am trying to learn both at the same time, not any easy task, I don't
know SQL that well. I learn by doing ,and this is really fun, kinda like
a
digital puzzle of sorts. So any way I se