| David Messner [MSFT] 2004-12-28, 2:49 am |
| You cannot search on data that only exists in the marshal data. SQL does
not index that data - it is an opaque blob. You will need to create
columns to explicitly hold the data you wish to search.
Look for major improvements related to searching baskets and orders in the
next version of Commerce Server.
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
From: "Jimut" <jimutbasa@yahoo.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: How to search on a field present in Marshall data column
Date: Tue, 28 Dec 2004 01:24:38 -0500
Organization: www.talkaboutsoftware.com
Message-ID:
< bab3c52f5acd2931587ad11c0d6ce876@localho
st.talkaboutsoftware.com>
X-Newsreader: www.talkaboutsoftware.com
Content-Type: text/plain;
X-Complaints-To: abuse@supernews.com
Lines: 21
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!newsfeed.freenet.de!feed.news.tiscali.de!uio.no!n
ews.tele.dk!news.tele.dk!small.news.tele.dk!sn-xit-02!sn-xit-06!sn-xit-01!sn
-post-01!supernews.com!corp.supernews.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15311
X-Tomcat-NG: microsoft.public.commerceserver.general
made a marshal data named as Zip_Code in line item level
And i want to access it using OrderGroupSearch
I am writing code as
OrderGroupSearchOptions Options = new OrderGroupSearchOptions();
Options.FetchOrderFormInformation = true;
Options.FetchLineItemInformation = true;
Options.Columns.Add("OrderFormLineItems.[Zip_Code]");
DataSet ds = new DataSet();
ds = ordGrpSearch.Search(Options);
But it is giving error that Zip_Code column does not exist so can anybody
so
lve the problem as how to access marshal data using this method
Also i have zipcode in another table named as OrderGroupAddresses but when
i
use that table as
Options.Columns.Add("OrderGroupAddresses.[Zip_Code]");
it is not taking the table name as a valid name
|