List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 14 1999 10:08am
Subject:Re: Perl
View as plain text  
On Tue, 1999-09-14 10:53:48 +0100, A. Brandic wrote:
> I have a perl script, which connects to Mysql datase. The select 
> statement is as follows:
> 
>  my $sth = $dbh->prepare( qq{
>                 SELECT code, table2.id
>                 FROM codes, table2
>                 WHERE something="$something" AND codes.id=table2.id
>             }) || die "Can't prepare statement: $DBI::errstr";
> 
> Now to print code I do ,  print ($code);  which is fine.

There must be some more DBI calls present like fetchrow_array and
bind_col.  Otherwise $code wouldn't have the right values!

Better show us more of the code that you've tried, and what errors or
results you get, - then we maybe can help!

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
any front-ends for MySQLRajesh Fowkar14 Sep
  • PerlA. Brandic14 Sep
    • Re: PerlMartin Ramsch14 Sep
      • Re: PerlA. Brandic14 Sep
        • Re: PerlMartin Ramsch14 Sep
  • Re: any front-ends for MySQLMike Machado14 Sep