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
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
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.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|