Need a clean MS SQL query to handle filtering & pagination. Also need to pass a variable.
Need a clean MS SQL query to handle filtering & pagination. Also need to pass a variable.
swagsandwich
Posts: 1Questions: 1Answers: 0
Found a lot of code with PHP mixed in and wondered if anyone just had a clean SELECT query that shows how to handle filtering and pagination.
Also, I would like to pass a variable via the script to the server so that I can handle the server side processing in one function. I would be passing a formID that would then reach out to the database so I could grab the associated table, database used, etc.
If it helps, I am coding in Coldfusion. I have run across some code but nothing perfect to this point. I think the clean SQL query would help a lot of people.
This discussion has been closed.