Hi Dave,
as far as I remember the ORDER BY is done on the rowid of the tables. I
would have to check the repository for changes in that area, but I do
not think we changed it from 1.0.2 (but I have not verified that). The
ASCENDING is not specified in the query.. so this takes me to the next
question: did you also update the DB and/or switch to a different DB ?
Could be a change in how the rowid is treated by the DBMS ?
If so, we could add an option to specify the ASCENDING order explicitly
to avoid different behaviors with different DBMS (this is just a guess,
of course :D)
Cheers,
Max
On 7/22/14, 3:48 PM, blain...@gdls.com wrote:
Hi Max,
Previously in 1.0.2 they were in ascending date order by date issued.
I think in 1.5.1 they are in ascending date order by date expiring.
Total guess on my part.
So for example, say I have 42 pages of certificates. On the old system
a certificate on page 42, appears on page 30 in the new system. Its
fellows around it are on different pages too.
Is this supposed to be this way?
Dave
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
