Thanks...your way MUCH better...I'm still a little confused on how to display the corresponding pfb files.
I want to be able to display the pfb fields from the fontspecs table based on the listing generated from the create-list.cfm. I'm not sure that my database is correct? You can download my files/database from the link below. http://members.rogers.com/phumes1/fonttest.zip At 09:19 AM 2/8/2002 +0100, you wrote:>index.cfm======================= ><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 >ListFind("Euro,European-Pi,Garamond,Helvetica",LCase(ListGetAt(GetFontFam >ily.sti,1,'.'))> > <input type="Checkbox" name="select" > value="#GetFontFamily.ID#" >checked onclick="this.checked=true;"> > <img src="../../images/blank.gif" width="3" > height="14" >alt="" border="0"><font >color="red"> #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# >[#GetFontFamily.ID#]</font><br> > <cfelse> > <cfinput type="Checkbox" name="select" >value="#GetFontFamily.ID#"> > #LCase(ListGetAt(GetFontFamily.sti,1,'.'))#<br> > </cfif> > </cfoutput> > </td> ></tr> ><tr> ><td class="navlinks"> ><input class="navlinks" type="submit" name="Action" value=" >Generate "> > <input class="navlinks" type="submit" name="Action" >value="Close" >OnClick="window.close()"> ><br> > ></td> ></tr> ></table> >>client-list.cfm==================== ><cfquery name="GetMyFonts" datasource="fontstyles"> > SELECT sti, ID, .... (all fields you want) > FROM fontsti > WHERE ID IN (#form.select#) > ORDER BY sti ></cfquery> >.. ><cfoutput query="GetMyFonts"> >#LCase(ListGetAt(GetMyFonts.sti,1,'.'))# <br> >#GetMyFonts.ID# <br> >.. ></cfoutput> > >In this query you have to use >WHERE ID in (#ListQualify(form.select,"'")#) >if ID is a non numeric field > >-----Original Message----- >From: phumes1 [mailto:[EMAIL PROTECTED]] >Sent: donderdag 7 februari 2002 17:26 >To: CF-Talk >Subject: Re: <CFQUERY > > >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"> #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# >[#GetFontFamily.ID#]</font><br> > <cfelse> > <cfinput type="Checkbox" name="select" >value="#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#"> > #LCase(ListGetAt(GetFontFamily.sti,1,'.'))#<br> > </cfif> > </cfoutput> > </td> ></tr> ><tr> ><td class="navlinks"> ><input class="navlinks" type="submit" name="Action" value=" >Generate "> > <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"> > > </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? > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
