Re:

[phumes1]

Hi,

This is a continuation from yesterday. I have a file index.cfm with the 
below code in it:

<table border="0" cellspacing="0" cellpadding="0">
<tr>
<cfform action="create-list.cfm" name="checkboxform" method="POST">
        <cfquery name="GetFontFamily" datasource="fontstyles">
                SELECT      sti, ID
                FROM        fontsti
                ORDER BY sti
        </cfquery>

        <td class="dirlinks">
        <cfoutput query="GetFontFamily">
                <cfif #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Euro' OR
                          #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'European-Pi' 
OR
                          #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Garamond' OR
                          #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Helvetica' 
OR'>
                        <input type="Checkbox" name="select" 
value="#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#" checked="Yes" 
required="Yes" onclick="this.checked=true;">
<img src="../../images/blank.gif" width="3" height="14" alt="" 
border="0"><font 
color="red">&nbsp;#LCase(ListGetAt(GetFontFamily.sti,1,'.'))# 
[#GetFontFamily.ID#]</font><br>
                <cfelse>
                        <cfinput type="Checkbox" name="select" 
value="#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#">
                        &nbsp;#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#<br>
                </cfif>
        </cfoutput>
        </td>
</tr>
<tr>
<td class="navlinks">
<input class="navlinks" type="submit" name="Action" value=" Generate ">
&nbsp;<input class="navlinks" type="submit" name="Action" value="Close" 
OnClick="window.close()">
<br>

</td>
</tr>
</table>


This gets submitted to "create-list.cfm" which creates a list of the following:

Euro
European-Pi
Garamond
Helvetica



<table border="0" cellspacing="0" cellpadding="0">
<tr>
        <td class="dirlinks">
        <cfoutput>
                #REReplace(FORM.select,",","<br>","ALL")#
        </cfoutput>
        </td>
</tr>
<tr>
        <td class="navlinks">
                &nbsp;
        </td>
</tr>
</table>

How can I loop through the above results using a <CFQUERY to display 
additional fields (corresponding .PFB files) of each font family from my 
database?
______________________________________________________________________
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists