Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Join ProblemB
Date: Oct 8 1997 2:15PM
> 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($_,$_,"SIGHBASE");
> $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
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler