[Omaha.pm] Changing the current database in DBI

[Miller, Scott L (Omaha Networks)]

Have you tried escaping the '-'?  Various characters need to be escaped
when they are part of an sql query/command...   Since I haven't had to
do much with SQL from perl, I'm not entirely sure how to go about it,
but I'm guessing a single \ character is probably not going to do it
correctly, but I could be wrong.

-Scott

-----Original Message-----
From: omaha-pm-bounces at pm.org [mailto:omaha-pm-bounces at pm.org] On Behalf
Of Ryan Stille
Sent: Wednesday, August 24, 2005 2:13 PM
To: Perl Mongers of Omaha, Nebraska USA
Subject: Re: [Omaha.pm] Changing the current database in DBI

Kenneth Thompson wrote:
> Shot in the dark here- but is it a DBI issue, or an SQL
> issue? Most ANSI compliant sql db's use [] to enclose object
> names which don't comply...
> so I'd try :
> 
> $dbh->do("USE [$database]");

Thanks, but that didn't work either.

Any other ideas?  By backups are going to fail again tonight unless I
get this figured out...

-Ryan

_______________________________________________
Omaha-pm mailing list
Omaha-pm at pm.org
http://mail.pm.org/mailman/listinfo/omaha-pm