I also made a more "decent" trace and it looks like DBI finds something. The first trace here fails 
      !! info: '' CLEARED by call to prepare method
      -> prepare for DBD::ODBC::db (DBI::db=HASH(0x3fa28a8)~0x3fa2740 
+'select BBTicker, WMRic from FXSpots where id = 218') thr#1639fc8
      <- prepare= ( DBI::st=HASH(0x3fa2d58) ) [1 items] at mungeMarket
+Data.pl line 199
      -> execute for DBD::ODBC::st (DBI::st=HASH(0x3fa2d58)~0x3fa2ad0)
+ thr#1639fc8
      <- execute= ( '0E0' ) [1 items] at mungeMarketData.pl line 200
      -> bind_columns in DBD::_::st for DBD::ODBC::st (DBI::st=HASH(0x
+3fa2d58)~0x3fa2ad0 SCALAR(0x3a15040) SCALAR(0x3a15070)) thr#1639fc8
      <- bind_columns= ( 1 ) [1 items] at mungeMarketData.pl line 201
      -> fetch for DBD::ODBC::st (DBI::st=HASH(0x3fa2d58)~0x3fa2ad0) t
+hr#1639fc8
      <- fetch= ( undef ) [1 items] at mungeMarketData.pl line 202 
    BBticker =  
    WMRic =     
      -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3fa2ad0)~INNER) thr
+#1639fc8
      <- DESTROY= ( undef ) [1 items] at perl5db.pl line 3754
      -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x3fa2740)~INNER) thr
+#1639fc8
      <- DESTROY= ( undef ) [1 items] at mungeMarketData.pl line 63
      -- DBI::END ($@: , $!: )
      !! info: '' CLEARED by call to disconnect_all method
      -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x3fa20e0)~0x3
+fa2158) thr#1639fc8
    <- disconnect_all= ( '' ) [1 items] at DBI.pm line 741

[download]
and this trace succeeded 
   !! info: '' CLEARED by call to prepare method
    -> prepare for DBD::ODBC::db (DBI::db=HASH(0x3ef7a60)~0x3ef78f8 's
+elect BBTicker, CRBTicker from Indices where id = 51') thr#299fc8
    <- prepare= ( DBI::st=HASH(0x3ef7f10) ) [1 items] at mungeMarketDa
+ta.pl line 200
    -> execute for DBD::ODBC::st (DBI::st=HASH(0x3ef7f10)~0x3ef7c88) t
+hr#299fc8
    <- execute= ( -1 ) [1 items] at mungeMarketData.pl line 201
    -> bind_columns in DBD::_::st for DBD::ODBC::st (DBI::st=HASH(0x3e
+f7f10)~0x3ef7c88 SCALAR(0x3965040) SCALAR(0x3965070)) thr#299fc8
    <- bind_columns= ( 1 ) [1 items] at mungeMarketData.pl line 202
    -> fetch for DBD::ODBC::st (DBI::st=HASH(0x3ef7f10)~0x3ef7c88) thr
+#299fc8
    <- fetch= ( [ 'SPGCLV Index' undef ] ) [1 items] row1 at mungeMark
+etData.pl line 203
BBticker = SPGCLV Index
 WMRic =     
    -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3ef7c88)~INNER) thr#2
+99fc8
    <- DESTROY= ( undef ) [1 items] at perl5db.pl line 3754
    -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x3ef78f8)~INNER) thr#2
+99fc8
    <- DESTROY= ( undef ) [1 items] at mungeMarketData.pl line 63
    -- DBI::END ($@: , $!: )
    !! info: '' CLEARED by call to disconnect_all method
    -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x3ef7298)~0x3ef
+7310) thr#299fc8
    <- disconnect_all= ( '' ) [1 items] at DBI.pm line 741

[download]
the only differens I can see is in the fetch method where the failed trace has "undef" whereas the working one has my valid value.

In reply to Re^3: DBI don't fetch my data...or at least not all records by kurreburre
in thread DBI don't fetch my data...or at least not all records by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.