Conntinuing on the Customer/Order example from my last post, we might want to only send some ads to customers who have ordered at least twice in the past. For this we'd first have to cunt all orders of our customers who haven't ordered for at least 100 days. So the first step is to create … Continue reading Glorp findings – using count:
If you are working with Glorp and DB2 and use #orderBy: you may have found out that the results of ordering by CHAR or VARCHAR columns may end up strange. DB2 assumes that a Small letter is less than a capitalized one. "Hans" is lower than "HANK". In my case this came obvious in a … Continue reading Glorp/DB2 – Tip: Sorting case insensitive
Sven just announced the availability of a new tutorial named "Reddit.st — In 10 Cool Pharo Classes".I am fascinated by how short and clear this piece is. It really explains all you need to know to get started building a Seaside Application using Glorp and Postgres as a database. It is nice to read and really covers … Continue reading Beautiful little tutorial on how to build a complete Seaside Application with an RDB Backend
For some of you, this is old hats. For me, it is a little victory that needs a little pause from coding and leaning back and looking outside at the sun and feel like a super hero. I just wrote my first more complex Glorp Query that actually works. Here is what it looks like: … Continue reading My first (somewhat) complex GLORP Query that actually works
Sometimes there are things that sound easy in the first place and then take a lot of time trying, yahooing and stackoverflowing etc. Lots of mosaic pieces are found on each iteration of the famous search-try-fail cycle. This is one of these. So what do we have? I wanted to add a double click handler … Continue reading Seaside: click a link using jQuery
Marten shares a source snippet on how to create a zip archive with VA Smalltalk: Today I was in the need to create a zip archive in VASmalltalk and zip-code had been introduced with the new Monticello Importer in version 8.5.2 (application: MZZipUnzipApp) Read the rest on his blog.
(Please note: the problems described here are not limited to Glorp. This is an issue to keep in mind in all O/R mapping technologies, not only in Smalltalk. What I'm talking about here is also relevant in other languages and frameworks. It just fits nicely into the Glorp Wisdom series) Some days are even worse … Continue reading Glorp Wisdom (pt. 313): Never make two collections exclusive that can share objects
There are days when you hunt for a bug and almost are close to giving up. On some of these, it's best to go home, play with your kids or watch a good movie and start again the next day. On some, however, you finally find out teh whole problem was just a case of … Continue reading Glorp Wisdom (pt. 312): Don’t reuse objects in exclusive relationships!
Well, a developer's day is full of victories and waterloos. So I've had my developer's day today. After I had discussed my Server startup problems related to ports already in use, Marten came up with an explanation for VAST's behavior on the VAST Support Group: The reason for this behaviour is located in the method: … Continue reading The WASstServerAdaptor story and its (preliminary) end