Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 General help me questions
 Adding to Review pages
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jill
VP-CART Super User

USA
249 Posts

Posted - September 20 2003 :  20:13:03  Show Profile  Reply with Quote
Hi,

I am trying to add more product information to the top of the review pages, along with the product title.

I found this on shopreviewadd.asp:

Sub GetProductDetails
dim rs, psql, productname
psql="select * from products where catalogid=" & catalogid
set rs=dbc.execute(psql)
if not rs.eof then
productname=rs("cname")
end if
rs.close
set rs=nothing
shopwriteheader productname

end sub

And I tried this, but it didn't work



Sub GetProductDetails
dim rs, psql, productname, prodcode
psql="select * from products where catalogid=" & catalogid
set rs=dbc.execute(psql)
if not rs.eof then
productname=rs("cname")
response.write "<br>"
prodcode=rs("ccode")

end if
rs.close
set rs=nothing
shopwriteheader productname

end sub

---------------

What am I doing wrong?

Thanks, Jill



Edited by - Jill on September 20 2003 20:14:12

Cam
VP-CART Super User

Australia
361 Posts

Posted - October 03 2003 :  23:44:14  Show Profile  Visit Cam's Homepage  Reply with Quote
Hi Jill,

Try this:

Sub GetProductDetails
dim rs, psql, productname
psql="select * from products where catalogid=" & catalogid
set rs=dbc.execute(psql)
if not rs.eof then
productname=rs("cname")
productname=productname & "<br>" & rs("ccode")
end if
rs.close
set rs=nothing
shopwriteheader productname
end sub

Cheers,
Cam

*************************************
Cam Flanigan
YourVirtualStore Sales
e-mail:
http://www.vpasp.com/sales/shopcustcontact.asp
web: http://www.yourvirtualstore.net

Build you own YourVirtualStore!!!
www.yourvirtualstore.net
*************************************

Edited by - cam on October 03 2003 23:45:18
Go to Top of Page

Jill
VP-CART Super User

USA
249 Posts

Posted - October 04 2003 :  23:49:38  Show Profile  Reply with Quote
That did it!

Thanks Cam



Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00