Re: remembering parameters
- From: xhoster@xxxxxxxxx
- Date: 07 Apr 2008 22:00:36 GMT
Sharif Islam <mislam@xxxxxxxxxxxxx> wrote:
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.
.
- References:
- remembering parameters
- From: Sharif Islam
- remembering parameters
- Prev by Date: Re: perl should be improved and perl6
- Next by Date: Comparing two files
- Previous by thread: Re: remembering parameters
- Next by thread: Comparing two files
- Index(es):
Relevant Pages
|
