[dev] kronolith MS-SQL support patch proposal

[Ben Chavet]

> Well, yes, that's ugly.

Thanks, I try :)

> I'd really rather figure out what setting is necessary for the datetime
> fields to work.

So would I!  I've already spent countless hours tinkering with  
settings and various queries, and searching google for the answer to  
that question, and this is the best I can come up with.

> If, however, it's really impossible,

I'm going to go with a "yes, it's really impossible".  Here's the  
kicker: if I echo the query just before it is executed, copy & paste  
that into the MS-SQL console, I get different results.  The query  
works fine in MS-SQL, returning the desired rows.  But, it returns 0  
rows every time with php.  The only explanation I can come up with is  
that the "meaning" of the datetime comparison value must be getting  
lost somewhere in the communication between php & mssql (ie. by the  
time it gets to mssql, it thinks it's a string, or something like  
that).  Of course, that's only a speculation, but it's all I've got.

> what I'd ask is that you change the patch so that in the setup  
> function it sets a "useUnixTimestamps" (or similar name) flag if the  
> dbtype is mssql. Then use that parameter in the rest of the checks,  
> instead of checking dbtype directly.

I can do that.

There's surprisingly little information on this subject.  Apparently  
php+mssql isn't a very common combination...

--Ben
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/dev/attachments/20060916/99dddfe9/attachment.bin