Short description

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

===========================================================================

Show the short product description on the View Cart and Order Summary page:

===========================================================================
===========================================================================

View Cart page (pc/viewCart.asp)

Add the following ASP code right before the line that reads (~ line 147):

<% 'BTO ADDON-S

ASP code to add:

<% 'Show short product description
call opendb()
mySQL="SELECT idproduct, sDesc FROM products WHERE idproduct=" & trim(pcCartArray(f,0))
set rsDesc=conntemp.execute(mySQL)
psDesc=rsDesc("sDesc")
if psDesc <> "" then %>
<tr> 
<td>&nbsp;</td>
<td><font size="2" face="<%=FFType%>" color="<%=FColor%>">
<%=psDesc%></font></td>
<td colspan="3"></td>
</tr>
<% End if
call closeDb()
set rsDesc=nothing 
'End show short product description %>

I've tried it, but it does not work in 3.11 with SQL.  I'm not a programmer, so I would need the complete code and where to paste it.
I appreciate any help,
Katharina

===========================================================================

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply Topic: Short description Posted: 18-July-2008 at 12:00am
	Is there an easy way of having the short description showing up in the shopping cart along with the product title when a customer adds a product to the cart? Same for the invoice. Katharina

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 18-July-2008 at 12:21am
	I have not tested this, but I think it is accurate. Someone correct me if you see a flaw. Search viewcart.asp for "<% ' Get product image and sku" Directly below that comment is a SQL query. First add the column name (description) to that query. Then look for the 2nd instance of <% If Session("Cust_BuyGift")="" Then %> and you will see the link to viewPrd.asp. Edit that code to display the new description field you just pulled from the db. Can't look for the invoice equivalent at the moment, but hope the above gets you going in the right direction?

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply Posted: 18-July-2008 at 2:07pm
	I've found this info in the EI developer's corner. http://www.earlyimpact.com/productcart/support/code_samples/Display_short_description.txt =========================================================================== Show the short product description on the View Cart and Order Summary page: =========================================================================== =========================================================================== View Cart page (pc/viewCart.asp) Add the following ASP code right before the line that reads (~ line 147): <% 'BTO ADDON-S ASP code to add: <% 'Show short product description call opendb() mySQL="SELECT idproduct, sDesc FROM products WHERE idproduct=" & trim(pcCartArray(f,0)) set rsDesc=conntemp.execute(mySQL) psDesc=rsDesc("sDesc") if psDesc <> "" then %> <tr> <td> </td> <td><font size="2" face="<%=FFType%>" color="<%=FColor%>"> <%=psDesc%></font></td> <td colspan="3"></td> </tr> <% End if call closeDb() set rsDesc=nothing 'End show short product description %> I've tried it, but it does not work in 3.11 with SQL. I'm not a programmer, so I would need the complete code and where to paste it. I appreciate any help, Katharina ===========================================================================