Warnings are usually caused by type mismatches in what you try to put
in a column vs what it will actually hold. For example putting a
'asdf' in a char(3) will produce a warning because 'asdf' was
truncated to 'asd' Check your column types vs the data you tried to
insert.
-Eric
On 4/15/05, Andy Pieters <andy@stripped> wrote:
> Hi all
>
> Realizing maybe my first post wasn't clear enough...
>
> How can I determine the cause for a warning.
>
> The MySql version is 3.23.58
>
> The query I used was:
>
> UPDATE `shop_products` SET
> `name`='TestProd' ,
> `shopid`='20-302' ,
> `sdesc`='This is a test product' ,
> `ldesc`='Long description for the test product\r\n\r\nIt supports formatting but not
> objectss\r\n\r\n' ,
> `unit`='piece' ,
> `units`='pieces' ,
> `stock`='10' ,
> `unitprice`='20.00000' ,
> `tax`='0' ,
> `min_units`='1' ,
> `max_units`='' ,
> `delivery_inc_unitprice`='0.00000' ,
> `delivery_tax`='0' ,
> `delivery_time`='' ,
> `visible`='1' ,
> `active`=''
> WHERE `id`='1' LIMIT 1;
>
> Thank you all
>
> With kind regards
>
> Andy
>
> --
> Registered Linux User Number 379093
> -- ---BEGIN GEEK CODE BLOCK-----
> Version: 3.12
> GAT/O/CM d- s:+ a- C++++ UL++++ P+ L+++ E--- W+++ N++ o+ K w--- O+++ M- V
> PS+ PE++ Y+ PGP+++ t+ 5-- X R !tv b DI+++ D++ G e-- h+ r--- y+
> -- ---END GEEK CODE BLOCK------
>
> Check out these few php utilities that I released
> under the GPL2 and that are meant for use with a
> php cli binary:
>
> http://www.vlaamse-kern.com/sas/
> --
>
> --
>
>
>
--
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
