Hi;
The following doesn't work with or without enclosing the sets in quotes:
update products set SKU="prodSKU2", Category="prodCat1", Name="name2",
Title="title2", Description="descr", Price="22.55", SortFactor="500",
Availability="1", OutOfStock="0", Weight="5.5", ShipFlatFee="10.0",
ShipPercentPrice="5", ShipPercentWeight="2", sizes="('Extra-small', 'Large',
'Small', 'Medium', 'XLarge', 'XXLarge', 'XXXLarge')",
colorsShadesNumbersShort="('aqua:7FFFD4', 'blue:333399', 'gray:465945',
'navy-blue:CC7722', 'black:0000FF', 'maroon:B03060', 'purple:50404D',
'yellow:9ACD32', 'fuchsia:FF77FF')" where ID="2";
Everything inserts but the sets which throw warnings. What am I missing?
TIA,
Victor
--
The Logos has come to bear
http://logos.13gems.com/
