I'd like to select documents from the database by class via the following (based on the blog code): #set ($sql = ", BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Photos.PhotoClass' and obj.name<>'Photos.PhotoClassTemplate' and obj.id=prop.id.id and prop.id.name='category' and list='${category}' order by doc.name") This is fine, but I'd like to sort the results by another of the parameters ("date") instead of by document name. I'm not a database person, so I'm not sure how to accomplish this. Any guidance would be most helpful. --Brian D. Switzer e-mail: herkamur -=>at<=- canada -=>dot<=- com web: http://bswitzer.railfan.net/ ------------------------------------------------------------------------ -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws