var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tell me whats wrong with this UPDATE query
I have wacked my head over this query I dont see anything wrong with it
UPDATE CART SET TOTAL_COUNT = TOTAL_COUNT + 1, SET TOTAL_COUNT1 = TOTAL_COUNT1 + 1, SET DATE1 = 10/30/2006 6:17:02 PM, SET PERSON = luke WHERE CART_ID = 1
SET TOTAL_COUNT =TOTAL_COUNT + 1,
TOTAL_COUNT1 =TOTAL_COUNT1 + 1,
DATE1 = '10/30/2006 6:17:02 PM',
PERSON = 'luke'
WHERE CART_ID = 1
Success is the ability to go from one failure to another with no loss of enthusiasm.
- Sir Winston Churchill
one thing that's wrong is there's no line breaks in it. Looks like Joydeep fixed that though.
what was wrong was that there was more than one SET keyword -- there can be only one
line breaks are immaterial