03-14-2007, 03:07 PM
Here's how I'd do it but I an Excel person who's used to If statements so that may color my results.
If
num_results > curr_page * res_per_page
then
res_per_age
else
num_results - ( (curr_page - 1) * res_per_page)
If
num_results > curr_page * res_per_page
then
res_per_age
else
num_results - ( (curr_page - 1) * res_per_page)
'76 911S | '14 328xi | '17 GTI | In memoriam: '08 848, '85 944
"Here, at last, is the cure for texting while driving. The millions of deaths which occur every year due to the iPhone’s ability to stream the Kim K/Ray-J video in 4G could all be avoided, every last one of them, if the government issued everyone a Seventies 911 and made sure they always left the house five minutes later than they’d wanted to. It would help if it could be made to rain as well. Full attention on the road. Guaranteed." -Jack Baruth
"Here, at last, is the cure for texting while driving. The millions of deaths which occur every year due to the iPhone’s ability to stream the Kim K/Ray-J video in 4G could all be avoided, every last one of them, if the government issued everyone a Seventies 911 and made sure they always left the house five minutes later than they’d wanted to. It would help if it could be made to rain as well. Full attention on the road. Guaranteed." -Jack Baruth