desperatly need help with query and SELECT statement
Exchange Server Forum Index Exchange Server
Discussion forums for Microsoft Exchange Server users.
Microsoft Outlook
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web ExchangeServerHelp.com
desperatly need help with query and SELECT statement

 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development
Author Message
Ron Harter
Guest
Posted: Thu Nov 18, 2004 4:56 am    Post subject: desperatly need help with query and SELECT statement Reply with quote
The following query gets a error when executed. The problem is with the
http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending namespace?


SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",
"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE "DAV:getlastmodified" >
CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND "DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY "DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.

Back to top
Michael
Guest
Posted: Thu Nov 18, 2004 11:51 am    Post subject: Re: desperatly need help with query and SELECT statement Reply with quote
As I see problem is following property without namespace part:

"/x00008101"

Michael
-------------------------------
If you need WebDAV API for Exchange server, use our component "WebDAV .NET
for Exchange".
Check out http://www.independentsoft.com

"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eBcZ8iPzEHA.2624@TK2MSFTNGP11.phx.gbl...
Quote:
The following query gets a error when executed. The problem is with the

http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending
namespace?


SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",

"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE "DAV:getlastmodified"

CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND "DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.
Back to top
Ron Harter
Guest
Posted: Thu Nov 18, 2004 11:20 pm    Post subject: Re: desperatly need help with query and SELECT statement Reply with quote
That was an error when I did the cut and paste, here is the actual query

SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",
"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105",
""http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046
}/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow traversal of
"http://XCH/exchange/rharter/Tasks"') WHERE "DAV:getlastmodified"
CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified" ASC

Can anyone see a problem with this query


--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com
"Michael" <michael@discussions.microsoft.com> wrote in message
news:ee3gHLTzEHA.2040@tk2msftngp13.phx.gbl...
Quote:
As I see problem is following property without namespace part:

"/x00008101"

Michael
-------------------------------
If you need WebDAV API for Exchange server, use our component "WebDAV .NET
for Exchange".
Check out http://www.independentsoft.com

"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eBcZ8iPzEHA.2624@TK2MSFTNGP11.phx.gbl...
The following query gets a error when executed. The problem is with the


http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending
namespace?


SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",


"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE
"DAV:getlastmodified"

CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND "DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.




Back to top
Michael
Guest
Posted: Fri Nov 19, 2004 2:32 am    Post subject: Re: desperatly need help with query and SELECT statement Reply with quote
"DAV:href" is non-searchable property. Remove it from SELECT.
You do not need to put it in SELECT because you will get is as part of
MultiStatus response

Michael
-------------------------------
If you need WebDAV API for Exchange server,
use our component "WebDAV .NET for Exchange".
Check out http://www.independentsoft.com


"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:OzhQYLZzEHA.1452@TK2MSFTNGP11.phx.gbl...
Quote:
That was an error when I did the cut and paste, here is the actual query

SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",

"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105",

""http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046
}/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow traversal of
"http://XCH/exchange/rharter/Tasks"') WHERE "DAV:getlastmodified"
CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified" ASC

Can anyone see a problem with this query


--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com
"Michael" <michael@discussions.microsoft.com> wrote in message
news:ee3gHLTzEHA.2040@tk2msftngp13.phx.gbl...
As I see problem is following property without namespace part:

"/x00008101"

Michael
-------------------------------
If you need WebDAV API for Exchange server, use our component "WebDAV
..NET
for Exchange".
Check out http://www.independentsoft.com

"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eBcZ8iPzEHA.2624@TK2MSFTNGP11.phx.gbl...
The following query gets a error when executed. The problem is with
the



http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending
namespace?


SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname",
"http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",



"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE
"DAV:getlastmodified"

CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND "DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.



Back to top
Ron Harter
Guest
Posted: Fri Nov 19, 2004 4:22 am    Post subject: Re: desperatly need help with query and SELECT statement Reply with quote
I removed it and still not working. It was working with the DAV:href in the
query, it stopped working after I added the stuff to retrieve the properties
from the
http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/x00008105"

namespace. What kind of magic do I need to do to be able to get these
properties????????????????
Other people must have come up on this problem, I am using VS 6.0 and
MSXML4, application is in VC++

--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com

--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com


"Michael" <michael@discussions.microsoft.com> wrote in message
news:uaEXV3azEHA.576@TK2MSFTNGP14.phx.gbl...
Quote:
"DAV:href" is non-searchable property. Remove it from SELECT.
You do not need to put it in SELECT because you will get is as part of
MultiStatus response

Michael
-------------------------------
If you need WebDAV API for Exchange server,
use our component "WebDAV .NET for Exchange".
Check out http://www.independentsoft.com


