Solved

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

Posted on 2003-11-04
3
222 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

770 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