Hi all, can anyone shed a little light on this? I have a query (code below)
that I would like to add to the SECTION part of it. Instead of just pulling up
âKITâ, I would also like to pull up âSHARPâ. As it stands now,
everything works. I would just like to add categories (5 out of 15) to my
query.
<cfquery name="images" datasource="selectblades">
SELECT * FROM InvStatFile, ProdFile WHERE (InvStatFile.PartNo=ProdFile.photo)
AND Section = 'Kit'
ORDER BY SKU ASC
</cfquery>
<cfif images.available GT "5"><cfif images.RecordCount>
<!--- pick a random image from the query --->
<cfset current_image = RandRange(1, images.RecordCount)>
<cfoutput>
<table>
<tr>
<td><div align="center"><a
href="itemDetail.cfm?Photo=#images.photo[current_image]#" target="_self"><img
src="../images/#images.photo[current_image]#.jpg" border="0" width="100"
height="100" alt="#images.photo[current_image]#"></a></div></td>
</tr>
<tr>
<td><div align="center"><font
color="##FFFFFF">#images.shortdescr[current_image]#<br>
MSRP: #DollarFormat(images.MSRP[current_image])#
<br>
Our Price: #DollarFormat(images.salePrice[current_image])#
<br>
In Stock:
#images.available[current_image]#</font></div></td>
</tr>
</table>
</cfoutput>
</cfif></cfif>
Thanks All,
Nina
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253972
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4