Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Leon Platt profile

   Items 1 to 9 of 9   

Making Dynamic Queries Static

Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!   Read more...
By Leon Platt 2002/05/02 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,876 reads

ASP - Reaping the benefits of SQL 2000's FOR XML clause.

In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.   Read more...
By Leon Platt 2001/11/14 | Source: | Category: ado
Rating: |  Discuss |   Briefcase | 8,094 reads

ASP and ADO Gotcha - Duplicate Field Names in a Query

Recently while working on the site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.   Read more...
By Leon Platt 2001/08/10 | Source: | Category: asp
Rating: (not yet rated) |  Discuss |   Briefcase | 3,370 reads

Pseudo web service using xmlHTTP

This article delves into the mysterious xmlHTTP object and the supporting ASP code. I've got to tell you that I really love using this object. Basically what I like about it is that through xmlHTTP you can expose some or all methods of any ActiveX class to the client-side user. What this means is you are giving the user the capability of calling your back-end Active X controls. And the best part of it all is that the entire communication process takes place behind the scenes!   Read more...
By Leon Platt 2001/08/14 | Source:
Rating: |  Discuss |   Briefcase | 7,387 reads

IIS Connection Pooling ? ADO Gotcha!

This article by Leon Platt speaks to how you can avoid pulling your hair out when configuring connection pooling for IIS.   Read more...
By Leon Platt 2001/05/08 | Source: | Category: asp
Rating: |  Discuss |   Briefcase | 7,471 reads

Invisible Comments

I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.   Read more...
By Leon Platt 2001/04/26 | Source: | Category: asp
Rating: |  Discuss |   Briefcase | 3,473 reads

Using InterDev's Toolbox

If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant  Read more...
By Leon Platt 2001/04/24 | Source: | Category: .net
Rating: |  Discuss |   Briefcase | 3,044 reads

CLIENT SIDE XML - ASP on steroids !

This article demonstrates the ability to use the XML DOM on the client-side browser.   Read more...
By Leon Platt 2002/04/11 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 16,657 reads


This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 184,218 reads
   Items 1 to 9 of 9