To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:10AM
Subject: Re: Clarification on DBImodule
Hi John,
I am attaching thecode.
Here is the result:
$VAR1 =[
'FORD'
];
$VAR1 =[
'FORD
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
place.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:10AM
Subject: Re: Clarification on DBImodule
Hi John,
I am attaching thecode.
Here is the result:
$VAR1
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
Subject: Re: Clarification on DBImodule
Hi John,
I am attaching thecode
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
.
- Original Message -
From:ramesh thangamani
To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:10AM
Subject: Re: Clarification on DBImodule
Hi John,
I am attaching thecode.
Here is the result:
$VAR1 =[
'FORD
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:
my @bind1
Hard to say without some of the orginal code could be a number of things.
Do you have raiserror or pringerror set on the handle. If you are only
printing an error you may not see it and you end up just rereading the
cached data from the last query.
Post you code so we can have a look at
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 AM
Subject: Re: Clarification on DBI module
Hi John,
I
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
10 matches
Mail list logo