I see that Eric Kraus was faced with a requirement normally met with a content query web part.  The problem?  He was in a pure WSS environment with no access to the CQWP.  Rather than curling up in the fetal position (an urge I have to fight every day, it seems), he came up with solution that at least gives WSS shops a fighting chance to succeed.  It's described here.