I wanted to know.
Is it possible to have a query that for example returns 5 firstnames and 5 lastnames
<cfquery name="getNames" datasource="#ds#">
select firstname, lastname
The results would be:
How can I do this.. I hope i made sense.