Hi Matt: >> All of them work and they're all pretty much the same when it comes to >> the programming language layer. > > Except for when the programmers you're working with don't want to/aren't > strong at writing SQL. Which is the case here, and I need more to do, > hence wanting to put some of the DB logic in the database.
Just to be clear, what I'm saying is the act of inserting the data is pretty much the same regardless of the route. But, as you're initially asking, several steps need to be performed after the record is inserted, then stored procedures are handy. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation