Page 1 of 1

Insert Problem

Posted: Thu Jun 08, 2006 7:23 pm
by BigAbe
Aloha sweet board!

It's been a really long day, and I'm just looking for a little board debugging love right now...

Code: Select all

INSERT INTO users (userUID, userSCTID, userFirstName, userDateCreated, userCreatedIP, userLastLogin) VALUES ('jnovotny', '11223344',Jared', NOW(), '198.199.136.65', NOW())
gives me
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '', NOW(), '198.199.136.65', NOW())' at line 1
My brain is hurting right now, and I can't debug anything in this state. So I'm gonna go for a walk, but in the meantime, if anyone can offer help, I'd be greatful!

Mahalo!

-- Abe --

Posted: Thu Jun 08, 2006 9:18 pm
by paladaxar
You're missing a single quote before the word Jared.

Posted: Thu Jun 08, 2006 9:40 pm
by BigAbe
paladaxar wrote:You're missing a single quote before the word Jared.
Thanks a million. I feel so bad for being so lazy, but you've made my day! (Ok, not my day, but hour - how's that sound?)

Mahalo nui!

-- Abe --