this could be done in python in either an external method or python
script/method. you can execute arbitrary SQL (which you would dynamically
generate in python) on a database connection using the "query" method that
is part of every database adapter.

you need to

- get a handle to your database connection by *calling* the database
connection you have in your ZODB, like "db_conn = self.mydbconnection()"

- once you have constructed the string carrying the SQL for one update
statement you can pass it as argumant to the query method on the database
connection, like "result = db_conn.query(sql_string)"

looking at that page you put up you will have to create a SQL string for
every student shown on the page and pick the correct variables from REQUEST
for the SQL update statement.


on 1/9/01 17:10, Lee at [EMAIL PROTECTED] wrote:

> Hi,
> As usual, I'm finding this one hard to explain... so I've described it
> with the aid of a diagram @
> I realise that this may be more of a burden on your time than a normal
> request... but I'm hoping that some of you have met similar problems
> before and can suggest the best way round the problem.
> Any comments would be greatly appreciated.
> Thanks very much,
> Lee
> --
> Lee Reilly
> ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,
> I'm currently looking for an internship in the USA
> in the field of web development. Ideally, I'm looking
> for a placement for 3 to 18 months. Can you help?
> More details, my resume, etc. @
> </shameless plug>
> _______________________________________________
> Zope maillist  -  [EMAIL PROTECTED]
> **   No cross posts or HTML encoding!  **
> (Related lists - 
> )

Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to