[dev] [cvs] commit: turba/lib Driver.php turba/lib/Driver sql.php

[Michael Rubinsky]

Quoting Michael Rubinsky <mike at theupstairsroom.com>:

> Quoting Jan Schneider <jan at horde.org>:
>
>> Zitat von Michael Rubinsky <mike at theupstairsroom.com>:
>>
>>> mrubinsk    2007-10-28 10:23:35 EDT
>>>
>>>  Modified files:
>>>    lib                  Driver.php
>>>    lib/Driver           sql.php
>>>  Log:
>>>  - Pass the date range to _getTimeObjectTurbaList() method
>>>  - Only get the bday field if we are searching for a bday
>>>
>>>  Now all I need to do is figure out how to do that date compare
>>> against a varchar field in the database...
>>
>> The question is whether this should be varchar at all. I used a date
>> field for birthdays since ages. OTOH, using a varchar with iso dates
>> is more portable and allows string comparisons.
>
> I assumed it was done for the latter reason...would a: 'WHERE   
> date_field BETWEEN '1970-01-01' AND '1970-01-31' be portable across   
> different sql servers?  I'm pretty familiar with MySQL, but wasn't   
> sure if this would work on others?

Jeez. Nevermind, stupid question.  Need to figure out how to compare  
only the month and day part in the database and not the  
year..otherwise it would be kinda pointless, wouldn't it? :)


>
>
> Thanks,
> mike
>
> --
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin



Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin
-------------- 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/20071028/38252414/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2013 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/dev/attachments/20071028/38252414/attachment-0001.bin