Results for "Category: String Manipulation"
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.
Easy Forums is a fully functional message board system, developed using MS Active server pages: Features: - Authenticated login to registered users and facility of registration of new users - Sorting the Message board threads on the basis of Date, Email, Name, Subject etc. by a single click - Allows users to post new messages and reply to old messages. Feel free to modify, distribute, use this code as you may please, and if you like it please VOTE FOR ME in the contest.
I wrote this for my company's intranet to display a search for our standard operating procedures. It will search a table in my database that contains SOP titles and is multi-word capable. It will also display the results as hyperlinks to htm files containing the SOP's.
the sample will show how to display message fromt he database when a user logs in and how his session will get expired and after session expiration he was not able to read hiw messages until he logs in again
This code delete duplicate records in MSAcces database.