RE: Memoizing non-place-holding sql statements to place-holding
- From: h-taguchi@xxxxxxxxxxx
- Date: Mon, 22 Aug 2005 21:37:20 +0900
> > my @new_values = ();
> > my @place_holders =
> > map {
> > if (/^CURRENT TIMESTAMP$/) {
> > $_;
> > } else {
> > push @new_values => $_;
> > "?";
> > }
> > } @args
> > ;
....
> It's a bit of a pain, but until DBD::Informix becomes "smart"
> enough to
> detect this on its own (if that's even possible) it's
SQL::Statement can do this?
I'm lea(r)ning (to) it today, but User-Defined Functions are used differently.
Hirosi Taguti
h-taguchi@xxxxxxxxxxx
.
- Follow-Ups:
- Re: Memoizing non-place-holding sql statements to place-holding
- From: Jeff Zucker
- Re: Memoizing non-place-holding sql statements to place-holding
- Prev by Date: Re: DBD Oracle column type
- Next by Date: RE: FW: Failed DBD Oracle 1.16 make on Perl 5.8.6, DBI 1.48,Oracle 9.2.0.6, Solaris 8.
- Previous by thread: RE: Memoizing non-place-holding sql statements to place-holding
- Next by thread: Re: Memoizing non-place-holding sql statements to place-holding
- Index(es):
Relevant Pages
|
|