For <CFINSERT> and <CFUPDATE> to work, ColdFusion must obtain a list of columns in the relevant table. If you are using Apache Derby you may run into a problem whereby <CFINSERT> and <CFUPDATE> throw a "There are no columns found" error. The solution is to ensure that the Derby table name passed to <CFINSERT> and <CFUPDATE> is in upper case.
Happy Birthday to you,
Happy Birthday to you,
Happy Birthday ColdFusion,
Happy Birthday to you!
12 years old today!