Re^2: DBI::Sybase sometimes returns nothing, but does not generate an error -> how can I catch this?

Hi All,

I might have found a solution to this (it's hard to test as it never fails when called from a shell). However, after having called $sth->execute(), I now use the following:

if ($sth->{NAME}->[0] ne 'ent_id') {
    FATAL("  No valid entities! Need to exit");
    exit 99;
}
[download]

I'll see if this solves my problem, but logically seen, it "should"

Cheers, Sven

Comment on Re^2: DBI::Sybase sometimes returns nothing, but does not generate an error -> how can I catch this? Download Code

Replies are listed 'Best First'.
Re^3: DBI::Sybase sometimes returns nothing, but does not generate an error -> how can I catch this? by mpeppler (Vicar) on Jan 12, 2005 at 20:33 UTC
YOu can also run your query with DBI->trace(3) to see what DBD::Sybase thinks it is doing (what it is sending to the server, and what it is getting back.) This might help you get some better information about what is going on. Michael	[reply]
Re^4: DBI::Sybase sometimes returns nothing, but does not generate an error -> how can I catch this? by svenXY (Deacon) on Jan 13, 2005 at 08:59 UTC
Thanks, I'll try that! For the time being, my solution at least enables me to catch this error (bug?) and do something about it. Thanks for your help anybody, Sven	[reply]