[Devel] [ openser-Patches-1689180 ] add usrloc parameter to pick the getdate SQL function to use

[SourceForge.net]

Patches item #1689180, was opened at 2007-03-27 17:01
Message generated for change (Comment added) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743022&aid=1689180&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
>Group: ver 1.2.x
Status: Open
>Resolution: Accepted
>Priority: 8
Private: No
Submitted By: Jerome Martin (tramjoe)
>Assigned to: Bogdan (bogdan_iancu)
Summary: add usrloc parameter to pick the getdate SQL function to use

Initial Comment:
Currently, the select statement fetching valid (not expired yet) usrloc entries uses the "now()" SQL function, and this is hardcoded. However, not all DB have this function, typically MS SQL Server does not. In MS SQL Server, the correct function is "getdate()".

This patch adds a parameter (called getdate_sql) to usrloc module. Patch to sgml / README documentation is included too.

Jerome Martin
jmartin at longphone.fr

----------------------------------------------------------------------

>Comment By: Bogdan (bogdan_iancu)
Date: 2007-05-04 20:59

Message:
Logged In: YES 
user_id=1275325
Originator: NO

Hi Jerome,

good point - I will take care of this asap.

thanks and regards,
bogdan

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743022&aid=1689180&group_id=139143