> For some reason my code didn't get included in the first email. Here's a
> link to the code in question...
>
> http://www.brionanet.com/nextprevcodechunk.txt
>
Alan,
While not directly related to your question, one thing you may want to
do in your code is add the Cachedwithin attribute to your query. It
would speed things up a lot, especially for large queries, assuming of
course that your SortOrder variable stays the same from page to page.
<CFQUERY NAME="GetProducts" DATASOURCE="#EComDB#"
cachedwithin="#CreateTimeSpan(0, 0, 60, 0)#">
SELECT * from Products,Categories
WHERE Products.CategoryID = #CategoryID#
AND Products.CategoryID = Categories.CategoryID
AND Products.InventoryCount >0
ORDER BY #SortOrder#
</CFQUERY>
regards,
larry
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
