> Why not? I've been taught by our database folks that the more stuff we can why not? sp's aren't really meant for dynamc sql. if i had two logic branches in an sp, these would become 2 separate sp. unless security/management were the main issues. > move into the database, the better - that cf is best used for > outputting/formatting but that the processor-intensive stuff (loops, etc) > should be moved to the db when possible. What's the rational for saying that > you shouldn't? i didn't say "not in the database", i said "not in an sp". and the loops here were loops building dynamic sql code. cf builds the sql, the backend executes it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- Stored Procedures - Am I going insane? Philip Arnold - ASP
- Re: Stored Procedures - looping over selects Deanna L. Schneider
- Re: Stored Procedures - Trying Again Deanna L. Schneider
- Re: Stored Procedures - Am I going insane? Paul Hastings
- RE: Stored Procedures - Am I going insane? Jeremy Allen
- RE: Stored Procedures - Am I going insane? Dave Watts
- Re: Stored Procedures - Am I going insane? Paul Hastings
- Re: Stored Procedures - Am I going insane... Deanna L. Schneider
- Re: Stored Procedures - Am I going in... G
- RE: Stored Procedures - Am I going in... Paul Hastings
- RE: Stored Procedures - Am I goi... Keith Thornburn
- Re: Stored Procedures - to use o... Deanna L. Schneider
- Re: Stored Procedures - to u... Paul Hastings
- RE: Stored Procedures - Am I going insane? Rich Wild
- Re: Stored Procedures - Am I going insane? Paul Hastings
- NT4 SP 6a Keith Thornburn
- RE: Stored Procedures - Am I going insane... Philip Arnold - ASP
- RE: Stored Procedures - Am I going in... Philip Arnold - ASP
- RE: Stored Procedures - Am I going insane? Todd Stanley