Re: Iteration syntax for UncommonSQL

Edi Weitz <[email protected]> 17 Jan 2003 12:23:10 +0100
Newsgroups gmane.lisp.uncommon-sql
Message-ID <[email protected]>
Matthew Danish <[email protected]> writes:

> Here's an extract from some actual code:
> 
>        (sql:do-query ((id filename mime-type file-size)
>                       [select [id] [filename] [mime-type] [file-size]
>                               :from [attachment]
>                               :where [= [request-id] (request-id self)]])
> 	...)
> 
> where id, filename, mime-type, and file-size are all slots in the
> attachment view-class.

But in this example the abstraction from the view classes is
completely lost. I had hoped that I could use a DO-QUERY which creates
instances of the view classes for me. Nick Levine's answer shows that
this works with CommonSQL but it doesn't seem to work with UncommonSQL
- see my reply.

Thanks,
Edi.