"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:OzhQYLZzEHA.1452@TK2MSFTNGP11.phx.gbl...
That was an error when I did the cut and paste, here is the actual query

SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname", "http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",


"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105",


""http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046
}/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow traversal of
"http://XCH/exchange/rharter/Tasks"') WHERE "DAV:getlastmodified"
CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified" ASC

Can anyone see a problem with this query


--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com
"Michael" <michael@discussions.microsoft.com> wrote in message
news:ee3gHLTzEHA.2040@tk2msftngp13.phx.gbl...
As I see problem is following property without namespace part:

"/x00008101"

Michael
-------------------------------
If you need WebDAV API for Exchange server, use our component "WebDAV
.NET
for Exchange".
Check out http://www.independentsoft.com

"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eBcZ8iPzEHA.2624@TK2MSFTNGP11.phx.gbl...
The following query gets a error when executed. The problem is with
the




http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending
namespace?


SELECT "DAV:href",
"http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname",
"http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",




"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM
SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE
"DAV:getlastmodified"

CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.





Back to top
Michael
Guest
Posted: Fri Nov 19, 2004 11:40 am    Post subject: Re: desperatly need help with query and SELECT statement Reply with quote
Try to replace properties with:



(task duedate)

http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/0x8105



and also



(task status)

http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046/0x8101



Michael

-------------------------------
If you need WebDAV API for Exchange server,
use our component "WebDAV .NET for Exchange".
Check out http://www.independentsoft.com





"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eISTR0bzEHA.2600@TK2MSFTNGP09.phx.gbl...
Quote:
I removed it and still not working. It was working with the DAV:href in
the
query, it stopped working after I added the stuff to retrieve the
properties
from the

http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/x00008105"

namespace. What kind of magic do I need to do to be able to get these
properties????????????????
Other people must have come up on this problem, I am using VS 6.0 and
MSXML4, application is in VC++

--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com

--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com


"Michael" <michael@discussions.microsoft.com> wrote in message
news:uaEXV3azEHA.576@TK2MSFTNGP14.phx.gbl...
"DAV:href" is non-searchable property. Remove it from SELECT.
You do not need to put it in SELECT because you will get is as part of
MultiStatus response

Michael
-------------------------------
If you need WebDAV API for Exchange server,
use our component "WebDAV .NET for Exchange".
Check out http://www.independentsoft.com


"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:OzhQYLZzEHA.1452@TK2MSFTNGP11.phx.gbl...
That was an error when I did the cut and paste, here is the actual
query

SELECT "DAV:href", "http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname",
"http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",



"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105",



""http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046
}/x00008101", "DAV:getlastmodified" FROM SCOPE("shallow traversal of
"http://XCH/exchange/rharter/Tasks"') WHERE "DAV:getlastmodified"
CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=CAST("urn:content-classes:task" as 'string') ORDER
BY
"DAV:getlastmodified" ASC

Can anyone see a problem with this query


--
Ron Harter
JP Mobile. Inc.
ron.harter@jpmobile.com
"Michael" <michael@discussions.microsoft.com> wrote in message
news:ee3gHLTzEHA.2040@tk2msftngp13.phx.gbl...
As I see problem is following property without namespace part:

"/x00008101"

Michael
-------------------------------
If you need WebDAV API for Exchange server, use our component
"WebDAV
.NET
for Exchange".
Check out http://www.independentsoft.com

"Ron Harter" <ron.harter@jpmobile.com> wrote in message
news:eBcZ8iPzEHA.2624@TK2MSFTNGP11.phx.gbl...
The following query gets a error when executed. The problem is
with
the





http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
namespace.

Did I set this up right? How do I get properties in the offending
namespace?


SELECT "DAV:href",
"http://schemas.jpmobile.com/webdav/surewave-guid",
"DAV:parentname",
"http://schemas.microsoft.com/mapi/proptag/x65e20102",
"urn:schemas:httpmail:textdescription",
"http://schemas.microsoft.com/mapi/priority",
"http://schemas.microsoft.com/mapi/subject",





"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/x00008105", "/x00008101", "DAV:getlastmodified" FROM
SCOPE("shallow
traversal of "http://XCH/exchange/rharter"') WHERE
"DAV:getlastmodified"

CAST("2004-10-17T21:49:13.306Z" as 'dateTime') AND
"DAV:contentclass"=
CAST("urn:content-classes:task" as 'string') ORDER BY
"DAV:getlastmodified"
ASC


Desperate in Dallas

--
Ron Harter
JP Mobile. Inc.






Back to top
 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server Dedicated Servers
New Topics Powered by phpBB