Yeah, Im trying to be too clever here somewhere..
The query ..
<!--- Get List of Cart Items --->
<CFQUERY NAME="GetCartItems" datasource="#application.dsn#">
SELECT ItemIDPK, PartNum, ItemName, ItemCost, Quantity,
tblitems.itemsize
FROM tblItems, tblCartItems
WHERE itemID = ItemIDPK
AND CartIDPK = '#Cookie.CartID#'
</cfquery>Two tables exist tblitems which has 3,4,5,6,7,8,9 in itemsize and tblcartitems which has 5 set as default in itemsize
So the drop down poulates off tblitems.itemsize (which works fine)
I then need to compae whats in the cartitems.itemsize with whats in the list to get the selected option.
I think?
Regards - Paul
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
