Earlier today, Ray Camden posted a quick ColdFusion-centric solution to showing only the Nth records of a query. His solution is fine, but I wonder how itwould perform for large queries on a site under high load. Here’s a database-centric solution that pulls back every Nth record, allowing CF to just display the final record set.
Since I’m so late in covering the rest of my MAX trip, I’ll just hit the highlights and link to extended coverage elsewhere.
The first day of MAX was so very interesting. Even though there were more attendees than last year, the layout of the Moscone West convention center made for a much better experience. The Unconference sessions that ran alongside the official sessions weren’t just the icing on the cake. Sometimes they were the cake (not a lie).
Before MAX even got underway, I spent an afternoon at Adobe HQ with a bunch of other ColdFusion die hards. Apparently, the plethora of ColdFusion sessions available at MAX weren’t enough for some of us. Afterwards, beer!
I’ve been working on a new feature for my company’s main application. Basically I need to associate some data with a list of students. The list of students is generated from existing class rosters. Since students can be in more than one class, it’s possible the same student gets selected twice. So how can I quickly remove any duplicates and store only the unique list of students?
Justin Treher asks: “Yo, Adrian. I see that you are using autonumber for your tables. Whenever you run the CREATE method in the DAO you are just returning true. How does the application get the ID?”
My first project at my new job is to create usage reports for our product. I started building a UI with HTML, Jquery and ColdFusion, but I soon realized that we were going to need a more fluid interface to the data.
Now that our ACME stack has been installed, let’s setup some isolated development areas. To do this, we need to create one or more Virtual Hosts in Apache and setup some local domains.
We’re in the final stretch. We’ve got Apache, ColdFusion and MySQL up and running. Now we need a way to write some actual ColdFusion code in Linux. For that, we need the Eclipse IDE and a few plug-ins, primarily CFEclipse.