Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2017-02-23 03:23 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (338 votes). Check out past polls.