Comment Field on ORDER engine cause error with Apostrophes

[evan evans]

Here's the error text:

[code:1:2d40e75574]Microsoft OLE DB Provider for SQL Server- Fehler '80040e14'

Zeile 1: Falsche Syntax in der Nähe von 't'.

/vsl.co.at/commit.asp, line 33[/code:1:2d40e75574]


I was able to rememedy the error by removing apostrophes from my words in teh comment field. You just need to do the REPLACE("'","''") function, replcaing single apostrophes with double aopostrophes.

Evan Evans

[cm]

thanks for reporting evan, i'll put it in a stored procedure to keep the option for entering single and double quotes
christian