Binding cfdiv to cfc object?

Hi,

     Please try the following,

create procedure with neccesary changes

if you pass 0 and -99 then you will get the whole result

if you pass 0 and 10 then you will get records from 1 to 10;

if you pass 1 and 10 then you will get records from 11 to 20;........

---------------
CREATE PROCEDURE <<procname>>(
  pagesize int
  ,pageindex int
)
BEGIN
  DECLARE FirstRec,LastRec INT;

  DROP TEMPORARY TABLE IF EXISTS CommentTempTable;
  CREATE TEMPORARY TABLE CommentTempTable
  (
    id INT NOT NULL AUTO_INCREMENT primary key
    ,commentid int
    ,comment varchar(3000)
    );

  INSERT INTO CommentTempTable
  (
    commentid
    ,comment
   
    )
    select
        <<tablename>>.commentid
        ,<<tablename>>.comment

        ,<<tablename>>.dateentered
from <<tablename>>
        ;

  SET FirstRec = pageindex * pagesize;  /* 0 based index  */
  SET LastRec = (pageindex + 1) * pagesize + 1;

  IF (pagesize = -99) then

    SELECT
        commentid
        ,comment      
      FROM
        CommentTempTable;
  ELSE
      SELECT
        commentid
        ,comment
       
      FROM
          CommentTempTable
      WHERE
          ID > FirstRec AND ID < LastRec;

    SELECT COUNT(*) as RowCount FROM CommentTempTable;

  END IF;

  DROP TABLE CommentTempTable;

END $$

----------------

This stored procedure returns two result

1) selected records

2) total record count