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.
jens
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 @
> http://homepages.strath.ac.uk/~aeu97172/h.htm
>
> 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
> 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. @
> http://homepages.strath.ac.uk/~aeu97172/
>
>
>
> ___
> Zope maillist - [EMAIL PROTECTED]
> http://lists.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>
>
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
