.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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.