Better way to deal with getting the inserted key from an insert statement and some code beautification
Deal with a bug in Apache Derby dsn that does not allow NULL values in CFQUERYPARAM
Test the null filter in the where clause
makes more sense to not auto generate primary keys and have that be something one must ask for explicitly
slightly better description
a demo of the code