Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

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 = '[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
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?
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 chilling in the Monastery: (7)
As of 2015-07-31 06:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (274 votes), past polls