ProductCart Shopping Cart Software Forums : displaying data bases on customer https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 00:51:45 +0000 Sat, 04 Mar 2006 17:00:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=139 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[displaying data bases on customer : John, Right, another field in...]]> https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post406.html#406 Author: dwatch
Subject: 139
Posted: 04-March-2006 at 5:00pm

John,

Right, another field in the database would be useful.  I can handle that part.  the part I need help with is the exact coding that would state if the customer is xyz company and the product is a sku: tt33, then display that new price field.

]]> Sat, 04 Mar 2006 17:00:04 +0000 https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post406.html#406 <![CDATA[displaying data bases on customer : I am not sure what you are asking,Do...]]> https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post405.html#405 Author: watercrazed
Subject: 139
Posted: 04-March-2006 at 4:38pm

I am not sure what you are asking,

Do you have a different pricing structure for each customer?
I think you would need a new price column in the database for each customer or customer class. Then replace standardprice variable pPrice=rs("price") with newprice variable name.

For another example look for the code where the cart displays wholesale price based on the customer class of wholesale.
]]> Sat, 04 Mar 2006 16:38:18 +0000 https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post405.html#405 <![CDATA[displaying data bases on customer : That part of it works. I need...]]> https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post401.html#401 Author: dwatch
Subject: 139
Posted: 02-March-2006 at 9:05am

That part of it works.  I need to add the part about the product into this though.

 

Example would be if the customer is xyz company and the product is a sku: tt33, then display a certain price.



Edited by dwatch - 02-March-2006 at 9:08am]]> Thu, 02 Mar 2006 09:05:53 +0000 https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post401.html#401 <![CDATA[displaying data bases on customer : I may be way off base but have...]]> https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post399.html#399 Author: watercrazed
Subject: 139
Posted: 02-March-2006 at 4:13am

I may be way off base but have you tried just pasting all of the the code for the display part of the form between your if and end if? I don't code but here is my guess.

if session("idcustomer")=1200 then

<-- start form-->

paste all of the form code here

<!-- end of ordering options and add to cart button -->

end if

Really not sure where you put your end if but, that is a guess. Maybe someone that actually knows asp will try to answer.

]]> Thu, 02 Mar 2006 04:13:07 +0000 https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post399.html#399 <![CDATA[displaying data bases on customer : Trying to display certain data...]]> https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post394.html#394 Author: dwatch
Subject: 139
Posted: 27-February-2006 at 11:23am

Trying to display certain data (pricing, etc)  on the viewprd.asp base on the customer and the product.

here is what i have so far

if session("idcustomer")=1200 then

'display data here

end if

I need help adding in the and idproduct= or idcategory= part of it.  Any input will be appreciated.

]]> Mon, 27 Feb 2006 11:23:25 +0000 https://forum.productcart.com/displaying-data-bases-on-customer_topic139_post394.html#394