|
Hi Barry, Firstly which RDBMS are you using? If it Sql Server the most efficient way
to perform multiple insert, although complicated, would be to pass a XML
structure to a stored procedure then extract that stored procedure into a
cursor loop through and perform the multiple inserts, if you wanted to handle
error conditions on each insert you would use the try catch is SQL and return a
list of errors that where encountered. I
can post some sample cold fusion and SQL SP code if you like?
However this may not be suited to what you are doing, this is for large batch
inserts. 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 This message may contain privileged or confidential information and is intended only for the individual named. If you are not the named addressee you should not disclose, disseminate, distribute or copy this e-mail. If you have received this e-mail by mistake please notify the sender immediately by e-mail and delete this e-mail from your system. You should rely on your own virus checking programmes and procedures for checking any attachments. Please advise us if you wish your name and e-mail address to be removed from our database. |
