parse_params statement alter table users order by lastname asc <- dbd_st_execute returning imp_sth->row_num 60 <- execute= 60 at update_tables.cgi line 511 via at update_tables.cgi line 321 #### Error Log Move Pointer -> [Wed Mar 28 15:18:59 2018] update_tables.cgi: Entered update_tables.cgi Open Database return First Record with action: = 'navigate_records' at update_tables.cgi line 290. [Wed Mar 28 15:18:59 2018] update_tables.cgi: search parameter = '2' at update_tables.cgi line 291. [Wed Mar 28 15:18:59 2018] update_tables.cgi: rowpointer = 'Dare"' at update_tables.cgi line 292. [Wed Mar 28 15:18:59 2018] update_tables.cgi: sortindex = '1' at update_tables.cgi line 299. [Wed Mar 28 15:18:59 2018] update_tables.cgi: searchfield = 'lastname' sortindex = '1' at update_tables.cgi line 319. [Wed Mar 28 15:18:59 2018] update_tables.cgi: searchIndex = '1' at update_tables.cgi line 489. [Wed Mar 28 15:18:59 2018] update_tables.cgi: in restoreOrder index = '1' at update_tables.cgi line 503. [Wed Mar 28 15:18:59 2018] update_tables.cgi: statement = 'SELECT * FROM users WHERE lastname >= (SELECT MIN(lastname) FROM users WHERE lastname > ?) ORDER BY lastname ASC LIMIT 1' at update_tables.cgi line 362. [Wed Mar 28 15:18:59 2018] update_tables.cgi: kind = '2' rowpointer = 'Dare"' at update_tables.cgi line 373. [Wed Mar 28 15:18:59 2018] update_tables.cgi: navigate statement = 'SELECT * FROM users WHERE lastname >= (SELECT MIN(lastname) FROM users WHERE lastname > ?) ORDER BY lastname ASC LIMIT 1' at update_tables.cgi line 377. [Wed Mar 28 15:18:59 2018] update_tables.cgi: navResult = 'HASH(0x3115b60)' at update_tables.cgi line 381. [Wed Mar 28 15:18:59 2018] update_tables.cgi: count = '1' at update_tables.cgi line 385. [Wed Mar 28 15:18:59 2018] update_tables.cgi: count = '1' at update_tables.cgi line 396. Finished print {"DD":"1973-11-30","DP":"1974-10-02","MD":"120.00","MJ":"1990-03-29","address1":"79257 Branson Corners Suite 41","address2":"Suite 295","business":"Block, Bernier and Sporer","city":"Port Randalport","comments":"Mollitia odit quis ipsum quo et voluptate libero. Accusamus vel culpa magni ipsam adipisci.\nUt quas esse est ea. Deserunt rerum quia quo et. Enim et totam sapiente et non a saepe.","email":"yadams@gutmann.org","forename":"Christophe","id":91,"lastname":"Ebert","password":"44 wy","phone_cell":"352-996-7500x6","phone_home":"084-688-5902","pin":"jbwmi","position":4,"state":"WY","user_id":37,"username":"buckridge.myra","zip":"26974-0929"} at update_tables.cgi line 402. DBI -> parse_params statement SELECT * FROM users WHERE lastname >= (SELECT MIN(lastname) FROM users WHERE lastname > ?) ORDER BY lastname ASC LIMIT 1 Binding parameters: SELECT * FROM users WHERE lastname >= (SELECT MIN(lastname) FROM users WHERE lastname > 'Dare\"') ORDER BY lastname ASC LIMIT 1 #### Error Log File Move Pointer <- [Wed Mar 28 14:56:04 2018] update_tables.cgi: Entered update_tables.cgi Open Database return First Record with action: = 'navigate_records' at update_tables.cgi line 290. [Wed Mar 28 14:56:04 2018] update_tables.cgi: search parameter = '1' at update_tables.cgi line 291. [Wed Mar 28 14:56:04 2018] update_tables.cgi: rowpointer = 'Dare"' at update_tables.cgi line 292. [Wed Mar 28 14:56:04 2018] update_tables.cgi: sortindex = '1' at update_tables.cgi line 299. [Wed Mar 28 14:56:04 2018] update_tables.cgi: searchfield = 'lastname' sortindex = '1' at update_tables.cgi line 319. [Wed Mar 28 14:56:04 2018] update_tables.cgi: searchIndex = '1' at update_tables.cgi line 489. [Wed Mar 28 14:56:04 2018] update_tables.cgi: in restoreOrder index = '1' at update_tables.cgi line 503. [Wed Mar 28 14:56:05 2018] update_tables.cgi: statement = 'SELECT * FROM users WHERE lastname <= (SELECT MAX(lastname) FROM users WHERE lastname < ?) ORDER BY lastname DESC LIMIT 1' at update_tables.cgi line 362. [Wed Mar 28 14:56:05 2018] update_tables.cgi: kind = '1' rowpointer = 'Dare"' at update_tables.cgi line 373. [Wed Mar 28 14:56:05 2018] update_tables.cgi: navigate statement = 'SELECT * FROM users WHERE lastname <= (SELECT MAX(lastname) FROM users WHERE lastname < ?) ORDER BY lastname DESC LIMIT 1' at update_tables.cgi line 377. [Wed Mar 28 14:56:05 2018] update_tables.cgi: navResult = 'HASH(0x2d6eb60)' at update_tables.cgi line 381. [Wed Mar 28 14:56:05 2018] update_tables.cgi: count = '1' at update_tables.cgi line 385. [Wed Mar 28 14:56:05 2018] update_tables.cgi: count = '1' at update_tables.cgi line 396. [Wed Mar 28 14:56:05 2018] update_tables.cgi: Finished print {"DD":"1974-03-17","DP":"1986-11-10","MD":"120.00","MJ":"1997-05-31","address1":"839 Baumbach Lane","address2":"Apt. 701","business":"Runolfsdottir, Mueller and Moe","city":"Gloverton","comments":"Qui molestias ipsum non velit deserunt. Et qui similique expedita sunt explicabo qui. Voluptatem corporis cupiditate quia quis neque sit ut.","email":"bergstrom.cindy@pollich.biz","forename":"Vickie","id":8,"lastname":"Dare","password":"30 eq","phone_cell":"+45(0)20928653","phone_home":"385.259.7558","pin":"sbwmn","position":4,"state":"ID","user_id":12,"username":"jaeden68","zip":"08973-6995"} at update_tables.cgi line 402. DBI <- parse_params statement SELECT * FROM users WHERE lastname <= (SELECT MAX(lastname) FROM users WHERE lastname < ?) ORDER BY lastname DESC LIMIT 1 Binding parameters: SELECT * FROM users WHERE lastname <= (SELECT MAX(lastname) FROM users WHERE lastname < 'Dare\"') ORDER BY lastname DESC LIMIT 1