List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:January 6 2010 4:39pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman <mdykman@stripped> 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

Thread
Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
      • Re: Another Inserting Multiple Values with Set ProblemCarsten Pedersen6 Jan
        • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
          • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
            • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
              • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
                • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan