It struck me like lightning what Ryan was trying to say 15 seconds before
Ryan emailed me, but I did not know the use of cftry and cfcatch so you both
helped. It works now. That has been bothering me for 3 days. You guys are an
awsome resource! Thanks for the input.
A.
- Original Message
Don't forget, you can also do a select on the key/primary table and then do
a RecordCount on the query. If you have 0 rows returned then the value
doesn't exist and you don't want to insert. If it does exist you can then
use the value
Glad to be of assistance,
Ryan