I guess I did not think about multiple dsn. I don't think I've ever used more than one dsn for this type of situation.
What do you think about wrapping a cftransaction block around the flushDiscountToDatabase() methods so one cftransaction would handle a flush method for a parent record, and looping over child record flush methods as in my original post to this thread? Thanks, Stan Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer/Janitor http://www.aftershockweb.com/ >I think I might have been a bit unclear about my point. It's not so much >that you have to pass datasource arguments, but simply that for >CFTRANSACTION to work, all queries within the transaction need to be using >the same database connection. For queries within a page to use the same >database connection, they must use the same datasource, username and >password. In the original code sample, you couldn't tell whether that was >the case, since the actual database queries weren't in the same file as the >CFTRANSACTION tag itself. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232804 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
