asked on

.getrows (asp) - what is the coldfusion equivelant and reference ideas.

Ok, this is actually a two part question, 1 code question and 1 reference question.

1. Is there a command in ColfFusion that mimics the .getrows command in .asp?

2. Ok, I am a newbie to ColdFusion, but it seems to be a technology I am needing to become very familiar with.

Can anyone recommend 1 or 2 EXCELLENT books on the subject. I have been developing in ASP for about 5 years, so I am not new to programming, just to the language. I learn very well through visual and sample ideas.

I just bought Ben Forta's Web Application Construction Kit, and this seems to be an exceptional introduction. I would like something a little more advanced which also has a nice reference.

Thanks guys. If I get multiple comments that I feel are appropriate, I will award additional points.

-I remain

Mause

To output the results of a query you use cfoutput!

so first execute a query like this:
<cfquery name="QUERYNAME" datasource="#DATASOURCE#">
select *
from users
</cfquery>

and then output them width:
<cfoutput query="QUERYNAME">
#username#<BR>
</cfoutput>

CFOUTPUT will then loop over al records from the query QUERYNAME

Mause

ASKER CERTIFIED SOLUTION

Mause

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mrmcfeely

The O'Reilly books on ColdFusion are very good as well (as they usually are):

http://www.oreilly.com/catalog/coldfusion2/index.html