On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman <mdyk...@gmail.com> wrote:
> so you dropped the quotes around the unneccessarily bracketed
> expression? It's hard to diagnose when your example isn't even what
> you think is syntactically correct.
>
Here's my example again. Syntactically correct. From my original post:
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";
>
> I can't find a reference, but i recall there is some limit on the
> length of SET member identifiers.. some of yours look longish, maybe?
>
They're not. Awaiting someone who can help me here.
TIA,
V
