[Zope] multiple unknown parameters -> ZSQL

[Jens Vagelpohl]

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 lee.reilly@ntlworld.com 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/hmmmm.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:lee.reilly@ntlworld.com
> 
> ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,ø?º°`°º?ø,,,,
> 
> 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/
> 
> </shameless plug>
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )
> 
>