<%
'Alter these codes to change BanMan ads
ZoneCodeTopBanner1 = 18 'zone id no.
ZoneCodeTopBanner2 = 468 'width in pixels
ZoneCodeTopBanner3 = 60 'height in pixels
ZoneCodeTopBanner4 = 33333 'page id
'ZoneCodeRightSkyscraper1 = 20
'ZoneCodeRightSkyscraper2 = 120
'ZoneCodeRightSkyscraper3 = 600
'ZoneCodeRightSkyscraper4 = 22222
ZoneCodeRightSquareButton1 = 23
ZoneCodeRightSquareButton2 = 120
ZoneCodeRightSquareButton3 = 120
ZoneCodeRightSquareButton4 = 44444
ZoneCodeBottomBanner1 = 1
ZoneCodeBottomBanner2 = 468
ZoneCodeBottomBanner3 = 60
ZoneCodeBottomBanner4 = 33333
' To update this page for 2005 etc., change "Product.BG2004" in the SQL query to the appropriate field.
strSQL = "SELECT Cat.CatName AS CatName, Cat.CatID AS CatID, Subcat.CatID AS SubcatID, " &_
"Subcat.CatName AS SubcatName " &_
"FROM ((Category AS Cat LEFT JOIN " &_
"Category AS Subcat ON Cat.CatID = Subcat.ParentID) " &_
"INNER JOIN " &_
"Product ON Product.CatID = Subcat.CatID) " &_
"WHERE Cat.ParentID = 2 AND Product.Nom2006 = 1 And Not Cat.CatID = 91 And Not Cat.CatID = 46 And Not Cat.CatID = 48 " & _
"And Not Subcat.CatID = 147" &_
" ORDER BY CatName, SubcatName"
'Response.write strSQL
'Response.end
Call ExecuteSQL(strSQL,cursortype,rs_main)
%>
Winners, Finalists, and Nominees: Best Software Awards 2006: Pocket PC
Best Pocket PC Software Winners, Finalists, and Nominees
Click on a category below to see the nominees in that category.
Click here to see Smartphone winners, finalists, and nominees.
To look for a specific product, click the major category page (Games, Utilities,
etc.) and then search using the Internet Explorer Edit Find command.
<%
strCat=""
strSubCat=""
Do While Not rs_main.EOF
If strCat <> rs_main("CatName") And strSubCat <> rs_main("SubCatName") Then
%> <%
End If
If strCat <> rs_main("CatName") Then
%>
"><%=rs_main("CatName")%> 