It is strange that such a basic feature isn't supported, but I wouldn't say it makes Derby a toy DB. For years MySQL didn't support subqueries. It was frustrating (and still is for those of us who still have to support those versions) but practically every technology needs the odd workaround. e.g. regex in coldfusion
Blair On Dec 11, 2007 12:32 PM, Andrew Scott <[EMAIL PROTECTED]> wrote: > Blair, > > > > Here is the SQL to pagination code, this is a very simple example that can > be found on most blogs including mine to be used with CFGrid. > > > > There is no way that Derby can run this code, and maxrows is not an answer > to a problem like this. > > > > SELECT TOP #pagesize# ARTISTID, FIRSTNAME, LASTNAME, CITY, STATE > FROM ARTISTS > WHERE (ARTISTID NOT IN > (SELECT TOP #page# ARTISTID > FROM ARTISTS AS ARTISTS1 ORDER BY ARTISTID)) > ORDER BY ARTISTID > > > > > > > > > > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > > > *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On > Behalf Of *Blair McKenzie > *Sent:* Tuesday, 11 December 2007 12:27 PM > *To:* cfaussie@googlegroups.com > > *Subject:* [cfaussie] Re: Derby Embeded Database (CF8) and > Eclipse/FlexBuilder > > > > Um, is there a problem with using maxrows? I thought that it was included > for just this kind of reason - variations in DB support. > > Blair > > On Dec 11, 2007 11:17 AM, Andrew Scott < [EMAIL PROTECTED]> > wrote: > > > Geoff, > > You can't be serious can you... > > In a real world example when pagination is needed, and the data is > constantly changing it is not a good idea to cache the data and do a QoQ > on > the cached data. > > But then you knew that right? > > So if I am a buffoon, you must be my father. > > > > > > Andrew Scott > > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone:+613 8676 4223 > Mobile: 0404 998 273 > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] On > Behalf > > Of Geoff Bowers > Sent: Friday, 7 December 2007 8:07 PM > To: cfaussie > Subject: [cfaussie] Re: Derby Embeded Database (CF8) and > Eclipse/FlexBuilder > > On Dec 6, 1:22 am, "Andrew Scott" <[EMAIL PROTECTED]> wrote: > > As for Geoff, I bawk at anyone who says to cache the query and do a > > QoQ on that query. It might be a quick fix for now, but in the long > > run it is not a quick fix and should be refactored to be the best > > solution as quickly as possible. There is a good book that is out > > there on Software maintenance, and why one should not look at a band > > aid solution. Geoff's example, to me is a band aid solution and should > > be avoided at all costs. > > Do I really need to respond to this sort of stuff? I can only assume > you go out of your way to misconstrue people's posts to make yourself > feel important. You are a buffoon. > > -- geoff > http://www.daemon.com.au/ > > <br > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
