Hi all.

 

This question is more to do with where the best place is to handle errors when doing multiple inserts.

 

I’ve got a page that will call a CFC to do multiple inserts. should I …

 

(a) package up the data in the calling page (as an array of structs) and call a batch insert method on the CFC (really just unpacks it and calls multiple inserts)

 

- OR -

 

(b) loop many times in the calling page, each calling a single insert method.

 

if I hit a problem I need to flag that insert (to display a warning) and keep going on the others.

 

I think (b) is probably easier to catch the bad insert for the message but I’ve been using (a) because the processing seems “gentler” (and I’ve adapted it from a batch insert where if one fails they all do. this case is different, they must keep going)

 

any suggestions?

 

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

Reply via email to