Add Record Errors

[nadamson]

This is the error message I get when trying to add a
record to an Access database with CF.

From what I can see, it does not like the </cfif> on line 82, is this because of the NULL on 81 ????, if so where is it coming from ?




Error Executing Database Query.
Syntax error in INSERT INTO statement.

The error occurred in C:\CFusionMX7\

http://wwwroot\Makes\add.cfm:

line 82

80 : <cfelse>
81 : NULL
82 : </cfif>
83 : )
84 : </cfquery>

 

[nadamson]

DON'T WORRY, FIGURED OUT THAT "REAL" IS A RESERVED WORD

 

[coldfused]

Took me wa while but finally I printed out the reserved words list and keep them by my development box

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...