This is the alternative that I suggested in my response. This will actually create one <tr> for each book in the query. Again, I would strongly urge you to consider this presentation instead of having every book appear in a column of a table with a single row...
--IronFury On Wed, 05 December 2001, "Dave Cahall" wrote: > > I must be missing something because your question seems to be one that > represents the very thing that ColdFusion was developed to do. Display > records from a database. > > Lets start from the beginning. You say you want a dynamic table and from the > rest of the statements it appears that you just want a list of books > returned by the query in a table format. > > 1. Run a query to retrieve the records: > > <cfquery name="qBooks" datasource="BookDatabase"> > select bookId,title, author > from Books > where title like '#form.strLetter#%' > order by title > </cfquery> > > 2. Now build a table that displays the records: > > <table border="1" cellspacing="2" cellpadding="0"> > <tr> > <th>Title</th> > <th>Author</th> > </tr> > <cfoutput query="qBooks"> > <tr> > <td><a href="BookDetail.cfm?book=#qBooks.bookId#">#qBooks.Title#</a></td> > <td>#qBooks.Author#</td> > </tr> > </cfoutput> > </table> > > This results in a table that has one row "td" for each book returned by the > query. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of phumes1 > Sent: Wednesday, December 05, 2001 6:33 AM > To: [EMAIL PROTECTED] > Subject: Re: Creating table listing from database entries > > > > Hi, > > How would I go about creating a dynamic table from entries in my database? > > I have book names which I'm pulling from the database and displaying the > results based on where the user clicks on the alphabetical index. > > Just for testing I've created a table with ten <td>...</td> for the listing > of all books that start with the letter "A". Other letters have more or > less. > > How can I figure out how many books are being pulled from the database and > use that information to create the correct number of <td>...</td> or even > the complete table from the results? > > > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > > > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
