.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
LVL 2
turbosigAsked:
Who is Participating?
 
MauseCommented:
And about the books Ben Forta has some more books also an advanced coldfusion book (Advanced ColdFusion MX Web Application Development)

see http://www.forta.com/books/ for more information
0
 
MauseCommented:
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
0
 
mrmcfeelyCommented:
The O'Reilly books on ColdFusion are very good as well (as they usually are):

http://www.oreilly.com/catalog/coldfusion2/index.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.