insert help???

[danarashad]

I am having trouble inserting into an access database.
<cfquery name="insert" datasource="#datasource#">
INSERT INTO noteLog (userID, note)
VALUES (#form.userID#,'#form.note#')
</cfquery>

the note field is a memo datatype. how do you insert into a memo datatype field. i've taking out the '' marks, nothing seems to work. help please!!!!

 

[cfStarlight]

You should use cfqueryparam, but that's not the source of your problem.

I think Note may be a reserved word. Try renaming that column.

http://support.microsoft.com/kb/248738

If you cannot rename it, try using brackets around the column name

..
INSERT INTO noteLog (userID, [note])
..

 

[danarashad]

thanks i just figured it out. thanks again