Calling a SQL method from python and storing the results
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
Am Donnerstag, den 24.11.2005, 13:04 -0500 schrieb 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.
ou contraire, its much more easy in python.
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.
This is a bit problematic with MS SQL since it does not have sequences for easy access to automatically generated ids. You might work around that by doing the insert with a stored procedure, returning the id of your insert.
I've tried to use the container.id method, but that just returns the name of the Z-SQL method.
ZSQL methods are high level above the database and simply dont know about such internals. If your SQL statement however returns rows, you can happily retrieve it with your method.
Thanks all, I figured it out: ## GET last entry in db and obtain ID ## Find_Last_ID is my ZSQL method ## the [0][0] part is record_number/record_item repectively ## I only have one record in this method's return so I use [0] [0] get_last_id = container.Find_Last_ID().tuples()[0][0] On 11/24/05, Mike Jakowlew <mjakowlew@gmail.com> wrote:
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
participants (2)
-
Mike Jakowlew -
Tino Wildenhain