Cassidy
NETPACQ Systems, Inc. "Full Service Web Media" 5205 Kearny Villa Way, Suite 106 San Diego, CA 92123-1410 Voice - 1-858-541-0222 Fax - 1-858-874-7771 [EMAIL PROTECTED] http://www.netpacq.com
At 12:35 PM 6/21/2003 -0700, you wrote:
I'm trying to load a couple tons of data into a shopping cart system and for some reason it keeps kicking back with an error. I'm too dumb to figure out why. Can anyone tell me what's wrong with this code and why it doesn't work?
INSERT INTO 'products' VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '0000-00-00 00:00:00', '0.00', 1, 1, 1, 0);
The table itself looks like this CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) TYPE=MyISAM AUTO_INCREMENT=30 ;
and I myself look like http://www.dibcomputers.com/images/headbang.gif at the moment. ;)
TIA!
