|
From: Thomas G. <to...@ad...> - 2001-10-30 19:14:38
|
On Tue, 30 Oct 2001, Oscar Buijten wrote:
> So the DBD directory does not exist in perl 5.6.1
> I guess I had to 'un-rpm' or something the older version of perl before=
=20
> installing the newer.
> How can I fix this? I just copy the missing directory?
> Oops! I've just tried that! That didn't help.
>=20
> Any suggestions?
Grab DBD-Pg from CPAN and unpack it into /usr/local/src.
# cd /usr/local/src/DBD*
# perl Makefile.PL
# make=20
# make install
Then run my script again. It should work at this point.
When you've finished and got a working system we can talk about
breaking it (briefly ;-) by doing an upgrade to 7.1.3
Here is something else 7.0 can't do:
SELECT fname, lname, move_in=20
FROM tracker RIGHT JOIN client_placement=20
USING (client_id)
WHERE move_out IS NULL=20
AND dept_id =3D 1008
AND track_id =3D 1;
That's an OUTER JOIN. Very handy. Now if we can only get DROP COLMUN
I'll be satisified! ;-)
Good luck with DBD. Fire away if you get stuck.
--------------------------------------------------------------------
Saint Vincent Catholic Medical Centers =20
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst Phone: 718-818-5528=20
Behavioral Health Services Fax: 718-818-5056 =20
Residential Services Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/* Rekordmeister ist nur der FC Bayern M=FCnchen! */
--------------------------------------------------------------------
|