Re: CF and SQL or just SQL?

2006-08-29 Thread RichL
D I'm not sure if I 100% understand what you need to do but I think that based on an id of a variable you need to: - find the 10 integer range that it is in and calculate the start and end values for that range - based on the range you need to work out a current page number in a set of pages and

CF and SQL or just SQL?

2006-08-26 Thread coldfusion . developer
I'm passing an id, a numeric value in a URL.value. That id value indentifies the primary key id of a record in my db. Based on that value, I want to get the group of records in the db that surround that value in groups of 10. This is used to display other hyperlinked items in the same group. I'm

Re: CF and SQL or just SQL?

2006-08-26 Thread Denny Valliant
First off, this isn't going to help much :-) Second off, I think what you'd want to do is grab a query of all your videos, and put it in memory somewhere. Then do a QoQ for the records in the group you want, and then, instead of using the actual video ID's to do your math, use the recordcount