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?
______________________________________________________________________
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
