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:
> 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 Reilly
> mailto:[EMAIL PROTECTED]
> HAVE SKILLS; WILL TRAVEL.
> 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 -
> http://lists.zope.org/mailman/listinfo/zope-dev )
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -