Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

(ar0n) Re: (Ovid) Re: Disappearing results with DBI and bind_columns

by ar0n (Priest)
on Dec 31, 2001 at 04:21 UTC ( #135300=note: print w/ replies, xml ) Need Help??


in reply to (Ovid) Re: Disappearing results with DBI and bind_columns
in thread Disappearing results with DBI and bind_columns

Yes, I have, actually. At trace level 3. From what I can make out of it, it appears to be finding the rows. So there appears to be some sort of problem between the execute and the fetching of the results.

Below is the output of DBI->trace

DBI 1.20-nothread dispatch trace level set to 3 Note: perl is running without the recommended perl -w option -> prepare for DBD::mysql::db (Apache::DBI::db=HASH(0x8324ff0)~0x8 +325008 'SELECT id, username, password, email FROM user WHERE username = ?') New DBI::st (for DBD::mysql::st, parent=DBI::db=HASH (0x8325008 +), id=) dbih_setup_handle(DBI::st=HASH(0x832be60)=>DBI::st=HASH(0x831bff4) +, DBD::mysql::st, 832be6c, Null!) dbih_make_com(DBI::db=HASH(0x8325008), DBD::mysql::st, 204) Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x832be60) at DB.pm line 200 -> execute for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4 ' +ar0n') -> dbd_st_execute for 0831c0b4 Binding parameters: SELECT id, username, password, email FROM user WHERE username = 'ar0n' <- dbd_st_execute 1 rows <- execute= 1 at DB.pm line 202 -> bind_columns in DBD::_::st for DBD::mysql::st (DBI::st=HASH(0x8 +32be60)~0x831bff4 SCALAR(0x824a3e4) SCALAR(0x824a42c) SCALAR(0x824a44 +4) SCALAR(0x824a45c)) dbih_setup_fbav for 4 fields => 0x8332c98 dbih_sth_bind_col 1 => SCALAR(0x824a3e4) dbih_sth_bind_col 2 => SCALAR(0x824a42c) dbih_sth_bind_col 3 => SCALAR(0x824a444) dbih_sth_bind_col 4 => SCALAR(0x824a45c) <- bind_columns= 1 at DB.pm line 203 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4) -> dbd_st_fetch for 0831c0b4, chopblanks 0 Storing row 0 (1) in 0824a3e4 Storing row 1 (ar0n) in 0824a42c Storing row 2 (j0n4) in 0824a444 Storing row 3 (jona@knowltonian.net) in 0824a45c <- dbd_st_fetch, 4 cols <- fetchrow= 'jona@knowltonian.net' row1 at DB.pm line 205 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4) -> dbd_st_fetch for 0831c0b4, chopblanks 0 <- fetchrow= undef row1 at DB.pm line 205 -> prepare for DBD::mysql::db (Apache::DBI::db=HASH(0x8324ff0)~0x8 +325008 ' SELECT id, user, created, title, caption, category, type, filename, size, width, height FROM picture WHERE user = ?') New DBI::st (for DBD::mysql::st, parent=DBI::db=HASH(0x8325008), i +d=) dbih_setup_handle(DBI::st=HASH(0x831c090)=>DBI::st=HASH(0x8332cd4) +, DBD::mysql::st, 831c09c, Null!) dbih_make_com(DBI::db=HASH(0x8325008), DBD::mysql::st, 204) Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x831c090) at DB.pm line 54 -> execute for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332cd4 ' +1') -> dbd_st_execute for 08202b18 Binding parameters: SELECT id, user, created, title, caption, category, type, filename, size, width, height FROM picture WHERE user = '1' <- dbd_st_execute 4 rows <- execute= 4 at DB.pm line 56 -> bind_columns for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332 +cd4 SCALAR(0x82419a4) SCALAR(0x82419ec) SCALAR(0x8241a04) SCALAR(0x82 +41a1c) SCALAR(0x8241a34) SCALAR(0x8241a64) SCALAR(0x8241a4c) SCALAR(0 +x8243278) SCALAR(0x8243290) SCALAR(0x82432a8) SCALAR(0x82432c0)) dbih_setup_fbav for 11 fields => 0x8332ed8 dbih_sth_bind_col 1 => SCALAR(0x82419a4) dbih_sth_bind_col 2 => SCALAR(0x82419ec) dbih_sth_bind_col 3 => SCALAR(0x8241a04) dbih_sth_bind_col 4 => SCALAR(0x8241a1c) dbih_sth_bind_col 5 => SCALAR(0x8241a34) dbih_sth_bind_col 6 => SCALAR(0x8241a64) dbih_sth_bind_col 7 => SCALAR(0x8241a4c) dbih_sth_bind_col 8 => SCALAR(0x8243278) dbih_sth_bind_col 9 => SCALAR(0x8243290) dbih_sth_bind_col 10 => SCALAR(0x82432a8) dbih_sth_bind_col 11 => SCALAR(0x82432c0) <- bind_columns= 1 at DB.pm line 57 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332cd4) -> dbd_st_fetch for 08202b18, chopblanks 0 Storing row 0 (2) in 082419a4 Storing row 1 (1) in 082419ec Storing row 2 (2001-08-03) in 08241a04 Storing row 3 (Weirdo) in 08241a1c Storing row 4 (Test) in 08241a34 Storing row 5 (9) in 08241a64 Storing row 6 (1) in 08241a4c Storing row 7 (funky.jpg) in 08243278 Storing row 8 (13913) in 08243290 Storing row 9 (0) in 082432a8 Storing row 10 (0) in 082432c0 <- dbd_st_fetch, 11 cols <- fetchrow= '0' row1 at DB.pm line 68 <> DESTROY ignored for outer handle DBI::st=HASH(0x831c090) (inner + DBI::st=HASH(0x8332cd4)) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8332cd4)~INNER) <- DESTROY= undef at Browse.pm line 24 <> DESTROY ignored for outer handle DBI::st=HASH(0x832be60) (inner + DBI::st=HASH(0x831bff4)) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x831bff4)~INNER) <- DESTROY= undef at Browse.pm line 93 + + +

[ ar0n -- want job (boston) ]


Comment on (ar0n) Re: (Ovid) Re: Disappearing results with DBI and bind_columns
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://135300]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (13)
As of 2014-07-28 17:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (204 votes), past polls