sybperl-l Archive

From: David Hajoglou <hojo at greenland dot i-tel dot com>
Subject: select on select
Date: Apr 14 1999 4:28PM

We are trying to put a select statement into another select statement:

my $new1 = $dbh->$sql("select cbrate from rateschedule where cbrate not
in(select cbrate from agent_cb_rate where agent_cb_rate.agent_number =
'".$in{'lkup'}."')");

Now, we know this works when we use isql directly.  However, in a script
we get the error below:

httpsd: [Wed Apr 14 10:14:49 1999] [error] Can't locate
auto/Sybase/DBlib/.al in @INC (@INC contains: /usr/lib/perl5/5.00502/i586-linux
/usr/lib/perl5/5.00502 /usr/lib/perl5/site_perl/5.005/i586-linux /usr/lib/perl5
/site_perl/5.005 . /usr/local/apache_1.3.4/  
/usr/local/apache_1.3.4/lib/perl) at/usr/u1/brianb/htdocs/ag 
ent/aginfo.cgi line 29


Any Ideas?
Thank You
David Hajoglou