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