|
Posted by xhoster on April 7, 2008, 6:00 pm
Please log in for more thread options
> Hi,
> I have two queries -- I pass the result of the SELECT query to a stored
> procedure. The result from the SELECT query is different during every
> pass and I somehow need to remember the old value and pass that to the
> store procedure when next time the perl script runs. I would appreciate
> some help.
That is an interesting requirement. If the thing to be given to the
prepared statement on execution N is the thing returned by the select
in execution N-1, then what is to be given to the prepared statement
when N==1?
Since you are already using a database, I'd use the database to store
what needs to be stored between executions. That way you have to worry
less about what happens in case of crashes.
But most of all I'd seriously reconsider if this is really the best way
to go about solving whatever it is that I was trying to solve.
Xho
--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.
| 
XML Sitemap