Ian Rutherford

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... ...this extra part will be of interest only to the small group of programmers who occasionally ... (more)

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 ... (more)

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 ar... (more)

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... ...and how much of a pain it is... (more)