WebDAV: SEARCH Mothod -> Non-String-User Fields   

Hi,

the following SEARCH Method returns error "400 - Request is badly formed" in 
my user field "ADDWARE-UM3-SYNC-ABSID" is Non-String-Value (PT_LONG).
Why i cant query for this field?

btw: If i use String8-Types it works great. But i cant change field type 
(compatibility reasons)

    'the SQL query.
    strQuery = "SELECT ""urn:schemas:calendar:location"", 
""urn:schemas:httpmail:subject"", "
    strQuery = strQuery & " ""urn:schemas:calendar:dtstart"", 
""urn:schemas:calendar:dtend"", "
    strQuery = strQuery & " ""urn:schemas:calendar:busystatus"", 
""urn:schemas:calendar:instancetype"" "
    strQuery = strQuery & " FROM Scope('SHALLOW TRAVERSAL OF """ & 
strCalendarURI & """') "
    strQuery = strQuery & "WHERE ""DAV:contentclass"" = 
'urn:content-classes:appointment' "
    strQuery = strQuery & " AND ""ADDWARE-UM3-SYNC-ABSID"" = 777"

Stefan

date: Mon, 12 Mar 2007 13:06:30 +0100   author:   Stefan Uhlemann

Re: WebDAV: SEARCH Mothod -> Non-String-User Fields   

Hello,

you must cast the property to long:

strQuery = strQuery & " AND Cast(""ADDWARE-UM3-SYNC-ABSID"" as 'int') = 777"

If your property is a long value (64-bit), you must cast it to 'i8' instead 
of 'int'.

Best regards,
Henning Krause



"Stefan Uhlemann"  wrote in message 
news:%23hsbC6JZHHA.4264@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> the following SEARCH Method returns error "400 - Request is badly formed" 
> in my user field "ADDWARE-UM3-SYNC-ABSID" is Non-String-Value (PT_LONG).
> Why i cant query for this field?
>
> btw: If i use String8-Types it works great. But i cant change field type 
> (compatibility reasons)
>
>    'the SQL query.
>    strQuery = "SELECT ""urn:schemas:calendar:location"", 
> ""urn:schemas:httpmail:subject"", "
>    strQuery = strQuery & " ""urn:schemas:calendar:dtstart"", 
> ""urn:schemas:calendar:dtend"", "
>    strQuery = strQuery & " ""urn:schemas:calendar:busystatus"", 
> ""urn:schemas:calendar:instancetype"" "
>    strQuery = strQuery & " FROM Scope('SHALLOW TRAVERSAL OF """ & 
> strCalendarURI & """') "
>    strQuery = strQuery & "WHERE ""DAV:contentclass"" = 
> 'urn:content-classes:appointment' "
>    strQuery = strQuery & " AND ""ADDWARE-UM3-SYNC-ABSID"" = 777"
>
> Stefan
>

date: Mon, 12 Mar 2007 07:46:50 -0700   author:   Henning Krause [MVP - Exchange]

Re: WebDAV: SEARCH Mothod -> Non-String-User Fields   

Thanks alot! Works great

Stefan

"Henning Krause [MVP - Exchange]"  
schrieb im Newsbeitrag news:ORL7FVLZHHA.2320@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> you must cast the property to long:
>
> strQuery = strQuery & " AND Cast(""ADDWARE-UM3-SYNC-ABSID"" as 'int') = 
> 777"
>
> If your property is a long value (64-bit), you must cast it to 'i8' 
> instead of 'int'.
>
> Best regards,
> Henning Krause
>
>
>
> "Stefan Uhlemann"  wrote in message 
> news:%23hsbC6JZHHA.4264@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> the following SEARCH Method returns error "400 - Request is badly formed" 
>> in my user field "ADDWARE-UM3-SYNC-ABSID" is Non-String-Value (PT_LONG).
>> Why i cant query for this field?
>>
>> btw: If i use String8-Types it works great. But i cant change field type 
>> (compatibility reasons)
>>
>>    'the SQL query.
>>    strQuery = "SELECT ""urn:schemas:calendar:location"", 
>> ""urn:schemas:httpmail:subject"", "
>>    strQuery = strQuery & " ""urn:schemas:calendar:dtstart"", 
>> ""urn:schemas:calendar:dtend"", "
>>    strQuery = strQuery & " ""urn:schemas:calendar:busystatus"", 
>> ""urn:schemas:calendar:instancetype"" "
>>    strQuery = strQuery & " FROM Scope('SHALLOW TRAVERSAL OF """ & 
>> strCalendarURI & """') "
>>    strQuery = strQuery & "WHERE ""DAV:contentclass"" = 
>> 'urn:content-classes:appointment' "
>>    strQuery = strQuery & " AND ""ADDWARE-UM3-SYNC-ABSID"" = 777"
>>
>> Stefan
>>
>

date: Tue, 13 Mar 2007 08:51:33 +0100   author:   Stefan Uhlemann