>
> I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as "John's" in the input field:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax near 's'.
> SQL = "INSERT INTO itemsordered
>
> Is there a code/way to make SQL accept these characters. The ITEM column is setup as a CHAR field. Should it be VARCHAR?
It looks more like you have an apostrophie in the code
You're probably not using CFQUERYPARAM for your insert, are you?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
