Page 1 of 1

unknown column

Posted: Mon Jan 11, 2010 1:58 pm
by michaelk46
Anyone know why I get Error: Unknown column 'caption3' in 'field list'

when I run this
INSERT INTO pages (retailprice, salesprice, upc, sku, categoryid, manufactureid, caption, pagename) VALUES (11.11, 1.01, 12345678901, 1234567, 8, 4, caption3, pagename3);

Here is what the columns look like in the table...
Image

Re: unknown column

Posted: Mon Jan 11, 2010 3:18 pm
by Christopher
You need to put quotes around "caption3" and "pagename3".

Re: unknown column

Posted: Mon Jan 11, 2010 3:33 pm
by michaelk46
Thanks for the help... It's fixed