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])# 
&nbsp;&nbsp;&nbsp;&nbsp; <br>
                    Our Price: #DollarFormat(images.salePrice[current_image])# 
&nbsp;&nbsp;&nbsp;&nbsp; <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

Reply via email to