Do not get me wrong, I do not consider it a toy. Just makes it limiting in its practical usage. That is why I made my original statement, nothing against Charlie or Geoff, just that it went in a direction that wasn't really expected.
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:49 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder 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 < <mailto:[EMAIL PROTECTED]> [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: <mailto:cfaussie@googlegroups.com> [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 -~----------~----~----~----~------~----~------~--~---