Evagoras Charalambous
  • About me

GetRows VBScript Class – Part III: Paging the results

February 10, 2011|Classic ASP

In Part I of this series, we saw how to create a VBScript class to query our database using the very fast GetRows() method, and return a recordset as a local array. In Part II, we extended the class to allow ADDing and UPDATEing a row in the database. In this Part III, we will expand the class further to allow pagination of the returned recordset.

Read more »

Dynamic Tree Menu of your site

February 8, 2011|Classic ASP

We’ll see how to create a menu system that is cross-browser and includes all your site’s folders/files. It uses ASP, XML and DHTML and by simply copying it to your site you have an instant Windows Explorer-like navigation of the contents.

Read more »

Generating an XML file of your website’s folders/files

February 8, 2011|Classic ASP2

Using the File System Object (FSO) we can traverse through our website’s contents and write them out in a nicely nested form in an XML file. We can then use that file for example, in a content management system or a TreeView control.

Read more »

Downloading any file using ASP, FSO and the ADODB Stream object

February 8, 2011|Classic ASP56

In this article, we will see how to allow a user to download any file from our web server. They will see a prompt, giving them the option of opening or saving it, rather than simply opening it which is the default. We can achieve this using the FSO and ADODB objects.

Read more »

Calling MS Access Parameterized Queries from ASP

February 8, 2011|Classic ASP5

Instead of passing a SQL query through your ASP code against Microsoft Access as you would normally do, you can use the Queries design interface to create them in Access and then call them from your ASP code. It makes things easier to edit and maintain, and the results are returned faster.

Read more »

A Generic GetRows VBScript Class – Part II: Adding Update and AddNew functions

February 7, 2011|Classic ASP

Expanding on a previous article, we will see how to add 2 new methods to our class: one that inserts a new record in our table and another that edits an existing one. Use them against any table with just a few lines of code.

Read more »

Formatting complex ASP output using HTML templates

February 7, 2011|Classic ASP10

Mixing HTML and ASP code can be very difficult to maintain. Concatenating long strings in the code makes things difficult to read, and switching back and forth between ASP code and HTML can be very inefficient. Worst of all, you cannot use your HTML editor to edit the content presentation just as you usually do; you have to edit everything by hand. In this article we’ll see how to solve this issue using HTML templates.

Read more »

Web-based Content Editor using IFrame

February 2, 2011|Classic ASP3

If you have ever used Hotmail’s Rich Text Editor and wondered how they do it, then this article will shed some light on that. An IFrame works like a frame but lives within your page, thus creating inline frames. Without the need of applets or ActiveX, it’s possible to use that and create an online content editor that resembles and works like your favorite word editor.

Read more »

The Windows 2000 Indexing Service

February 1, 2011|Classic ASP

Also known as Index Server, it catalogs your website, allowing your visitors to search against your content. This article goes through installing the Indexing Service on Windows 2000, pointing it to your web site, tuning it for speed and efficiency, showing you how to use it with some sample code against the ADO, and what to do if it fails.

Read more »

A Generic GetRows VBScript Class

January 26, 2011|Classic ASP

The GetRows method of the ADO object is known to be the fastest way to fetch a recordset. By encapsulating the logic within a VBScript class, it’s possible to query your database and return your records to a local array in only 3 lines of code.

Read more »

Categories

  • ASP.NET (11)
  • Classic ASP (10)
  • ColdFusion (17)
  • JavaScript (2)
  • Life (1)
  • Other Coding (4)
  • Wordpress (3)

Popular Posts

  • Downloading any file using ASP, FSO and the ADODB Stream object

    In this article, we will see how to allow a user to download any file from our web server. They will see a prompt, givin...

  • Downloading any file to the browser – Part II: using ASP.NET

    Following an article on how to do this using ASP 3.0, we'll see how to accomplish the same effect using ASP.NET. Using s...

  • Exporting Word files to HTML

    In this article we will first discuss the case for and against using Word as your HTML editor. Then we will see how to p...

  • How to handle and customize an empty search query in WordPress

    There is a way to bypass the default Wordpress functionality which displays the home page's children when a user submits...

  • How postback works in ASP.NET

    In this article, we will take a closer look at how ASP.NET pages post back to themselves, and how to customize this feat...

Tag Cloud

addnew attributes cdonts cell checkbox class classic ASP coldbox ColdFusion color commandbox custom custom tag diagonal directory download email files folder folders forgebox format getrows headers indexing service Java javascript jQuery metrics output qb query row site sql stream structure System.IO.DirectoryInfo table templates update view windows wordpress xml
Design inspired by the most prolific blogger I know.