Advertisement
Advertisement
| 09.04.2008 at 09:13AM PDT, ID: 23703214 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: |
<cffunction name="getproductListDep" returntype="query">
<cfargument name="depId" type="numeric" required="yes" default="0">
<cfargument name="pagesize" type="numeric" default="5">
<cfargument name="targetpage" type="numeric" default="1">
<cfstoredProc procedure="usp_listDepartments" datasource="#application.appConfig.dbSource#" username="#application.appConfig.dbUsername#" password="#application.appConfig.dbPassword#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#arguments.pagesize#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#arguments.targetpage#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#arguments.depId#">
<cfprocparam type="out" cfsqltype="cf_sql_integer" variable="pagecount">
</cfstoredproc>
<cfreturn>
</cffunction>
=======================================================================
if not exists (select null from information_schema.routines where routine_name = 'usp_listDepartments')
exec('
CREATE PROCEDURE usp_listDepartments
(
@PageSize FLOAT,
@TargetPage SMALLINT,
@Dept VARCHAR(5),
@PageCount INT OUTPUT
)
AS
BEGIN
WITH Sales_CTE(PageNumber, CatID, CatName, CatPos, DepID, DepName, depKey, DepDes, ProdID,
ProductName, ProductCode, Price, SalePrice, RetailPrice, PageName, PageDescription, PageDescription2, Active, Extra1, Extra2)
AS
(
SELECT
CEILING((ROW_NUMBER() OVER (ORDER BY c.CatID ASC))/@PageSize) AS PageNumber,
c.catId, c.name as catName, c.pos as catPos, d.depId, d.name as depName, d.metaKeywords as depKey, d.metaDescription as depDes, p.prodId,
p.name, p.productCode, p.price, p.salePrice, p.retailPrice, p.pageName, p.description, p.description2, p.active, p.extra1, p.EXTRA2
FROM categories c
INNER JOIN departments d on d.depId = c.depId
INNER JOIN Products p on c.catid = p.catId
WHERE c.depId = @Dept AND p.active = ''on''
)
SELECT
*
INTO ##Temp
FROM
Sales_CTE
WHERE
PageNumber = @Targetpage
SELECT @PageCount = COUNT(*)/@PageSize FROM ##Temp
SELECT * FROM ##Temp
END
')
|
