chars not accepted in SQL?

[Robert Orlini]

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?

Thanks as always.

Robert Orlini

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---