[postmodern-devel] Help with query replacement

[Marijn Haverbeke]

Hi,

> By paging, I meant paging in the web pages - if I have 100
> results to a query, I would like to show that to the user in chunks of
> 20 rows over 5 pages

Ah, I see what you mean now. And I suppose it would be possible to
write some kind of macro for that. Or make the query a real run-time
list, and use compile-query to execute it. I don't have a lisp or very
much time right now, so I won't help you write the functions, but you
can bug the people in #lisp on irc about it or something if you can't
figure it out.

> Also, the element :count was not added to postmodern - I have checked
> the source too. So, I have to use :raw for now - please correct me if
> I'm wrong.

Did you try (sql (:count '*))? It works. By magic.

Actually, S-SQL has a fallback rule for operators it does not know.
They are rendered as simple function calls -- function(arg1, arg2,
...) -- so things like :count and any stored procedures you might
define work without the need for defining the operators.

Regards,
Marijn