Results for "Category: String Manipulation"

If you are looking for a simple solution to display data and be able to sort and query it, you are on the correct page. Complex relationships between recordsets can be viewed using this technique. It is easier to use compared to ASPDB solution. Download Complete source code and explanation. Visit my website at www.ultratraders.com for more detials and articles.

This article not only includes the complete source code for a database driven web site that the author created, but includes a detailed description on how it works!

This article shows various connection strings, used to connect to various databases in Windows, as well as methods to access and modify data. Some connection strings may require client software to be installed, but most work with Windows 2000.

I modified some database paging code I found on Planet Source Code so that it was a little more straight forward. Included is a sample code file and a sample MS Access 2000 database. Paging allows you to display a specific number of records from a database at a time. For example, if you have 1000 records, you can allow it to display 10 records at a time so you don't have a huge page display. If you're smart, you can add sorting features like the ability to display records starting with 'A' only, but this will get you started.

This page allows you to view and sort all of your tables in an SQL database

This script displays records retrieved from the database. You can sort each field and jump to any page in the database. You can customize the records per page and all the colors. You may also attatch a style sheet to change the colors of each class type. this script is very close to being XML compatable. (still in the works).

This code lets visitors to your site perform complex queries. Users may choose if specific words (or phrases) must or must not match - or if they are optional (default).

After getting great reviews on the previous version, I finally got time to do the rewrite that I promised everyone. This code allows you to easily create lists of your data with pagination, sorting, and filtering. The end result is a very nice layout of your data. You choose which fields come back (an the captions for each one in the header). Choose which fields are searched. Setup the default field that is sorted when visitor first views page. Now supports databases with list ordering. This time I have included a database so it should work as soon as you add the files to your website.

Add search to your site using a database.

This piece of code demonstrate the way of accessing database (basic reading and writing). Good for beginners who wish to learn ASP. Nearly every line is documented

This code is in Beta stage and used like a QueryAnalyzer, it got a update feature but it wont work for the moment. The code will only work with MS SQL server and is only tested with IE 5.5. You have to set write permissions on the servers catalog. Please email me the bugs and other request asap.

This code shows the use of a dynamic array for the storage of data. Recordsets are memory hogs, and shouldn't be passed across the server, so why even use one? What I was doing with this code was displaying a list of users on my website. After getting the data, I would have it build a table for the information and create hyperlinks for the appropriate fields. I've seen others do this, but they use recordsets to build them, which defeats its purpose. All the code is done with one trip to the server, so you won't see all those carrot tags being opened and closed throughout my work : )

This will allow you to edit a collection of Access database's table data online. The bulk of the working code was originally submitted by Cakkie, and I added some new features, like secure login, the ability to select any database/table in a predefined directory, query tool, paging, result set count, and a new CSS style schema. I tested it a bit, but please report any bugs that may occour. View the ReadMe.txt file for setup instructions. UPDATED 9/12/2002

This is a simple shopping cart made using recursive scripts. The entire system is stored in 1 asp file and 1 mdb for the data storage.

Shows how to dynamically create a HTML table from a recordset. All you need is the connection string and the table name.

ASP EDGE is a great online solution to setup websites with highly configurable Administrative options. ASP EDGE is an integrated engine of user management, News Publishing,Content Management, Message Boards, Internal Messaging, user rankings, Link Manager (category configurable),poll, rotating ad manager, logged users, active users etc. Now you too can build an Online Community, Intranet or Extranet! See how it works an the latest update on it www10.brinkster.com/aspedge

a basic banner rotator. please vote for me! www.vbcouk.co.uk

This article shows how to use Javascript to populate a combo box with data from a XLM data island in IE5. The XLM data island is dynamil changed by a ASP Page , without the need of redrawing the screen. This code is very flexible and powerful and could be adapted to show datas in tables.

Do you have slow running mulitple SELECT Statements or long reports to fill on a web page. Use the Microsoft Shape Command. Learn to use ADO 2.1 and greater advance features. This code is great for three things, (1) Very fast way to do multiple SQL select statements and reports. (2) Great for databases not Normalized. (3) Avoids multiple nested single threaded ADO Record Sets loops which are very slow.

Consists of two files sql.htm and tsql.asp. Nice little interface with any SQL Server database. Returns result sets, etc. If you find the code useful please rate the code.