Menu

#67 add usrloc parameter to pick the getdate SQL function to use

ver 1.2.x
closed-accepted
None
8
2007-09-27
2007-03-27
No

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@longphone.fr

Discussion

  • Jerome Martin

    Jerome Martin - 2007-03-27

    Adds getdate_sql parameter to usrloc + documentation

     
  • Bogdan-Andrei Iancu

    • milestone: --> ver 1.2.x
    • priority: 5 --> 8
    • assigned_to: nobody --> bogdan_iancu
    • status: open --> open-accepted
     
  • Bogdan-Andrei Iancu

    Logged In: YES
    user_id=1275325
    Originator: NO

    Hi Jerome,

    good point - I will take care of this asap.

    thanks and regards,
    bogdan

     
  • Henning Westerholt

    Logged In: YES
    user_id=337916
    Originator: NO

    Commited to trunk at rev 2824.

    Cheers,

    Henning

     
  • Henning Westerholt

    • assigned_to: bogdan_iancu --> henningw
    • status: open-accepted --> closed-accepted
     

Log in to post a comment.