Results for "Category: String Manipulation"

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

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.

reads SQL Stored procedure meta data to provide a complete reporting solution including user input forms for criteria and sortable, pageable html reports.

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.

Judge not lest ye be... Anyway, no how could I have written this. It's the complete code for an earlier submission from MUKUNTHAN (REally, Dino Espositio at ASPtoday I am told) that allows for display of images from an access database. Feel free to email me for more if it doesn't come through. Thanks to Fabrizio Ricciarelli, Eric Gionet, Jos Hardy, Tim Krause and special thanks to my Moms...

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 : )

Allows midi songs to be played on your web-site. Songs are stored in an Access 2k database. Code will play a random song or allows user to choose a midi song from a drop-down list. Code calls same page to play midi with ms media player. Could use mp3's but mp3's drag down server. I use this as a sidebar on my default web page. Let me know if you find any issues.

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

ASP Online Exam, this is a quizzing website pulling question from question bank database [Access]. it also has a very useful set of administrator tools where in the admin can create new new Exams, monitor students performance generate reports and update question bank database. code is quite neat and fully commented, will be helpful for ASP Database beginners.

This Article explain and gives an example how to create a tool-tips in ASP page includes the data from one or more fields in the database in a grid.

Shows the database's schema and the table's data

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.

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

Purpose: The purpose of this widget is: 1. provide a single function to handle creating tables 2. provide a table that can sort both ascending and descending on any column 3. provide a table that can then link to an edit view 4. provide a table with alternating row colors for easier readability 5. Allow each of the above to be accomplished in 2 lines or less

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