Please run 'perldoc DBI' and read the fine manual. There are several
examples in there. "Programming the Perl DBI" from Oreilly would be another
good investment, if you read it.
One hint: $! does _not_ contain the DBI error message, use $DBI::errstr
instead.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 7:47 AM
Subject: RE: sql table joins
> Thanks for the reply. I know that your suggestion will work but how do I
> construct the prepare statement in DBI
> If I do something like
> $dbh = DBI->connect ('dbi:ODBC:TotalBoards', 'user', 'password') or die
> "could not CONNECT $!";
> $dbh_aml = DBI->connect ('dbi:ODBC:AML', 'user', 'password') or die "could
> not CONNECT $!";
>
> $sth = $dbh->prepare(qq{SELECT TotalBoards.EMC_PN FROM TotalBoards,
> AMLMaster WHERE TotalBoards.SYMPTOM_CODE LIKE ? AND TotalBoards.EMC_PN =
> AMLMaster.AMLPN AND TotalBoards.REC_DATE BETWEEN ? AND ?}) or die
"Couldn't
> prepare statement: " . $dbh->errstr;
>
> I get an error "invalid object name AMLMaster". This is I guess because
$dbh
> is the connection to TotalBoards and knows nothing about the AMLMaster
> table. I have another $dhh_aml connecting to AMLMaster. My question is how
> do you write a prepare statement as above that works. Can you get $dbh to
> connect to both tables at the same time???
> Willie
>
>
> Willie McSweeney
> Memory Component Engineer
> EMC,
> Ovens,
> Co.Cork, Ireland.
> Tel +00353-21-4281412
> Fax +00353-21-4281898
> Email <[EMAIL PROTECTED] >
>
>
> > -----Original Message-----
> > From: Sterin, Ilya [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 01, 2001 3:19 PM
> > To: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] '
> > Subject: RE: sql table joins
> >
> > You sure can, that's just a simple join, but you have to also use the
> > table2
> > in the from clause. Like this...
> >
> > SELECT table1.failed_parts FROM table1, table2 WHERE table1.failed_parts
=
> > table2.valid_parts;
> >
> > Ilya Sterin
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Sent: 05/01/2001 8:04 AM
> > Subject: sql table joins
> >
> > Hi,
> > I am using perl DBI to access an sql server database.
> > One table has component part numbers that have failed, keyed in by
> > operators. I need to read in and count these which is no problem but I
> > also
> > need to compare them with an approved parts table to make sure that they
> > are
> > valid part numbers. Currently I am doing this by reading the failed
> > parts
> > into a hash and then using the hash keys as placeholders to query the
> > parts
> > valid table.
> > Is it possible with DBI to do something like
> > SELECT table1.failed_parts FROM table1 WHERE table1.failed_parts =
> > table2.valid_parts
> >
> > thanks Willie
> >
> >
> > Willie McSweeney
> > Memory Component Engineer
> > EMC,
> > Ovens,
> > Co.Cork, Ireland.
> > Tel +00353-21-4281412
> > Fax +00353-21-4281898
> > Email <[EMAIL PROTECTED] >
>
