INSERT INTO Syntax error

ok I have been beating my head this morning wondering what I did wrong with this statement. Anyone out there ahve any clues?

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\Pubwebs\npl\admin\programs_Add.cfm: line 4
2 : <cfquery name="AddRecord" datasource="npls" dbtype="ODBC">3 : INSERT INTO programs (title,branch,description,dateposted,time) 4 : VALUES('#Form.title#','#Form.branch#','#Form.descr iption#',#Form.dateposted#,#Form.time#)5 : </cfquery>6 : <cfset Message=true>

I have an almost Identical Page that adds almost the same fields with the excption of time. That is the biggest difference between the pages that and the database.

I've done this before, myself, and I've been coding CF for a while, now. You left off single quotes on #Form.dateposted# and #Form.time#.

Hi,
In cfmx 6.1 I ran across problems with simple inserts/updates... I found a "hotfix" at Macromedia that addresses a bug in the "<cfinsert>" and "<cfupdate>" tags of cfmx 6.1, see Issue 52972 and/orIssue 53653:
[http://www.macromedia.com/support/c...sert_hotfix.htm]

They have a file there to download and put into cfserver to fix it.

Thanks,
Jim S.