Zip File Should Contain: readme.txt (this file) NextRecords.cfm ----------------------------------------------------------------- AUTHOR: Robert A. Weimer (robert@info-access.com) CREATED: February 26, 1998 REVISED: April 21, 1998 Please note this tag is unsupported. It is not guaranteed to work - EVER! Use at your own risk, I am NOT responsible for any damage to your equipment or mental health. If you absolutely feel the need to email me for help, please make sure you have tried EVERYTHING possible before contacting me and don't be offended if I don't answer your email -- I'm just as busy as you. DESCRIPTION: CF_NextRecords is a Cold Fusion custom tag that displays the next set of records in a query. It allows the user to move forward and backwards through a set of records using a single CFML template. REQUIRED ATTRIBUTES: Records: The total record count of the current query. This can be set by using the query's name with the 'RecordCount' property. For example, assume the query is named MyQuery then use #MyQuery.RecordCount# for this attribute. You must use the pound signs (#) for it to work. ThisPageName: The name of the CFML template. (mytemplate.cfm) THIS REQUIRED VARIABLE MUST GO IN THE TAG - SR: The starting row for the CFOUTPUT tag. Within the CFOUTPUT tag within your template add the attribute StartRow=#SR# THIS REQUIRED VARIABLE MUST GO IN THE TAG _AND_ THE TAG - RecordsToDisplay: The number of records to display in each pass. This attribute MUST be used in conjunction with the MaxRows attribute of the CFOUTPUT tag displaying the query's data. They MUST be set to the same number. The tag has no control over the number of records the template will actually display. Within the CFOUTPUT tag within your template add the attribute MaxRows=#RecordsToDisplay# NON-REQUIRED ATTRIBUTES: DisplayText: The displayed before the next/previous record count. The default is "Record." Don't make the word plural, let the tag handle that. The tag traps for the next set of records only containing one record. For example - Back to RECORDS 1 - 5 Or Forward to RECORD 31. DisplayFont: Font face to use for display. Default is Arial. FontSize: Font size to use in display. Default is 2. UseBold: Yes/No Make font bold. Default is no. ExtraURL: Any extended URL information that needs to be appended to the hyperlink and passed to the next CFML template. Many queries require specific variables be present to allow the query to function. For example in the 'WHERE' clause of the SQL statement. The ExtraURL attribute will be appended to the next templates URL when the back/forward hyperlinks are clicked. This attribute may take some playing with, however. Please try to get the tag to display the first set of records before attempting to add the ExtraURL attribute. NOTES: If the total record count for the query is less than the number of records set to display (RecordsToDisplay) then the Back/Forward will NOT appear. Sample Use: SELECT * FROM TableToUse v-(Note use of #'s)-v v-----(Note use of #'s)-------v OUTPUT HERE If the total record count for the query is less than the number of records set to display (RecordsToDisplay) then the Back/Forward will NOT appear. Thanks and good luck!