Using DBI::DatabaseHandle#execute or DBI::DatabaseHandle#prepare it\'s not possible to run an sql script (with mutiple sql statments). It fails with the following error :
my $dblinks = \'\'; $dblinks = $dbh->selectcol_arrayref(\"select db_link from db开发者_C百科_links where ticket=\\\'LOW\\\'\");
Is there a way for DBI to connect to a RedBrick database?I don\'t see a driver anywhere, and there is very little discus开发者_开发问答sion of this.RedBrick supports ODBC, so you should be able to use
This question already has answers here: 开发者_Python百科 Closed 10 years ago. Possible Duplicate:
I am writing some Perl scripts to manipulate large amounts (in total about 42 million rows, but it won\'t be done in one hit) of data in two PostgreSQL databases.
I\'m using DBI to query a SQLite3 database.What I have works, but it doesn\'t return the columns in order.Example:
I based my code on the answer to the question Access get all tables, but am getting the following error:
I\'m trying to do this: $sth = $dbi->prepare(\'INSERT INTO table VALUES (?, ?, ?)\'); $sth->execute(开发者_StackOverflow
I have a table in a mysql-database with the fields \"na开发者_Go百科me\", \"title\", \"cd_id\", \"tracks\"
I\'m using DBI for the first time (and not long started Perl [2 weeks]) and I can\'t seem to get any results from the database. Here\'s what I have:
加载中,请稍侯......