Hi Doug, I think you need to quote "imgsml=C2BUWS1028.jpg," like imgsml='C2BUWS1028.jpg',
take care, /Johan
[EMAIL PROTECTED] wrote:
This has to be something silly, but I can not see it. Any help greatly appreciated:
use newshop; insert into products set storeid=2, deptid=5, groupid=66, prodid='C2BUWS1028', prodtitle='<b>Antique Circle 6/20; 1/2inches-lg Pearl Buttons & Novelty Buttons</b>', proddesc1='3 buttons per card; 1/2 inches', price=3.75, imgsml=C2BUWS1028.jpg, imgsmlwidth=105, imgsmlheight=105, discid=12;
gets
ERROR 1109 at line 2: Unknown table 'C2BUWS1028' in field list
mysql> explain products; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | storeid | varchar(50) | | PRI | | | | deptid | varchar(50) | | PRI | | | | groupid | varchar(50) | | PRI | | | | prodid | varchar(50) | | PRI | | | : :
If I put all the col=value entries on one line it seems to work. I am generating a bunch of these so I can format them in any manner that works. It seems that
set col1=value1, col2=value2, ...
can not be continued> Is this correct?
Thanks for any pointers
_____ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601
-- Johan Höök, Facility Engineering Group - MailTo:[EMAIL PROTECTED] - http://www.pythagoras.se Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden Phone: +46 8 760 00 10 Fax: +46 8 761 22 77
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]