[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 16:01
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Jerome Martin (tramjoe)
Assigned to: Nobody/Anonymous (nobody)
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

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

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