ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I´ve created some customs profiles, like ComercialAddress, and others. Now I 
 
need to search in this customs profiles for some data. I´m using the 
 
ProfilesWebService.asmx, to get an ProfileManagementContext object and 
 
search for the registers in custom profiles. The problem is that the 
 
profile.GetSearchableEntities() method doesn´t "see" this custom profiles, 
 
just the "default" ones. 
 
Anyone know how I can search in my customs profiles using the Web Services? 
 
Any idea? 
 
Thanks!

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

CS2002 FP1 Com+ 
 
.. 
 
Having great difficulty with catalog searching.  I understand that 
 
freetext searches will not do implicit 'AND' for multi-word fulltext 
 
searches.  Therefore, I am trying to pass a 'CONTAINS' clause into the 
 
call.  Nothing is getting returned.  It seems that it must be throwing 
 
errors, but there is nothing in the app logs. 
 
Here is my code. 
 
s = "CONTAINS (*, '<search term>')" 
 
Set rs = m_objManager.Search(s, , _ 
 
m_objCatalog.CatalogName, _ 
 
cscP ...

Hello, 
 
I wonder what's the difference between AncestorCategories and 
 
CononicalCategories? 
 
Thanks, 
 
Ming

Hello, 
 
I'm using Catalog and Inventory Schema Manager to add new properties. First, 
 
I defined two languages (edit catalog meta data) - english and french. Then I 
 
tried to create new property (property definitions -> create new property) of 
 
type text. I'm trying to set a property to be multilingual, but save fails 
 
with "An invalid operation was performed on InventoryCatalog ." On the new 
 
property window I see the "Display Names" tab and if I check "Multilingual" I 
 
can also se ...

Hi all, 
 
I´m having this error when I try to search sql server 2005 in Visual Studio 
 
2005 / Commerce Server 2007, and I don´t know how to resolve it. I´ve alredy 
 
tried to delete, modify the Full-Text Index on my table, etc, etc, but 
 
doen´t did any difference. Any tips? 
 
"Full-text table or indexed view has more than one LCID among its full-text 
 
indexed columns. at System.Data.SqlClient.SqlConnection.OnError(SqlException 
 
exception, Boolean breakConnection (...)" 
 
Thanks!

Has anyone ever created a product for the catalog that is customizable - such 
 
as pre-print on a label, bag or other product the customer would want 
 
"customized" or printed with their specific name or logo?

Please Please tell me this is possible out of the box in MCS 2007 
 
We have a catalog with a whole set of Base Catalogs, Products, Relationships 
 
between products (in the same and across catalogs), Product Definitions, 
 
Product Categories and the works 
 
We need to be able to do updates in bulk from import sheets. We have been 
 
dinged because MCS no longer has the CSV import but they have agreed to be 
 
patient while we write our custom CSV tool. However I don't see a place where 
 
the ...

Hi, 
 
do you know how to create top-products ranking in CS 2007? 
 
E.g. how to display 10 top-selling products in each category? Or 10 
 
most-offen watched products. 
 
Is there a way to do this via CS API? 
 
regards, 
 
Pawel Tarnik

I need c# sample code to use this fucntion: get_DescendantProducts 
 
Thanks

Hi: I have unpacked a PUP file on another server. The catalogues are loaded 
 
but I dont see the categories being displayed. What is the issue? Please 
 
assist

I have been hammering my SQL2005 with multiple large imports from CS2007. It 
 
now seems broken and I've deleted all catalogs from it (through Catalog 
 
Manager). However, I cannot seem to do an import anymore. 
 
Which tables have to be touched and is there an SP to purge or rebuild the 
 
ProductCatalog tables? 
 
Thanks! 
 
Step.

I have a base catalog: 
 
BaseCat-->CategoryA-->CategoryB-->Product001 and want to add Product001 to 
 
VirtCat as follows: 
 
VirtCat-->CategoryX-->CatgoryY-->CategoryW-->Product001 
 
When I add a VirtualCatalogRule, Product001 is added to the top of the 
 
Category hierarchy an I cannot seem to be able to associate it with CategoryW. 
 
Thanks! 
 
Step.

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

When deleting a data row from a CatalogItemDataSet and then invoking 
 
UpdateItems(), Save() and Rebuild(true), the changes are not committed to the 
 
virtual catalog. 
 
Any ideas?

I have 50 000 products in a basecategory. I add all of them to a large number 
 
of virtual catalogs and then delete the products I don't need from the 
 
virtual catalog. does this make sense or shouls I just add the products 
 
individually? 
 
Thanks!

I seem to have a problem deleting and modifying products in a virtual catalog 
 
with three levels of categories: 
 
int numfound = virtCatalog.DeleteItems(String.Concat("ProductId = '", 
 
prodName, "'"), CatalogClassTypes.ProductClass); does not seem to find any 
 
products, although prodName is set to "xxxxx(basecatname)". 
 
Is there a better way to do this? 
 
Thanks!

We have a couple of different product definitions in our catalog. We need to 
 
relate these products with one another, however we need to add qualifications 
 
for these relationships. How do we do this? 
 
Ex: 
 
ProductDefinition A has products: 
 
A1, A2, ...... A10 
 
ProductDefinition B has products: 
 
B1, B2,.........B10 
 
Now products in the first group fit into the products in the second group 
 
and in multiple different ways. For example Product A1 could fit into product 
 
B1 in th ...

I have a theoretical Question. 
 
How does Commerce Server 2007 handle a product family in which let's say a 
 
new variant is added after a person placed an order for that product when 
 
it's variants didn't include that variant.  Here's an example: 
 
I sell shirts, and today, I sell them varying by color. My "Shirt" 
 
definition has a variant property called Color.  For months, I sell colored 
 
shirts and the orders are racking up.  Down the road, the manufacturer makes 
 
us a bad batch a ...

This is a total newbie question. 
 
When would one use virtual catalogs and when would one use CatalogDataSets? 
 
We have a base catalog that contains all our products, categories, 
 
relationships etc. 
 
Now we need to expose certain aspects to certain clients and other aspects 
 
to other clients. 
 
In my mind, I can create virtual catalogs and expose them, or create catalog 
 
sets and achieve the same result. Looks like catalogsets can have security 
 
tied to it, but nothing much else. S ...

CS2002 FP1 
 
Com+ Interface 
 
I have tried everything I can think of to get the search to do an 
 
'exact phrase' match.  Here is my code.  For example, say I want 
 
"monster mash". 
 
When m_SearchPhrase is "monster mash", the search does an implicit 
 
'OR'. 
 
When I try "monster and mash", I get no results at all. 
 
I have tried "'monster' and 'mash'", "monster 'and' mash" 
 
Nothing works 
 
Set rs = m_objManager.Search(, _ 
 
m_SearchPhrase, _ 
 
m_ObjCatalog.CatalogName, _ 
 
cscProdu ...

After doing a whole bunch of Profiler and Query diving, I've come to the 
 
conclusion that the RC1 release of CS2007 ranking doesn't work properly.  The 
 
RANK column from the Catalog_Hierarchy table is not getting pulled in the 
 
query Ctlg_GetCategoryResults. It's always returning 0.  Can someone tell me 
 
why this happens or if this is a known bug?  it's driving me crazy :) 
 
Thanks, 
 
Dave

I'm trying to search for a product that exists in 2 different categories with 
 
no success. Is it possible to do such a search? 
 
I'm using the following CategoriesClause: 
 
catalogSearch.CategoriesClause = CatalogItemsDataSetSchema.CategoryName + 
 
"'=books AND " + CatalogItemsDataSetSchema.CategoryName + "=pirates"; 
 
This returns no results even though the product is in both the 'books' 
 
category and the 'pirates' category. 
 
If I use an 'OR' or an 'IN ('books','pirates')' instead of  ...

I have just looked at the tables in SQL 2005 and it seems that Products in a 
 
virtual catalog based upon a base catalog are copied in full. This means that 
 
there is no advantage in SQL 2005 storage to use virtual catalogs as opposed 
 
to base catalogs. Is this correct, please? 
 
Also, is there a limitation on the number of base catalogs I can create ? I 
 
need about 200, with each containing about 15 000 products in various 
 
categories. 
 
Thanks, 
 
Step.

I read in the documentation that ranking of products/categories can be done 
 
through the CatalogItemsDataTable collection.  The example shows a firehose 
 
method of ranking products/categories.  In our use case, I have the 
 
CatalogItemsDataTable collection of categories bound to a grid.  When the 
 
user clicks the "reorder" button, I need to loop through the grid and 
 
individually order the rows as the user has specified.  The problem is that 
 
to get the preceise category I want, I hav ...