DBI::db=HASH(0x259e884) trace level set to 0x0/9 (DBI @ 0x0/0) in DBI 1.616-ithread (pid 7496) -> prepare for DBD::ODBC::db (DBI::db=HASH(0x259e914)~0x259e884 'SELECT [Index Returns].[Index Number], [Index Returns].Month, [Index Returns].Return FROM [Index Returns] WHERE [Index Returns].[Index Number]=63 AND YEAR( [Index Returns].Month)=2006') thr#1ce7904 New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x259e884), id=undef) dbih_setup_handle(DBI::st=HASH(0x259eb54)=>DBI::st=HASH(0x259eaf4), DBD::ODBC::st, 2589a5c, Null!) dbih_make_com(DBI::db=HASH(0x259e884), 1d0a63c, DBD::ODBC::st, 236, 0) thr#1ce7904 dbih_setup_attrib(DBI::st=HASH(0x259eaf4), Err, DBI::db=HASH(0x259e884)) SCALAR(0x258997c) (already defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), State, DBI::db=HASH(0x259e884)) SCALAR(0x25899fc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), Errstr, DBI::db=HASH(0x259e884)) SCALAR(0x25899bc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), TraceLevel, DBI::db=HASH(0x259e884)) 9 (already defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), FetchHashKeyName, DBI::db=HASH(0x259e884)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), HandleSetErr, DBI::db=HASH(0x259e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), HandleError, DBI::db=HASH(0x259e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), ReadOnly, DBI::db=HASH(0x259e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x259eaf4), Profile, DBI::db=HASH(0x259e884)) undef (not defined) initializing sth query timeout to -1 ignore named placeholders = 0 SQLPrepare SELECT [Index Returns].[Index Number], [Index Returns].Month, [Index Returns].Return FROM [Index Returns] WHERE [Index Returns].[Index Number]=63 AND YEAR( [Index Returns].Month)=2006 SQLPrepare = 0 <- prepare= ( DBI::st=HASH(0x259eb54) ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 63 -> execute for DBD::ODBC::st (DBI::st=HASH(0x259eb54)~0x259eaf4) thr#1ce7904 +dbd_st_execute(2589a7c) dbd_st_finish(2589a7c) outparams = 0 SQLExecute/SQLExecDirect(2631f88)=0 SQLRowCount=0 (rows=-1) SQLNumResultCols=0 (flds=3) dbd_describe done_desc=0 dbd_describe SQLNumResultCols=0 (columns=3) DescribeCol column = 1, name = I, namelen = 12, type = INTEGER(4), precision/column size = 10, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 11 SQL_COLUMN_LENGTH = 0 now using col 1: type = INTEGER (4), len = 1, display size = 12, prec = 10, scale = 0 DescribeCol column = 2, name = M, namelen = 5, type = TIMESTAMP(93), precision/column size = 19, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 19 SQL_COLUMN_LENGTH = 19 now using col 2: type = TIMESTAMP (93), len = 20, display size = 20, prec = 19, scale = 0 DescribeCol column = 3, name = R, namelen = 6, type = DOUBLE(8), precision/column size = 53, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 22 SQL_COLUMN_LENGTH = 0 now using col 3: type = DOUBLE (8), len = 1, display size = 23, prec = 53, scale = 0 -dbd_describe done_bind=0 have 3 fields -dbd_st_execute(2589a7c)=-1 <- execute= ( -1 ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 64 -> fetchall_arrayref for DBD::ODBC::st (DBI::st=HASH(0x259eb54)~0x259eaf4) thr#1ce7904 bind_columns fbh=1d18e0c fields=3 Bind 1: type = CHAR(1), buf=260d844, buflen=12 Bind 2: type = CHAR(1), buf=260d850, buflen=20 Bind 3: type = CHAR(1), buf=260d864, buflen=23 bind_columns=0 SQLFetch rc 0 dbih_setup_fbav alloc for 3 fields dbih_setup_fbav now 3 fields fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-01-31 00:00:00'(19) fetch col#3 R datalen=1 displ=23 '.'(1) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-02-28 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '1.04229344255789'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-03-31 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.527619016616885'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-04-30 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.778996070749438'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-05-31 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.598470714678423'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-06-30 00:00:00'(19) fetch col#3 R datalen=15 displ=23 '1.5153242075065'(15) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-07-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '1.96514473171672'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-08-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '3.69323515846371'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-09-30 00:00:00'(19) fetch col#3 R datalen=1 displ=23 '.'(1) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-10-31 00:00:00'(19) fetch col#3 R datalen=15 displ=23 '1.9777348426463'(15) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-11-30 00:00:00'(19) fetch col#3 R datalen=18 displ=23 '-0.949641474442719'(18) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-12-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '2.48912119074928'(16) SQLFetch rc 100 Getting more results: 100 No more results -- outparams = 0 dbd_st_finish(2589a7c) dbd_st_finish closed query: <- fetchall_arrayref= ( [ ARRAY(0x259ebf4) ARRAY(0x259ec94) ARRAY(0x259ed34) ARRAY(0x259ee14) ARRAY(0x259ee94) ARRAY(0x259ef14) ARRAY(0x259ef94) ARRAY(0x25a0044) ARRAY(0x25a00c4) ARRAY(0x25a0144) ARRAY(0x25a01c4) ARRAY(0x25a0244) ] ) [1 items] row12 at F:\Andrei\Covi\pl\covi_test.pl line 65 -> trace for DBD::ODBC::db (DBI::db=HASH(0x259e914)~0x259e884 0) thr#1ce7904 <- trace= ( 9 ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 67 -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x259eaf4)~INNER) thr#1ce7904 <- DESTROY= ( undef ) [1 items]