List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 6 2010 6:40pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
How about you show us the schema for the table so we know what is
defined as what?

Also, as the update does succeed, it would be interesting to see what
value actually got stored.  After you have accounted for each bit in
the stored value, we might have a clue about what is being truncated.

One thing I did just note: the hyphen in 'Extra-Small'.  Set
identifiers need to be valid mysql identifiers and the hyphen '-' is
not a valid identifier character (as it is an arithmatic operator).  I
can't imagine that those colons in the colour list are healthy either.

The point of a set identifier to be an easy mnemonic for a particular
bit value.  Nothing is gained by trying to represent data with the
identifier itself.

 - michael dykman


On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi <victorsubervi@stripped> wrote:
> On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder <hassan.schroeder@stripped
>> wrote:
>
>> On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi <victorsubervi@stripped>
>> wrote:
>>
>> > 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')",
>>
>> Lose the enclosing double-quotes and put all the values within a
>> single set of single quotes.
>>
>> > colorsShadesNumbersShort="('
>> > aqua:7FFFD4', 'blue:333399', 'gray:465945', 'navy-blue:CC7722',
>> > 'black:0000FF', 'maroon:B03060', 'purple:50404D', 'yellow:9ACD32',
>> > 'fuchsia:FF77FF')"
>>
>> e.g. (shortened for lazyness):
>>
>> colorsShadesNumbersShort = ('aqua:7FFFD4, blue:333399')
>>
>> > where ID="2";
>>
>> mysql> 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";
> Query OK, 1 row affected, 2 warnings (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 2
>
> mysql> show warnings;
> +---------+------+---------------------------------------------------------------+
> | Level   | Code |
> Message                      
>                          
>       |
> +---------+------+---------------------------------------------------------------+
> | Warning | 1265 | Data truncated for column 'sizes' at row
> 1                    |
> | Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort' at
> row 1 |
> +---------+------+---------------------------------------------------------------+
> 2 rows in set (0.00 sec)
>
> Guess again.
> V
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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