cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geoff Drake <geo...@mandes.com>
Subject Re: Note on using SLECT COUNT(*) with the XSP SQL tag lib
Date Fri, 14 Jul 2000 12:15:46 GMT


You will need to check that your SQL Engine supports column aliases, if
it does try

    SELECT COUNT(*) AS NUMROWS FROM xxxxx

This will give you a column called NUMROWS

i.e.   <NUMROWS>11</NUMROWS>

The AS xxxx might be different on your engine.

Regards
Geoff

Ulrich Mayring wrote:

> Yann wrote:
> >
> > Right, I have a simple SQL query (SELECT COUNT(*) FROM Whatever).
>
> The SQL processor returns something like <NULL>11</NULL>, if count(*)
> were to come out to 11.
>
> Ulrich
>
> --
> Ulrich Mayring
> DENIC eG, Systementwicklung
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message