> 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
> 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

---John Holmes...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to