I have been working with CF for two years and am currently the designer of CatholicStore.com and Catholicliturgy.com. I have been working with SQL for two years and started working with stored procedures about two months ago as we began an update of CatholicStore.com. Both sites are built using the Fusebox methodology.
My three-part article on stored procedures (CFDJ, Vol. 3, issues 10, 12, Vol. 4, issue 2) has mushroomed into four, but since I'm sure most of you write perfect code the first time…
May. 2, 2002 12:00 AM EDT Reads: 17,678
Latest Articles from Ian Rutherford
Now that we've gone over stored-procedure integration with ColdFusion and looked at some programming basics in Parts 1 and 2 of this article (CFDJ, Vol. 3, issues 10 and 12), let's look at some other useful and more complicated functions using MS-SQL2000. First, however, I need to corr... Feb. 5, 2002 12:00 AM EST Reads: 25,036 |
Why should ColdFusion analyze the query results when the database could do it and you could save the bandwidth for something that really needs it? In Part 1 of this article (CFDJ>, Vol. 3, issue 10) I introduced stored procedures and performed some basic tasks with them. In this articl... Dec. 3, 2001 12:00 AM EST Reads: 13,026 |
Stored procedures. Ah, yes. The dark side of database access. You've heard the rumors - faster processing, less network traffic - and have been tempted. But you've also heard those on the easy path whisper about how complex these procedures are... Oct. 4, 2001 12:00 AM EDT Reads: 13,874 Replies: 1 |
