> I have definitely isolated the problem. If I change the column name > that the match is being performed on from 'id-sys' to 'id_sys' I can execute > the query without having to worry about quoting the column name and > everything works. I think that I am just going to leave the column name > changed and take this as a lesson never to use '-' in a column name again. > Thanks again for the help. Maybe we all learned something from > this.
If you want to use a column name like id-sys, which you shouldn't, though, as you've learned, you can enclose it in backticks, like `id-sys`. Note that those are not single quotes, they are backticks, to the left of the number 1 key. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
