thanx for your interest Theo. sadly, I can't use SP's, triggers, views or XML dumps with this DB (informix - oh how I wish it was SQLserver!)
but it's not really a db question, more where to do error handling. In this case, if an insert goes wrong, swallow the error (flag it for display) and carry on processing the other inserts. so where would people do this? in the calling page (loop and call insert method), collecting errors as you do them one by one - or - in the CFC (unpack, loop and insert), throwing back a list of dud inserts, if they occur? thanx barry.b --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
