All, desc resource shows asset_tag in all upper case, but: mysql> UPDATE RESOURCE SET ASSET_TAG = '' WHERE ASSET_TAG IS NULL; ERROR 1054: Unknown column 'ASSET_TAG' in 'field list' mysql> update resource set asset_tag = '' where asset_tag is NULL; Query OK, 0 rows affected (0.01 sec) The asset_column is also not showing up in the mysql web editor? Even when I do select * from tablename... If someone would be so kind, what am I doing wrong or missing? thanks, -Bill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
