nd execute because the record buffer in
the statment handle is not cleaned out because no execute took place.
- Original Message -
From: ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:10AM
Sub
is working correctly as it is written by the way.
You get the same results for the second execute because the record buffer in
the statment handle is not cleaned out because no execute took place.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@pe
On Thu, May 10, 2007 at 02:50:10PM +0200, Peter J. Holzer wrote:
> On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote:
> > On your execution without a bound value, are you actually looking for rows
> > where the empno column is null? If so, try this:
> >
> > instead of
> > my @bind1 = ();
> > try:
get the same results for the second execute because the record buffer in
the statment handle is not cleaned out because no execute took place.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09
On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote:
> On your execution without a bound value, are you actually looking for rows
> where the empno column is null? If so, try this:
>
> instead of
> my @bind1 = ();
> try:
> my @bind1 = (undef);
>
> Otherwise, what exactly are you looking for?
As I
orking correctly as it is written by the way.
You get the same results for the second execute because the record buffer
in the statment handle is not cleaned out because no execute took place.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@perl.org
lts for the second execute because the record buffer in
the statment handle is not cleaned out because no execute took place.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:10
Thanks for your comments. May be i guess before calling execute i should
check if the query has bind variables and whether they are passed otherwise i
should error out.
Jonathan Leffler <[EMAIL PROTECTED]> wrote:
On 5/9/07, ramesh thangamani <[EMAIL PROTECTED]> wrote:
Can you please
uot;
To: ;
Sent: Wednesday, May 09, 2007 3:09 AM
Subject: Clarification on DBI module
> Hi,
>
>Can you please clarify my doubts regarding DBI perl module used for
> database connection.
>
> In my environment I am using single module to prepare and execute the sql
> q
On 5/9/07, ramesh thangamani <[EMAIL PROTECTED]> wrote:
Can you please clarify my doubts regarding DBI perl module used for
database connection.
In my environment I am using single module to prepare and execute the sql
queries. The sql query can have bind variables or they may not have. In
correctly as it is written by the way.
You get the same results for the second execute because the record buffer in
the statment handle is not cleaned out because no execute took place.
- Original Message -
From: ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTEC
.
cheers
John Scoles
- Original Message -
From: "ramesh thangamani" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2007 3:09 AM
Subject: Clarification on DBI module
Hi,
Can you please clarify my doubts regarding DBI perl mod
Hi,
Can you please clarify my doubts regarding DBI perl module used for
database connection.
In my environment I am using single module to prepare and execute the sql
queries. The sql query can have bind variables or they may not have. In order
to improve performance i used prepare() and
13 matches
Mail list logo