OK now I'm having issues when an item is edited. I got the new items to work in upper case. Now I can't get it to covert the edited field to alway be in upper case. Here's the coding: <cfupdate Datasource="#da tasource#" tablename="Item s" formfields="Ite mID,Artist>. I tried both Ucase(Artist) and UPPER(Artist). Ucase has no errors, but doesn't do anything and UPPER errors out. How would I go about adding always upper case to the Artist field?
Thanks
Thanks