Solved

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

Posted on 2003-11-04
3
220 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:turbosig
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Mause
ID: 9679843
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
 
LVL 10

Accepted Solution

by:
Mause earned 20 total points
ID: 9679868
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
 
LVL 4

Expert Comment

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

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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now