Adding a Form Field Into a Database

extensions seem to be generating errors

[justa]

I have built a form which the use can update the current RiskMangement Database. The fields required in the table Which are included by the user are...

Title, au_id, Info_TypeID, Bus_UnitID

There are another 3 fields which make up the table.....

DocID (int identity)
Date_mod (Date)
Document (varchar)

The DocID automatically increments with each addition, so theres is no problems there. The Date modified is a hidden input which is filled with
Date_mod=#DateFormat(Now())#
and that works fine also.
I then need to enter the name of the document into the database. If the name already exists the name is changed and can be viewed using #CFFILE.ServerFile#.

I'm trying to pass that information into the Document field but I keep getting the following

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'txt' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

Any suggestions welcome. Let me know if I need to explain myself better, I seem to skim over the important bits.

[Brett_Tabke]

Sounds like a botched character is being passed. I'd double check the test data, and the syntax of the select statement.