Export off all Products with url-link

Thomas

unread,

Aug 26, 2003, 2:55:17 AM8/26/03

to

Hello,

One of our vendors requested us a database-table with 3
fields ;
1st field = Product.
2nd field = complete url of that product.
3d filed = complete url of product-picture

This could also be used as a site-map for all products

Any suggestion is welcome.

Thanks,

Thomas Verschelde
Belgium

Vinayak Tadas [msft]

unread,

Aug 26, 2003, 5:54:02 PM8/26/03

to

Your question is not very clear. What exactly do you want to do. Are you
using the catalog system to store your products?

Thanks
Vinayak Tadas
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

"Thomas" <tver...@yahoo.com> wrote in message
news:01f201c36b9f$01d9f820$a001...@phx.gbl...

Thomas

unread,

Aug 27, 2003, 3:33:36 AM8/27/03

to

Ok, sorry.

We are using CS2000,and the catalog system to store our
products.
When you select a category you only get the products from
that category.
We need an asp-page that displays all products of all
categories in one time so imagine there is only 1
category.

In clear (I hope) this means that one of our dealers wants
to use this information in his website.
He uses following record for his products-database:

1)Model: (this is Name from business desk)

2)Foto:( this is Image_filename from BSD )here he wants
complete URL to Image_filename

3)Link to Fabrikant: here he wants our URL to Model(name
in BSD)

Hope this is Clearer

Thanks,
Thomas

>.
>

Vinayak Tadas [msft]

unread,

Aug 27, 2003, 5:20:05 PM8/27/03

to

You can use the following code

Set oCatMan = CreateObject("Commerce.CatalogManager")
call oCatMan.Initialize("siteName",false)

startingRecord = 1
NumRecordstodisplay = 10000
RecordsReturned
Set oProducts = oCatMan.Query("1=1", "CatalogName", 12, "Commaseparated list
of properties to return eg Name,Image_filename ...", "Propertyto sort the
recordset by eg Name", -1, startingRecord, NumRecordstodisplay,
RecordsReturned)

The RecordsReturned contains the total number of products in the catalog.
oProducts contains all the products in the catalog.
You can iterate through the oProducts recordset and display the products on
the asp page.

Thanks
Vinayak Tadas
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
"Thomas" <tver...@yahoo.com> wrote in message

news:0a4201c36c6d$86ffc510$a101...@phx.gbl...

Thomas

unread,

Aug 29, 2003, 2:40:44 AM8/29/03

to

Thank you Vinayak, thats what we needed

Thomas

>.
>