|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Join ProblemB
Date: Oct 8 1997 2:15PM
ddrumm@rush.edu wrote:
>
> I'm having trouble with the syntax of a join. SybPerl doesn't care
> for the 2nd dbcmd() I issue it:
>
> $dbproc = Sybase::DBlib->dblogin($_[0],$_[1],"SIGHBASE");
> $dbproc->dbuse('MyDB');
> $dbproc->dbcmd("select distinct * from PHASCII, PHPASSWD\n");
>
> #this is a problem line
> $dbproc->dbcmd("where lower(PHASCII.firstname) like \"%$fname\"");
As others have mentioned, the problem is missing whitespace.
This would have been obvious if you had required sybutil.pl, which
defines a message handler which prints out the Sybase command buffer
as well as the error message.
Take a look at sybutil.pl, which is in the lib directory of the
sybperl distribution, and gets installed in
$PERL5LIB/site_perl.
Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
|
