<div>
To me its not very clear what exactly you are after, can you eleborate if danrosenthals answer is not the answer your after, if it then don't worry ;-)
</div>


To me its not very clear what exactly you are after, can you eleborate if danrosenthals answer is not the answer your after, if it then don't worry ;-)

<div>
Hi SolverSurfer,<br />
<br />
That makes two of us, have no idea what exactly you want the group by, looks like name, size.<br />
<br />
Regards<br />
Plucka
</div>


Hi SolverSurfer,

That makes two of us, have no idea what exactly you want the group by, looks like name, size.

Regards
Plucka

<div>
dan: with all due respect sir, ur code has got two group by's, i don't know why u need the one extra group by .., u could avoid it in the cfquery and only use it in the cfoutput.<br />
<br />
Other than that ur solution should rock ;-)<br />
<br />
SolverSurfer : Just a general advice, avoid using keywords like Name, Group etc.. as field names...<br />
<br />
Regards<br />
Hart<br />
<br />
<br />

</div>


dan: with all due respect sir, ur code has got two group by's, i don't know why u need the one extra group by .., u could avoid it in the cfquery and only use it in the cfoutput.

Other than that ur solution should rock ;-)

SolverSurfer : Just a general advice, avoid using keywords like Name, Group etc.. as field names...

Regards
Hart




<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; If my table T1 is:<br />
&nbsp; &nbsp; ID &nbsp; &nbsp;Name &nbsp; group<br />
&nbsp; &nbsp; 2 &nbsp; &nbsp; asdfas &nbsp; &nbsp; mike<br />
&nbsp; &nbsp; 3 &nbsp; &nbsp; klj;lkj &nbsp; &nbsp; &nbsp; larry<br />
&nbsp; &nbsp; 4 &nbsp; &nbsp; kljlj &nbsp; &nbsp; &nbsp; &nbsp; mike<br />
<br />
<br />
Is it possible to perform a single query that would do this:<br />
<br />
Group Mike-Size=2<br />
2 &nbsp; asdfas<br />
4 &nbsp; kljlj<br />
<br />
Group larry-Size=1<br />
3 klj;lkj<br />
<br />
??<br />
<br />
Nick
</div>
</div>


Hi,
  If my table T1 is:
    ID    Name   group
    2     asdfas     mike
    3     klj;lkj       larry
    4     kljlj         mike


Is it possible to perform a single query that would do this:

Group Mike-Size=2
2   asdfas
4   kljlj

Group larry-Size=1
3 klj;lkj

??

Nick

A single query

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.