[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 87837] Server response could not be interpreted when trying to
From:       Aaron Williams <aaron_williams () net ! com>
Date:       2004-11-23 23:45:44
Message-ID: 20041123234544.12935.qmail () ktown ! kde ! org
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
        
http://bugs.kde.org/show_bug.cgi?id=87837        




------- Additional Comments From aaron_williams net com  2004-11-24 00:45 -------
I had problems with the patch that was provided for korganizer for 
downloading information from our Exchange 2003 server.  The below query 
works.  It will also probably work without the "ORDER BY" statement.  I 
based this off of something I found on a Microsoft web site.

-Aaron

QString ExchangeDownload::dateSelectQuery( const QDate& start, const 
QDate& end )
{
  QString startString;
  startString.sprintf( "%04i-%02i-%02iT00:00:00Z", start.year(),
                       start.month(), start.day() );
  QString endString;
  endString.sprintf( "%04i-%02i-%02iT23:59:59Z", end.year(), end.month(),
                     end.day() );
  QString sql =
        "SELECT \"DAV:href\", \"urn:schemas:calendar:instancetype\", "
        "\"urn:schemas:calendar:uid\"\r\n"
        "FROM Scope('shallow traversal of \"\"')\r\n"
        "WHERE \"urn:schemas:calendar:dtend\" >= CAST(\"" + startString 
+ "\" as 'dateTime')\r\n"
        "AND \"urn:schemas:calendar:dtstart\" < CAST(\"" + endString + 
"\" as 'dateTime')\r\n"
        "AND \"DAV:contentclass\" = 'urn:content-classes:appointment'\r\n"
        "ORDER BY \"urn:schemas:calendar:dtstart\" ASC";
  kdDebug() << "dateSelectQuery is " << sql << endl;
  return sql;
}

>>    
>>
[prev in list] [next in list] [prev in thread] [next in thread]