RE: Problem reading a file and passing a variable

[Chas Owens]

On Thu, 2002-05-30 at 14:29, Lance Prais wrote:
> Janek,
>   I tried that originally with the same results.  I am perplexed to why this
> is happening, anyone have any ideas?
> 
> 
> Thanks
> Lance
> 

Try this.  I have no idea why it would work and the other wouldn't, but
it is worth a try.

      $ln =~ s/\s//g; #remove all whitespace characters
      my $get_case_text = $dbh->prepare("
              SELECT
                      a.sr_num           sr_num,
                      a.sr_title         sr_title,
                      a.sr_stat_id       sr_stst_id
              FROM
                      s_srv_req  a
              WHERE   sr_num         = " . $dbh->quote($ln)
      );


      $get_case_text->execute or $dbh->errstr;
 
-- 
Today is Setting Orange the 4th day of Confusion in the YOLD 3168
P'tang!

Missile Address: 33:48:3.521N  84:23:34.786W


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]