Customzing Cactushop pages ?????

This is a discussion on "Customzing Cactushop pages ?????" within the Scripts and Online Services section. This forum, and the thread "Customzing Cactushop pages ????? are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Scripts and Online Services

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Jul 20th, 2007, 10:12
Up'n'Coming Member
Join Date: Jul 2007
Location: Barry
Age: 22
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Question Customzing Cactushop pages ?????

in the page front_toplist.asp i have a custom page but cannot seem to get the price to show on product here is what i currently have.
http://www.imagehosting.com/out.php/..._Untitled1.jpg

i cannot get the price to show under the image. also i cannot get each block to show a different product here is my code also

Code: Select all
  If numNewestProductsList > 0 then
   '-----------------------------------------------
   'PULL OUT THE TOP 50 NEWEST PRODUCTS
   '-----------------------------------------------
   if strDatabaseType = "access" then strTblProd = "tblCactuShop" & TABLE_PREFIX & "Products." else strTblProd = ""
strSelectValues = "P_ID, P_OrderVersionsBy, P_StrapLine" & CInt(numLanguageID) & ", " & strTblProd & castSQL("P_Desc" & CInt(numLanguageID)) & " as P_Desc" & CInt(numLanguageID) & ", P_Name" & CInt(numLanguageID) & ", P_VersionDisplayType, P_Featured"
strselectvalues2 = Replace(strSelectValues, "as P_Desc" & CInt(numLanguageID),"")
   numCount = 0
   strQuery = LimitSQL("tblCactuShop" & TABLE_PREFIX & "Products.P_ID, tblCactuShop" & TABLE_PREFIX & "Products.P_Name" & numLanguageID & " FROM (((tblCactuShop" & TABLE_PREFIX & "Versions INNER JOIN tblCactuShop" & TABLE_PREFIX & "Products ON tblCactuShop" & TABLE_PREFIX & "Versions.V_ProductID = tblCactuShop" & TABLE_PREFIX & "Products.P_ID) INNER JOIN tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink ON tblCactuShop" & TABLE_PREFIX & "Products.P_ID = tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink.PCAT_ProductID) INNER JOIN tblCactuShop" & TABLE_PREFIX & "Categories ON tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink.PCAT_CategoryID = tblCactuShop" & TABLE_PREFIX & "Categories.CAT_ID) LEFT OUTER JOIN tblCactuShop" & TABLE_PREFIX & "Suppliers ON tblCactuShop" & TABLE_PREFIX & "Products.P_SupplierID = tblCactuShop" & TABLE_PREFIX & "Suppliers.SUP_ID WHERE P_Name" & CInt(numLanguageID)  & " <> '' AND V_Live ='y' AND P_Live = 'y' AND CAT_Live = 'y' AND V_CustomerGroupID IN (0," & DB_CG_ID & ") AND P_CustomerGroupID IN (0," & DB_CG_ID & ") AND CAT_CustomerGroupID IN (0," & DB_CG_ID & ") AND (SUP_Live <> 'n' OR SUP_Live IS NULL) ORDER BY P_ID DESC", numNewestProductsList, true)
   Call ExecuteRS(strQuery, objRecordSet)
   if Not (objRecordSet.BOF And objRecordSet.EOF) then
    'Run it in to an array: bound 0 is ID, 1 is name of product %>
    <div class="box">
     <h4><!-- <% WriteString("ContentText_NewProductsList") %> --></h4>
     <div class="pad">
     <div><% 
      Do While not objRecordSet.EOF and numCount < numNewestProductsList
       numCount = numCount + 1
       numProductID = objRecordSet("P_ID")
       numProductName = objRecordSet("P_Name" & CInt(numLanguageID))
       If numNewestProductsTruncate > 0 then 
        if len(numProductName) > numNewestProductsTruncate then numProductName = left(numProductName, numNewestProductsTruncate - 3) & "..."
       End If %>    
       <table border="1" width="800" height="" frame="">
<tr>
<td width=""><a href="product.asp?<%= objCactuSession.QS %>P_ID=<%= numProductID %>"><%= numProductName %><br /><br /><img src="uploads//images_products/<%= numProductID %>.jpg" /></a><Br /><Br /></td>
<td width=""><a href="product.asp?<%= objCactuSession.QS %>P_ID=<%= numProductID %>"><%= numProductName %><br /><br /><img src="uploads//images_products/<%= numProductID %>.jpg" /></a><Br /><Br /></td>
<td width=""><a href="product.asp?<%= objCactuSession.QS %>P_ID=<%= numProductID %>"><%= numProductName %><br /><br /><img src="uploads//images_products/<%= numProductID %>.jpg" /></a><Br /><Br /></td>
</tr><% 
       objRecordSet.MoveNext
      Loop %>
     </table></div>
    </div></div>
   <% end if
   objRecordSet.Close
  end if %>
            <%
end if %>
Reply With Quote

Reply

Tags
cactushop

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
CactuShop query B3ndy Classic ASP 1 Nov 5th, 2007 03:12
Query Pulling Wrong information from MySQL database :: Cactushop Andrew1986 Classic ASP 1 Oct 3rd, 2007 11:06
Cactushop Shop Latest Products page Andrew1986 Scripts and Online Services 6 Jul 19th, 2007 11:29
Javascript - Updating web pages with snippets from other pages Ydot JavaScript Forum 3 Jul 10th, 2007 14:38
Scripting Needed(adding pages to pages) Amari Classic ASP 1 Sep 4th, 2004 18:06


All times are GMT. The time now is 16:56.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

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