'Syntax error in INSERT INTO statement' - simple statement - cant find error

Hi all,

I had the above error message when I have tried to enter information from a form into a database. The code I've got is like this:

<cfinsert datasource="site" formfields="name,email,comments,postid,date" tablename="comments_section">

I know that the datasource can be found becuase I can read the data from that particular table. I'm a bit lost - can anyone help?

Thanks in advance,
Andy

 

Hi Andy,

I don't immediately see an error in your code, but as a rule of thumb I don't use <cfinsert>. I prefer using the SQL syntax for my inserts. You can have better control over the data going into the table.

Hope this helps,
Jason

 

agree with above, leave sql to sql and cf to cf!!!

 

yup - definitely agree - I've had issues with cfinsert in the past - just don't use 'em anymore -