Hi all, I am having a problem with one of my forms. I was testing to see if it would except data with apostrophes, and it doesn't. I thought maybe I had forgotten to addslashes to the variables...but I had the addslashes in my code...
I was reading the manual page about addslashes to see if maybe I was doing something wrong and I noticed this line in one of the user comments: "Addslashes operates in 2 modes, either escape ' with Sybase method '' or the MySQL/rest \' method. I quickly ran into problems when I have both MySQL, and Openlink ODBC-> MS SQL 7.0 in use. An optional parameter to force Sybase style quoting would be nice." Now I am using MSSQL via freetds and since the commands for MSSQL and Sybase are basically identical as far as php is concerned, I am assuming that I have to use the "sybase method" to escape quotes. However, I can't seem to figure out how to do this, can somebody point me in the right direction? (and in case anyone is interested in my error message, here it is) Warning: Sybase error: Unclosed quotation mark before the character string ' ORDER BY lastname,firstname'. (severity 15) in /home/www/html/devel/idback/empsearch2.phtml on line 47 Thanks for any help, Zara
