Phil zaries@global.co.za writes:
I am looking for an example of how to create a s-sql query on the fly. I am sure I saw something like that along the line on some website but I cant find it again.
Take a look at http://repo.or.cz/w/cl-trane.git?a=blob;f=src/taxonomy.lisp;h=5776b2b42dde27...
Query building takes place e.g. on lines 274-304 and 365-394. Second example may be interesting: it's a way to generate CASE statement from list of values (it may be generalized to receive alists, I just needed the order), to effectively make an inline-dictionary without writing the CASE statement by hand.
Regards, Maciej.