Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: DBI:Sybase - Period in database name

by roho (Abbot)
on Feb 23, 2013 at 08:10 UTC ( #1020287=note: print w/replies, xml ) Need Help??

in reply to DBI:Sybase - Period in database name

Try this:

my $DBNAME = '[]'; $dbh->do("use $DBNAME");

"Its not how hard you work, its how much you get done."

Replies are listed 'Best First'.
Re^2: DBI:Sybase - Period in database name
by apu (Novice) on Feb 23, 2013 at 13:02 UTC
    Thanks, roho! That works.
Re^2: DBI:Sybase - Period in database name
by runrig (Abbot) on Feb 25, 2013 at 20:42 UTC
    This suggests to me that $dbh->quoted_identifier(..) should wrap things in brackets, not quotes, for DBD::Sybase, and so currently has a bug. Though there is also a syb_quoted_identifier atribute, which if set, should allow you to use quotes (though I've never used it). And I do now recall having to occasionally use brackets to quote some table/column names.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1020287]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (6)
As of 2016-10-23 17:44 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (301 votes). Check out past polls.