[Zope-DB] looping through

Steve Spicklemire [email protected]
Fri, 31 Aug 2001 08:05:38 -0500


Hi Russell,

	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 
Persons_Basic:

  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.

-steve

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). 
> The
> 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 
> to
> cause zope/python/postgresql to add new rows to my db, once for each 
> student
> per assignment.
>
> According to Chris McDonough
> (http://www.zope.org/Documentation/ZWN/ZWN-2001-08-31)
> "Zope Corporation has established a mailing list to specifically discuss
> issues which arise when integrating Zope and various relational 
> datbases --
> [email protected] 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 
> the
> Zope-DB list."
>
> Thank you for the effort to make sure I'm in the right place, but I 
> think I
> am! :-)
>
> Russell
> 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
> [email protected]
> http://lists.zope.org/mailman/listinfo/zope-db