dbi
DBI::Sybase data-conversion resulted in overflow
I am writing a Perl script that is using the DBI module and is connecting to a Sybase DB. I am calling a stored procedure (one that I don\'t have access to so I cannot post sample code) and when I get[详细]
2023-03-17 15:24 分类:问答text truncated using perl DBI insert
The problem is that DBI\'s insert leaves long string truncated when inserting to MS SQL server. Here are my codes:[详细]
2023-03-16 14:46 分类:问答Perl DBI: how to see failed query with bound values?
This is a standard inserting example from DBI manual: my $query = q{ INSERT INTO sales (product_code, qty, price) VALUES (?, ?, ?)[详细]
2023-03-15 14:07 分类:问答DBI begin_work doesn't work with stored procedure calls
I am trying to make a call to a stored procedure from with in a transaction in its simplified form: my $dbh= DBI->connect(............);[详细]
2023-03-15 02:59 分类:问答Perl Array Dereference Problem with DBI::fetchall_arrayref
I\'m a Perl newbie and am having issues with dereferencing an array that is a result of fetchall_arrayref in the DBI module:[详细]
2023-03-14 15:00 分类:问答Repeated last row of query
I am using ruby-dbi to access a MS SQL database. The problem is th开发者_运维知识库at whenever I select more than one row from the DB, the result contains correct number of items, but all of them are[详细]
2023-03-13 21:14 分类:问答Simple Perl Script (Total Perl Noob, just starting out) [closed]
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari[详细]
2023-03-09 12:16 分类:问答Having an SQL SELECT query, how do I get number of items?
I\'m writing a web app in Perl using Dancer framework. The database is in sqlite and I use DBI for database interaction.[详细]
2023-03-09 04:40 分类:问答A simple error in perl using dbi
I have a error in my prepare statement $sqlst = $dbh->prepare(\'SELECT * FROM starter_trot WHERE UserId = 2345\' ) or die \"Couldn\'t prepare statement: \" . $dbh->errstr;[详细]
2023-03-08 11:49 分类:问答dup entry when doing insert into mysql from perl
i\'m doing an insert into a mysql db from perl. i\'m getting a duplicate error after the 1st insert. here is the code i\'m using for the insert. i\'m pulling an id from a json response. i have output[详细]
2023-03-07 12:27 分类:问答