December 15, 2001

Limit Data Connection through Fast Retrieval of Recordsets

One of the most overlooked and underused methods of the ADO object is GetRows(). This will quickly retrieve your recordset as a bi-dimensional array in the form of Array(columns,rows). While you still have to use nested loops to build your HTML table (which is conceptually the same as working with

Use Value in XSL

Define value: Combine with the xml file: Use it: The value define statement can be created in an xsl file, and this file can be included in other xsl files which use these variables.

Replace Function in Javascript

JavaScript lacks a Replace() function. This functionality can only be achieved in Javascript using RegularExpression, though not all browsers support it. The code below is for replace and can work on all browers. function Replace(StrSource,StrFind,StrReplace,_IsCaseSensitive) { var StrReplacedContent=””; var FindPos; var StrOriginal=new String(StrSource)_.toString(); var StrOriginalSource=new String(StrSource); var FindPos=StrOriginalSource.toString()_.indexOf(StrFind); while(FindPos>-1) {

How to Write Backward Compatible JavaScript Links

Although most people have JavaScript enabled on their browsers, there are still a lot of people who don’t. This is why you should always make your pages as backward compatible as possible. One easy way to improve access is with pop-up window links (where you click somewhere and a page

Department Wise Employee Ranking With Single T-SQL Query

This code will retrieve the employee details with a salary-wise ranking from each dept.EMP table with different departments and different salaries. If two employees in the same department have the same salary, then they’ll have the same rank. EMP Table———-DEPT NAME SALARY$———– ————————- —————-10 JAMES 2000.0000010 ADAMS 1500.0000010 GEORGE 2000.0000010

Check for OS File Existence from T-SQL

Sometimes you may want to check whether a particular file is available while working with the file system in T-SQL. You can check this by using “xp_fileexist “, Sql Server Undocumented system stored procedure. –//////////////////////////////////declare @myfile intexec master..xp_fileexist ‘c:screen.jpg’ , @myfile outselect @myfile as FileStatus–////////////////////////////////// If “FileStatus” is “1”, the

Pooled Objects and Initialization Control in VS.NET

he Web application with which I am currently involved, relies heavily on external data abstractions to control both functionality, as well as the UI appearance. These external data repositories are all stored in XML format. Application Configuration Navigation Configuration (Modes, Modules and Menus) XSL Stylesheets String Resources Page Templates The

Setting authentication across different domains

COM doesn’t have a built in security mechanism, but relies on Windows authentication services (Security Service Providers). When you access a resource or invoke a method in a remote DCOM server (or MTS package / COM+ Application), security checks cannot be performed in the standard way if the client is

GetObjectContext.CreateInstance is obsolete in COM+

CreateInstance was necessary in COM to provide a COM object activation mechanism that could be hooked by the MTS runtime before the activation request reached the COM runtime. So that MTS could apply some pre and post activation magic to put a wrapper around the real object and return this

No more posts to show