| <% 'Set ProductID here txtProdId = 2001 If iConverion = 1 Then Response.Write "" Dim CurrencyISO CurrencyISO = getCurrencyISO(Session.LCID ) Set rsProdDetail = Server.CreateObject("ADODB.Recordset") Set rsProdAttributes = Server.CreateObject("ADODB.Recordset") SQL = "SELECT prodID, prodName, prodShortDescription, prodImageSmallPath, " _ & "prodImageLargePath, prodLink, prodPrice, prodAttrNum, catName, " _ & "prodSaleIsActive, prodSalePrice, prodMessage, prodDescription " _ & "FROM sfProducts " _ & "INNER JOIN sfCategories ON sfProducts.prodCategoryID = sfCategories.catID " _ & "WHERE prodID = '" & txtProdId & "'" rsProdDetail.Open SQL, cnn, adOpenForwardOnly, adLockReadOnly If Not (rsProdDetail.EOF And rsProdDetail.BOF) Then If rsProdDetail("prodAttrNum") > 0 Then 'Modified by Sandshot Software SQL = "SELECT attrName, attrDisplayStyle, attrdtId, attrdtName, attrdtPrice, attrdtType, attrdtOrder " _ & "FROM sfAttributes " _ & "LEFT JOIN sfAttributeDetail ON sfAttributes.attrId = sfAttributeDetail.attrdtAttributeId " _ & "WHERE attrProdId = '" & rsProdDetail("prodId") & "' ORDER BY attrSortOrder, attrdtOrder" 'End modification by Sandshot Software rsProdAttributes.Open SQL, cnn, adOpenForwardOnly, adLockReadOnly End If End If %> | ||||
Sizing equivalency chart for CCM jerseys
Men Small= Chest Size of 40"- 42" |
||||
|
If you are having problems ordering NHL jerseys online Please send us an email sales@thesportinstore.com We will give you a discount |