[Zope-DB] looping through
Fri, 31 Aug 2001 08:05:38 -0500
I didn't see your original message, but to add rows to your DB you
need to use an 'insert' query:
Here is a query that I've used to add rows to a table called
insert into Persons_Basic values (
<dtml-sqlvar personID type=string>,
<dtml-sqlvar firstName type=string>,
<dtml-sqlvar lastName type=string>,
<dtml-sqlvar birthDate type=float>,
<dtml-sqlvar hairColor type=string>)
personID, firstName, lastName, birthDate, and hairColor are all
parameters of the query.
On Friday, August 31, 2001, at 07:56 AM, Russell Hires wrote:
> I got all of that. I want Zope/Python to do the looping part (I think).
> form for adding the new assignment is in Zope, the result will
> (through a
> couple of steps) be output in zope on a web page. I just don't know how
> cause zope/python/postgresql to add new rows to my db, once for each
> per assignment.
> According to Chris McDonough
> "Zope Corporation has established a mailing list to specifically discuss
> issues which arise when integrating Zope and various relational
> datbases --
> firstname.lastname@example.org. Any posting from "how do I?" to "but..." and the
> ever-favorite "help with ...!" is fair game. If you have an interest in
> subscribing, please visit http://lists.zope.org/ today, and sign up to
> Zope-DB list."
> Thank you for the effort to make sure I'm in the right place, but I
> think I
> am! :-)
> On Friday 31 August 2001 08:45, you wrote:
>>> I hope I'm in the right place.
>> Hardly. This list is for the Zope database, which is an
>> object-oriented database, not a relational database. I also don't
>> think you are using Python -- the Zope database is written in Python
>> and requires the Python to use it. So, unfortunately I think you
>> picked the wrong list. Try finding a newsgroup or mailing list with
>> "relational database" and "SQL" in its description. :-)
>> --Guido van Rossum (home page: http://www.python.org/~guido/)
> Zope-DB mailing list