Re: Beginning and end of table

[Robert Tulloch]

Hi:

My remaining problem:

Code for scrolling previous in below DBI->trace block

The bound select statement works fine in php MyAdmin SQL causing the previous record to be displayed.

When executed in the program that produced the DBI-trace, it fails and reloads the same record 'Dare'.

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

The block below is produced when getting the next record and it works fine in both the program and php MyAdmin SQL producing the "next" record.

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

Seems to me that both should work or both should fail