Tony,
try this:
$sth = $dbh->prepare("select
ITEM_ID,
START_DATE,
END_DATE
from tableABC
where ACCOUNT = ?
and SEQ =
and DATE = ");
$sth->execute( $account, $seq, $date )
or die "Unable to execute the SQL Statement :
$DBI::errstr\n";
$sth->bind_columns(\($item, $start_date, $end_date));
while($sth->fetchrow_array) {
some code....
}
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> Hi Jeff
> Thanks for correction.
> The correct version of the code is as follows :
>
> $sth = $dbh->prepare("select
> ITEM_ID,
> START_DATE,
> END_DATE
> from tableABC
> where ACCOUNT = $account
> and SEQ = $seq
> and DATE = $date");
>
> $sth->execute
> or die "Unable to execute the SQL Statement
> : $DBI::errstr\n";
>
> $sth->bind_columns(\($item, $start_date,
> $end_date));
>
> while($sth->fetchrow_array) {
> some code....
> }
>
> Any ideas to the problem mentioned in the email
> before despite using the
> correct version of the code above ?
>
> I would be most grateful.
> Cheers
> Tony
>
> -----Original Message-----
> From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
> Sent: 21 February 2002 17:14
> To: Ho, Tony; [EMAIL PROTECTED]
> Subject: RE: DBI SQL Query
>
>
> >
> > Hi guys
> > I was wondering if you could help me.
> > I have the following SQL query on command-line and
> I get the
> > resulting data
> > :
> >
> > 1> select ITEM_ID,START_DATE, END_DATE from
> tableABC where ACCOUNT = 2435
> > and
> > SEQ = 16 and DATE = 19971208
> > 2> go
> > ITEM_ID START_DATE
> END_DATE
> > ----------------- --------------------
> ------------------
> > ABC3M 19940111
> 19991213
> > ABCBM 19960912
> 19980420
> > ABCRM 19960912
> 19980420
> > ABCSM 19960912
> 19980420
> > ABCUM 19940111
> 19980420
> > ABCN2 19990930
> 0
> > ABCEM 19960512
> 0
> > ABCEP 19990603
> 0
> > ABCBM 19960912
> 0
> > UNDIR 19940111
> 0
> >
> > (10 rows affected)
> >
> > If I put this query into the prepare statement of
> my DBI code as follows :
> >
> > $supplementary_services_sth =
> $dbh->prepare("select
> >
> ITEM_ID,
> >
> START_DATE,
> >
> END_DATE
> > from
> tableABC
> > where
> ACCOUNT = $account
> > and
> SEQ = $seq
> > and
> DATE = $date");
> >
> > $sth->execute
> > or die "Unable to execute the SQL
> Statement : $DBI::errstr\n";
> >
> > $sth->bind_columns(\($item, $start_date,
> $end_date));
>
> This looks like you are binding different data than
> you specify in the query
> above...
>
> >
> > while($sth->fetchrow_array) {
> > some code....
> > }
> >
> > After I execute my code, I appear to be obtaining
> only those rows that
> > END_DATE <> 0
> > Any ideas why the code is not picking ALL rows ?
> >
> > I would be most grateful.
> > Cheers
> > Tony
>
>
> Jeff
>
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
