sybperl-l Archive

From: ddrumm at rush dot edu
Subject: Join ProblemB
Date: Oct 8 1997 12:14AM

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\"");

$dbproc->dbcmd("and PHASCII.firstname *= PHPASSWD.firstname");
$dbproc->dbcmd("and PHASCII.lastname *= PHPASSWD.lastname");
$dbproc->dbcmd("order by PHASCII.department");
$dbproc->dbsqlexec;
$dbproc->dbresults;


And it spits:

Msg 102, Level 15, State 1
Line 2
        Incorrect syntax near 'PHASCII'.
DB-Library error:
        General SQL Server error: Check messages from the SQL Server.

I've tried renaming the calls to the table to dbo.PHASCII and so forth,
but no go. I tried escaping the parenthesis, all to no avail.

Anybody have any ideas?

--
Daniel G. Drumm - ddrumm@rush.edu
Rush Presbyterian St. Luke's Medical Center - Chicago, IL
Network Division - Information Services