select *
from posters
where (posterCategory = 'Limited Editions')
// Make sure user cannot change url variables to be anything but numbers
url.strt = iif(isNumeric(url.strt), url.strt, 1);
url.show = iif(isNumeric(url.show), url.show, 1);
url.pg = iif(isNumeric(url.pg), url.pg, 1);
/* Version 1.10 introduced the ability to use a single URL variable
Below is an example how you might calculate the strt variable used for looping
(note: I stuck with the URL scope to support the other examples on this page,
you'd likely want to use a local variable)*/
// I know this code can be cleaner, but please remember that this custom tag and
// its example code is tested on CF4+ (not CF6+)).
if (IsDefined("url.example")){
if (url.example eq 6){
url.strt = url.pg * url.show;
}
}
// These are just some personal settings. Not required for custom tag.
Variables.ThisFileName = "limited_editions.cfm";
Variables.TimetoQuery = cfquery.ExecutionTime;
Variables.END_Number = url.strt + url.show;
if (Evaluate(getSearchItems.recordcount - URL.strt) LT URL.show){
Variables.END_Number = getSearchItems.recordcount;
}
// Make sure user cannot crash page by changing URL.strt to be less than 1
if (URL.strt lt 1){
URL.strt = 1;
}
MAP / ACTE III
