Re: Error whilst processing ORDER BY clause

From: Tom Rizzo [MSFT] (thomriz_at_microsoft.com)
Date: 03/16/04

  • Next message: Dave Z: "Alert Manager Event Interface" 
    Date: Tue, 16 Mar 2004 09:38:18 -0800

    My guess would be that you need to CAST it to a boolean since it is assuming
    it's a string.

    Tom 

    --
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint?  Check out http://www.microsoft.com/MSPress/books/5517.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart M" <anonymous@discussions.microsoft.com> wrote in message
news:1FFA4505-DDF2-457D-9942-415602DCFA5F@microsoft.com...
> Our application is trying to perform the following SQL SELECT query
against a folder in the Exchange 2003 mailbox store using the documented
"ADO.Recordset" method over the "ExOleDB.Datasource" provider:
>
> "SELECT "DAV:href", "DAV:displayname", "urn:schemas:httpmail:read" FROM
SCOPE('shallow traversal of "http://server/administrator/inbox"') WHERE
"DAV:isfolder" = False AND "DAV:ishidden"= False ORDER BY
"urn:schemas:httpmail:read" ASC"
>
> We receieve the error "Error whilst processing ORDER BY clause in the SQL
statement", HRESULT = 0x8055002b, when the statement is executed.
> If we remove the "ORDER BY" clause it succeeds, or change the property
name in the clause to reference a string or int data type it also succeeds,
but it refuses to sort by the boolean "urn:schemas:httpmail:read" property.
Is this a limitation in the provder or information store? Can we use a CAST
to perform the search or another method entirely? We want to order message
item in a folder display by several properties, the first being wether the
item is read so that unread items always appear at the top.
>
> Any help on this issue would be appreciated.
> Stuart M
>
  • Next message: Dave Z: "Alert Manager Event Interface"

    Relevant Pages

    • Re: Error whilst processing ORDER BY clause
      ... My guess would be that you need to CAST it to a boolean since it is assuming ... > We receieve the error "Error whilst processing ORDER BY clause in the SQL ... name in the clause to reference a string or int data type it also succeeds, ... Can we use a CAST ...
      (microsoft.public.exchange2000.information.store)
    • Re: Error whilst processing ORDER BY clause
      ... My guess would be that you need to CAST it to a boolean since it is assuming ... > We receieve the error "Error whilst processing ORDER BY clause in the SQL ... name in the clause to reference a string or int data type it also succeeds, ... Can we use a CAST ...
      (microsoft.public.exchange2000.development)
    • Re: Error whilst processing ORDER BY clause
      ... My guess would be that you need to CAST it to a boolean since it is assuming ... > We receieve the error "Error whilst processing ORDER BY clause in the SQL ... name in the clause to reference a string or int data type it also succeeds, ... Can we use a CAST ...
      (microsoft.public.exchange2000.general)
    • Re: Error whilst processing ORDER BY clause
      ... My guess would be that you need to CAST it to a boolean since it is assuming ... > We receieve the error "Error whilst processing ORDER BY clause in the SQL ... name in the clause to reference a string or int data type it also succeeds, ... Can we use a CAST ...
      (microsoft.public.exchange2000.misc)
    • Re: TRUE and FALSE are treated differently
      ... No -- you can't echo a boolean in PHP. ... the boolean is implicitly cast to a string. ... If you look up the manual on type casting, you'll find that FALSE is cast to an empty string, and TRUE is cast to a non-empty string. ...
      (comp.lang.php)
    Loading