> I have:
> productlist = "1,2,3,4"
> quantitylist = "2,1,1,1"
>
> and i want to
>
> SELECT tblProduct.*,
> tblProductSize.productsizeSize,
> tblProductWeight.productweightWeight,
> tblProductColor.productcolorColor
> FROM ((tblProduct
> LEFT JOIN tblProductColor
> ON tblProduct.productId =
tblProductColor.productcolorProductId)
> LEFT JOIN tblProductSize
> ON tblProduct.productId =
tblProductSize.productsizeProductId)
> LEFT JOIN tblProductWeight
> ON tblProduct.productId =
tblProductWeight.productweightProductId
> where tblProduct.productId IN (#ShoppingCart_Product#);
>
> and then to output:
>
> <cfoutput>
> <tr>
> <td> #productname# </td>
> <td> #productDesc# </td>
> etc...
> <td> QUANTITY GOES HERE </tD>
> </tr>
> </cfoutput>
>
> I want to add a <td> to the <cfoutput> table row that include the quantity
of
> the product, as contained in quantitylist
IF ShoppingCart_Product is the same as productlist
then just do
<cfoutput>
> <tr>
> <td> #productname# </td>
> <td> #productDesc# </td>
> etc...
> <td> #ListGetAt(quantitylist,ListFind(productlist ,productId))#</tD>
> </tr>
> </cfoutput>
~Justin
>
> :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
> Jon Tillman
> LINUX USER: #141163
> ICQ: 4015362
> [EMAIL PROTECTED]
> http://tillman.freehosting.net
> :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.