Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Perl DBI SQL Server not returning full column

by poj (Prior)
on Aug 19, 2013 at 20:00 UTC ( #1050079=note: print w/replies, xml ) Need Help??

in reply to Perl DBI SQL Server not returning full column

Any idea's?

See if this test script displays the same problem ;

#!perl use strict; use DBI; my $dbh = ..; # your connect credentials # temp test table setup my $t = '#test'; $dbh->do("CREATE TABLE $t (COL1 VARCHAR(100))"); $dbh->do("INSERT INTO $t VALUES (?)",undef,'A'x60); my ($s) = $dbh->selectrow_array("SELECT * FROM $t"); print '| ',('1234567890'x6)," |\n"; print "| $s |\n";

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1050079]
[Corion]: ambrus: Yeah - we're in that situation too, except that there is no time to do the reorganizing :-/
[LanX]: ... so my boss started a project with the newest sun servers and invited the traders to come on weekend to test it... and they were so pleased, that they forced him to keep it in production...
[ambrus]: Corion: sure, this is the long-term plan. The short term is that I have to run this ungodly mess to get results from the new input data today.
[Corion]: ambrus: Most of our "automation" is tied to process exit codes and a shell pipeline :-\
[LanX]: ... a week later they realized that one of the databases - which recorded how much the other banks due to this bank - was not correctly plugged
[ambrus]: Corion: I have no problem with exit codes and shell pipeline. My problem is that the current process requires a lot of manual intervention from me, including editing the source codes.
[ambrus]: (Also a lot of manual intervention by two or three other co-workers, who do other parts of the process.)
[ambrus]: Some of the manual part is unavoidable, but not all.
[choroba]: LanX was there a way to recover the numbers from the remaining information?
[Corion]: LanX: Ow ;)

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (12)
As of 2017-03-29 11:55 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (350 votes). Check out past polls.