Getting CFOUTPUT to Repeat

[otowny407]

Hi, I have a database that holds a Table called Authors. I also have a table
called Pub_Info which holds a lot of publications written by these authors. My
dilemma is when i query the database for the publication Title, LInk to
Publication (pdf format), and Author's Name, i get all the Publications from my
database, but it only prints 1 author's name. Each publication has multiple
authors. How can i get it to where all of the author's names are printed on
the screen?

[paross1]

If you do something like <cfoutput>#query_name.column#</cfoutput> you are only
going to get one value. On the other hand, if you do <cfoutput
query="query_name">#column#</cfoutput> you will loop through each row returned,
and see all of your data. You can also use the query attribbute in cfloop, but
cfoutput should work just fine.

Phil