QueryProvider Problem in MOSS
- From: lior <lior@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 14 Jan 2008 02:02:05 -0800
I have web part in Sharepoint Portal server 2003, (I wrote the code in VS
2003).
I try put this web part on MOSS portal but I get error about my QueryProvider.
What should I do In order it will be work? which changes should I do in the
code?
PortalContext context = PortalApplication.GetContext();
QueryProvider qp = new QueryProvider(context.SearchApplicationName);
SQL_QUERY ="SELECT " +
"\"urn:schemas-microsoft-com:sharepoint:portal:profile:FirstName\", " +
"\"urn:schemas-microsoft-com:sharepoint:portal:profile:LastName\" " +
"FROM " +
"( TABLE Portal_Content..Scope() " + "UNION ALL TABLE
Non_Portal_Content..Scope() ) " +
"WHERE "+
"(CONTAINS(\"urn:schemas-microsoft-com:sharepoint:portal:profile:FirstName\",
'\""+val+"*\"')" +
"OR
CONTAINS(\"urn:schemas-microsoft-com:sharepoint:portal:profile:LastName\",
'\""+val+"*\"')) ";
qp.SetProperty("Maximum Rows",_usersProfileAccounts.ToString());
ds = qp.Execute(SQL_QUERY);
The error that i get is on the property
"\"urn:schemas-microsoft-com:sharepoint:portal:profile:FirstName\", " +
"\"urn:schemas-microsoft-com:sharepoint:portal:profile:LastName\" " +
The error say that "this property was not found or not fixed to the Schem"
.
- Prev by Date: RE: MOSS WCM Field Control development issue
- Next by Date: Reports based on several SharePoint lists
- Previous by thread: MOSS 2007 Workflows with InfoPath 2007 & VS2008
- Next by thread: Reports based on several SharePoint lists
- Index(es):
Relevant Pages
|
