[thelist] SQL: using GROUP BY and COUNT
Madhu Menon
webguru at vsnl.net
Tue Aug 20 01:13:06 CDT 2002
At 11:02 AM 20-08-02, rudy wrote:
> <cfoutput query=contactquery>
> #cPhone# <br />
> </cfoutput>
>
>no getrows, no arrays, no explicit loops, no indexes, no upper bounds...
>
>just a neat stack of phone numbers
>
>don't want 'em stacked? don't use a <br />, use a comma or something
It's trivial to write a function in ASP that does this and call that
function instead.
Regards,
Madhu
<<< * >>>
Madhu Menon
Internet User Experience Consultant
Site Architecture · Interfaces · Usability · Net Strategy
e-mail: webguru at vsnl.net
More information about the thelist
mailing list