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, D
iscounts etc. I wanted to know where in (maybe Global.asa) do I make some ki
nd of declaration of this n
ew table/s and then how do I access them so that this information can be dis
played on the details section of the relevant product.

ANy help will be appreciated.

Thanks you.

Kim

[ Post a follow-up to this message ]

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...table_54082.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

[ Post a follow-up to this message ]