...

View Full Version : SQL Help Needed Please (ColdFusion MX)



Confused!
04-23-2005, 02:32 PM
I have a simple form that should insert data to an access database. However, for some reason it tells me there is a syntax error with the code below. I have checked this a million times and can't find anything wrong with it!


<cfquery name="AddRecord" datasource="030210ics3mp">
INSERT INTO story (title, intro, body, author, email, date)
VALUES ('#form.title#', '#form.intro#', '#form.body#', '#form.author#', '#form.email#', '#form.date#')
</cfquery>


Please help! Thanks in advance.

Ps - ColdFusion isn't liking the values section. It says there is a syntax error.

Confused!
05-04-2005, 06:11 AM
I have a simple form that should insert data to an access database. However, for some reason it tells me there is a syntax error with the code below. I have checked this a million times and can't find anything wrong with it!


<cfquery name="AddRecord" datasource="030210ics3mp">
INSERT INTO story (title, intro, body, author, email, date)
VALUES ('#form.title#', '#form.intro#', '#form.body#', '#form.author#', '#form.email#', '#form.date#')
</cfquery>


Please help! Thanks in advance.

Ps - ColdFusion isn't liking the values section. It says there is a syntax error.

Ok I have sorted this problem but just thought I should let everyone know that access database doesn't like you using 'date' as a variable. It is predefined. Hope this helps people in the future!



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum