Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: DBI:Sybase - Period in database name

by roho (Monsignor)
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 = '[ps_inventory.ad]'; $dbh->do("use $DBNAME");

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


Comment on Re: DBI:Sybase - Period in database name
Download Code
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2014-12-25 21:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (163 votes), past polls