|
Home > Archive > Commerce Server General > March 2004 > How to : Access additional tables for product info.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to : Access additional tables for product info.
|
|
|
| Hi,
I'd like to access and display additional tables that have information like, Qty for different warehouse, around the country and also Special Rebates, Discounts etc. I wanted to know where in (maybe Global.asa) do I make some kind of declaration of this n
ew table/s and then how do I access them so that this information can be displayed on the details section of the relevant product.
ANy help will be appreciated.
Thanks you.
Kim
| |
| Michael O'Donovan [MSFT] 2004-03-29, 9:59 am |
| Hi Kim,
You probably want to look into the "join table" feature of the CS Catalog
API. It allows you to define an external SQL table as additional data for
your product. You can then access this data using the standard CS product
API, just like accessing product properties. It can also be a SQL View, so
that if you have a couple of tables you can still use the standard CS API to
get to the data.
More info is here:
For an .asp solution
http://msdn.microsoft.com/library/d...logobj_tsbp.asp
For an asp. net solution
http://msdn.microsoft.com/library/d...4082
.asp
and
http://msdn.microsoft.com/library/d...igsvcs_dums.asp
Hope this helps,
Michael
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kim" <anonymous@discussions.microsoft.com> wrote in message
news:FEC0B97E-0FBD-4C2B-8F45-F5BC5699B2AC@microsoft.com...
> Hi,
>
> I'd like to access and display additional tables that have information
like, Qty for different warehouse, around the country and also Special
Rebates, Discounts etc. I wanted to know where in (maybe Global.asa) do I
make some kind of declaration of this new table/s and then how do I access
them so that this information can be displayed on the details section of the
relevant product.
>
> ANy help will be appreciated.
>
> Thanks you.
>
> Kim
|
|
|
|
|