[Zope] Calling a SQL method from python and storing the results

[Mike Jakowlew]

Here is what I need to accomplish:

I need to call a Z-SQL method from within python and store the result in a
variable in python. I know this could probably be done easier with ZPT's or
DTML, however the program that I've written does many things and depends on
this particular variable for the majority of the program.

My overall program:

Uploads a File (Working)
Write an entry to a MS SQL DB (Working)
Send an Email to alert user of upload (Working)

in this particular case all I need is the id of the last row in the db
before the e-mail is sent out. The e-mail itself sends a link that calls
another SQL method with ID as the parameter passed.

I've tried to use the container.id method, but that just returns the name of
the Z-SQL method.

Thanks in advance,
mjakowlew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20051124/352867c4/attachment.htm