Results for "Category: String Manipulation"

This code will allow you to track users without having to go into the IIS logs and looking trough the hundreds of entries just to find out what pages the users viewed, and/or to track them at the point where they left or contacted me about my products (web design). This code has two parts, the database insertion and the database viewing. Database insertion A server side include is inserted into every page that I want tracked. The code runs immediately upon the user visiting the page that has the include, once the page is requested an entry is automatically made into an MS Access database writing all the variables that will allow you to determine what the user did or the pages they viewed. Database viewing. You can later view the variables stored in the database using the default.asp which is included in the /users/ folder. It will allow you to view the visits in descending order; from there you can choose to look at the each user’s information. By clicking on the IP address you will be able to see where the visitor came from, such as country, region, etc. By clicking on the VarID you will be able to look further into other variables not displayed on the first page. I am currently working on this project, the final copy should have reports by # of visits by IP, most pages request etc. Please let me know if you find this code helpful, or of any problems you encounters. --UPDATE-- Due to the increase use of the "User tracking" software, and the problems encountered during installation, I have decided to dedicate a forum especially for it. Feel free to comment. Please give credit if you find the software useful. http://pagedream.com/redirect.asp?site=http://core.pagedream.com:8080

This code snippet will compact your Access DB online. You can do this via a web browser!

THIS CODE WILL CONVERT A RECORDSET INTO A CLIENT SIDE ARRAY AND THIS ARRAY CAN BE SORTED AS PER ANY FIELD IN THE TABLE.SINCE THE PROCESSING IS DONE ON THE CLIENT SIDE ITSELF PERFORMANCE IS MUCH BETTER.CLICKING ON THE HYPERLINKED TABLE COLUMN HEADERS WILL CSORT THE RECORDS AS PER THAT COLUMN.

This code is do recordset paging with images instead of buttons.The images will be swapped based on the position of the current page.I have also provided a facility to "GO" to any page by entering the page number in the "GO" TEXTBOX.

This Code shows, how easy it is to store some dates in a mysql database

Sample application/*.sln for beginners and intermediates using OLEDb. Other controls used are ListView, ListBox, and MenuItems. Also uses ArrayList as a collection holder for the entries in the DB. Comes with *.mdb file. Pretty good beginning point for OOD. Complete with Update/Delete/Add/Refresh SQL Commands.

DataEasy: is an application written in C# which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your voting will be appreciated :).

This code is made up of 2 new VBScript classes, the other VBScript class - clsSortableTable.asp was submitted by another user and works great. The first new class - clsDynaEditForm.asp creates an HTML form based on any table/view in the database and can even validate selected fields. The other class - clsUpdateDB.asp is then used to update the database.

Often I use flat mdb files to post forms to on the webserver. This is a simple page to just grab a table from an mdb file on the server with a DSN-less connection and display it as an HTML table, so I can copy the table and paste it into Excel or Access, or just to get a quick look at the contents.

Simple Access database viewer! Just enter your database location, and it shows your tables and stuff. SQL Querys!

Download a binary large object (BLOB) from the database without temporary files or chunks.

Convert a SQL query into ASP code.

This code compares the table structures of 2 MDBs and returns in Red that values that are in one DB but not in the other.

This code is to display, in a simple and fast loading treeview, a database. You can have up to 10 level and the treview is loaded just once (not at each level). Each level can have a checkbox (in a form), link and many other that can be set it up in only one founction.

I wanted to add paging code in my project.I've seen all other codes on the site but they are not at all worth for me. Now I've written a code which is very easy to understand and can be used by any student or professional in their projects.

User can Login/Register and then update his/her profile. So Powerfull By Designing & Coding Wise At every step user is briefed that what;s going on and why. Easy to Learn for begginers. I asure after to read this code He/She will not be dependable of any one according to ASP Database

Saves time by NOT having to download your access database to Compact and Repair then re-upload again.

this is a wrapper for some of the more commonly used database functions. can help reduce your code dramitically.

This example demonstrates how to create subform in Internet Explorer like in MS Access. It works in same principles as a database.

This code is an ASP VBScript Class that allows you to find any acccess database on your server, and connect to any record in any table and edit,add or delete. It has a full grid function for paging through recordsets.