Results for "Category: String Manipulation"

This is a task manager online. What this does is allow a group of people working on a rather large, or even simple project to put down tasks or ideas that are related to their project. I use this for my school assignments and the current web site that a group of my friends are currently working on. This Task manager has a whole lot of features that have not yet been implemented but you have the ability to add tasks, asign yourself to tasks and also edit tasks (if you are working on them). On the main screen you will see a list of all the tasks sorted by importance. If you wish to sort the list by a different order, just click one of the headings ('In Charge' 'Date') etc. You will also notice that according to the level of importance, the colour differs (red for level 1, yellow for level 2, green for level 3). This code teaches how to use SQL statements to access, update and insert data into a database. It teaches how to use the server() function in asp, and also teaches how to use cookies for login purposes. This code is fully commented, and if you would like any more information or wish to contact me, please email me at [email protected]

You can use ADO GetRows to output and ADO recordset to an array. This is often useful in n-tier applications when you are moving data between tiers--or if you want to persist your data in another way. http://adozone.cnw.com/default.htm

ADO has a great batch update feature that not many people take advantage of. You can use it to update many records at once without making multiple round trips to the database. Here is how to use it.

Transactions are atomic operations that allow you to do multiple operations on a database as one operation. For example, if you were creating a banking application in which you deducted $100 from one account and added it to another account, you wouldn't want the operation to fail right in the middle, because the money would be 'lost'! The solution is to wrap the SQL in a transaction. If the operation is aborted in the middle (the pc gets shut off for example) the database will rollback the changes so that the initial account was never debited the $100. This will make you feel good, especially if its your bank account!

Since ASP is especially good at reading and writing to databases, let's start with a very simple database and scripts that we'll eventually build into a guestbook... Reprinted with permission from http://www.web-savant.com/users/kathi/asp

This is not real RDS but a simulation (Like Access's Not_In_List event). This functions gives the user the ability to 1) Add a new Value into a Database table and 2) update and select the value in the combobox WITHOUT REFRESHING the page from the server. I found this to be a life saver with large ASP pages with comboboxes on them that need to be dinamicaly filled. (You don't have to worry about the controls on the pages)

To return a group of Random Records from a database. For example, a group of random questions for a quiz/test.

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.

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

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