OK, I'll add this to the next version, probably fairly soon. Anthony...
Anthony & Melissa Ber...
berglas@...
Jan 2, 2004 6:56 am
738
Hello Sylvain, I have not looked at your code, but will do so in a few weeks. But I am still a little unclear what you are trying to do. Remember that the...
Anthony & Melissa Ber...
berglas@...
Jan 2, 2004 7:03 am
739
Look at the query I make in the modified SDriver and all we be clear. For a particular page just one round trip is made and only the wanted subset of records...
... query ... 1) Exactly. A cursor would have been better but making this work across databases made me cringe a little. So toying with SQL I came across a...
An integral number of the lowest common factor is the method that preserves the most flexibility in trapping rounding errors. So, for dollars, (amount=100,...
A few comments. First, from an application UI point of view, it annoys me personally to have to use lots of small pages to view data. I'd much rather scroll ...
Anthony & Melissa Ber...
berglas@...
Jan 11, 2004 12:06 am
744
... personally to ... scroll ... find etc. Of course. If I could I would query all my record and let the interface sort and filter it out. Much easier to do. I...
===== _________________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail :...
Im in the implementation of a filter function in a web application. I want to be able to say : Find all [persons] that have a [firstname] with the substring...
Hello Sylvain, If you have 5,000 records I would probably display the first 100 or so and have the user refine the the search. Paging does not really help...
Anthony & Melissa Ber...
berglas@...
Jan 16, 2004 5:22 am
749
Sylvain, Anthony, The problem here is that most people are used to the way Google does it, which is through paging. They then expect their app to work the...
Philippe Back (High O...
phil@...
Jan 16, 2004 9:36 am
750
The big issue is that Google ranks the pages fairly effectively, so paging makes sense because you will usually only need to look at a few pages. But if it...
Anthony & Melissa Ber...
berglas@...
Jan 16, 2004 10:39 am
751
Implementing OFFSET would be great because it helps in satisfying user requirements for paging in a painless way (leveraging simpleorm). I don't think that...
Philippe Back (High O...
phil@...
Jan 16, 2004 11:31 am
752
I think you are getting stuck up on the numbers. What if its 3 pages of a 100 records? A user might want to browse this. ... so ... to see ... record ... ...
My point exactly. You cant just display the first X and drop the rest. Sometimes the number of records returned will be a significant information to the user. ...
The way I see it, its a matter of scalability. Is it worth it to add this? I think so. From my investigation the implementation has to be driver specific. The...
OK, I'll look into this in the next release. But I need to know about different database implementations. Please let me know which drivers support an OFFSET...
Anthony & Melissa Ber...
berglas@...
Jan 17, 2004 12:57 am
756
MySQL : limit(start,end) Postgresql : top nbrec ... offset start MSSQL : no such keywords, use stored procedures or the scheme I have given Oracle : Unknown of...
For SQL Server: http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx http://www.rosca.net/writing/articles/serverside_paging.asp have interesting...
Philippe Back (High O...
phil@...
Jan 20, 2004 8:16 pm
758
Not badm, should be faster. Mine focused on preserving the original query pretty much intact. Had you looked at it? ... (page_number - 1) primary_key FROM...
Hi All, I was wondering if anyone have used some caching mechanism for SRecordInstances (other than Transaction caching). Essentially, all objects returned...
Yes but with all {0} {1} and stuff it was not too clear which parms did what. Okay, I was lazy. Or overbooked, you name it :-) Anyhow, I am now working on a...
Philippe Back (High O...
phil@...
Jan 21, 2004 8:10 am
761
Second vote for OSCache. Easy to use, very configurable. Lots of contexts of applicability (from JSP to my own caches). /Phil ... From: "awaragi"...
Philippe Back (High O...
phil@...
Jan 21, 2004 8:10 am
762
Hi Phil, Do you have any design or sample code (if possible) about how to use OSCache and your Simpleorm SRecordInstance objects? I have objects that change...
I do not cache Simpleorm SRecordInstace objects with OSCache. I use it for caching blocks of rendered HTML or ViewHelpers. This is where caching should go for...
Philippe Back (High O...
phil@...
Jan 21, 2004 4:13 pm
764
hi anybody who has a sample of the simpleorm.properties and where to put in after unzipping the file. thanks...
Hi, I'm building a J2EE application (3 Tier) using simpleorm. Has anyone experience doing this? Simpleorm combines data accessor objects and pure data objects....
Hi, Don't sent the object(s) back. Build a view of what you want to display and ship that. Most of the time the JSP doesn't care about getting a nice...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
