one way (I believe to be the best way) is to use a stored procedure and set an
output variable to the new SQL ID. a second way is to use a timestamp when you
create the record and then retrieve the record based on that timestamp and
values you just entered. a third way would be to store a coldfusion unique
identifier and then retrieve the SQL ID from that.