Results for "Category: String Manipulation"

After playing with ASP .NET's Data Grid, I figured I'd create something similar for use with ASP. I've begun by creating the properties and methods to reproduce the most commonly used and useful features of .NET's data grid. Easy to run examples included. Updated 10/28! 2nd version which allows column headers to be rendered as sort by links. Updated 12/27! Now can customize error message and display. Updated 2/21! Class optimized.

This code allows you to input strings with apostrophes into a database.

Create an import profile and import a text file into a Database using ASP. Sometimes you need to be able to import text files into an online db. This script lays down some ground work and provides an interface similar to the Import wizzard in MSAccess. The main difference is that you can save the import specifications and then simply call the importer with its ID and the name of the file. If you are running this on NT or 2K you will need to set the relevant permissions on the db and Incomming directories. NOTE: This is the first working version of something that is VERY much work in progress. I have still got more work to do on it, including some docs and such... in the meantime it works fairly well but only saves the data into the same db as specified in opendb.asp I have only tested it with IE.

This is a simple as it can be an HTML based news letter sending application made in Asp. Add this functionality to your web site to send news letters to your site members. This app has a client side where members can subscribe to your news letter and an admin side where you can monitor every thing. The administrator has a complete control panel to operate it. To See Admin's pass plz open the db and you will find it there. The Admin has following functionalities: Add Admin, Add Member(Subscribe Member)/unsubscribe/edit info etc, Send News letter to all the members in the list. The news letter can be in boht text/html forms. You can create your html basd newsletter in any application then copy paste its html code in the news text box and send. Thats it! ===============> This requires CDOnts.dlll to send the news letter using cdo messaging. gets the list from MS Access database in the db folder and sends it. Very simple to use and integrate , I hope this helps people out, dont forget to rank it 5 globes.

Learn how to Install MySQL, import an Access database into MySQL database, and display data on a ASP page. Step by step tutorial with screenshots! Please leave questions or comments.. Updates: I have included a dsn-less connection!

This a simple way to page in MySQL, its hard to find how to do this in MySQL and ASP so I wrote it and am now sharing it with you! It is my second post regarding MySQL. If you would like to learn how to setup MySQL and import an exsisting Access database you may find it here: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=7739&lngWId=4 Please leave any comments if you find this code useful! Thanks for stopping by.. -Jason

After digging around and trying to find a decient multi word search function, I ended up building my own. This ASP page and database splits the words up and combines them with a SQL query string. It also allows you to resubmit a search for a "More Like This" link which resubmits the Keywords back into the page and searches for those words within the database Keyword attribute. Someone who found a bug reported it to me and I've since corrected it. If you find any more let me know! Thanks all for the votes

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

This is a small data entry form in Windows XP style for the browser (IE). Addressess basic data base functionality such as INSERT, DELETE and UPDATE, as well navigation thru the record set.

Returns the results of a SQL query as an HTML table. This small function is not only very fast it also simplifies the programming logic for displaying data.

LabDev sBuilder is designed to automate the boring task of building a Form & ASP page to receive and process the values submited; Once stablished a Connection, it generates all the necessary ASP ode for you, to manage a particular table; It generates code for the Form, Request.QueryString & Request.Form, Sql Insert, Update & Delete, and Connection Obj/String :-)

This is a small example of how to get input from visitor at your site, search a database, and send them the results.

This code shows how can power up databases applications with XML . It use common and simple way to send and receive data, in xml form over HTTP and convert it to html using XSLT

Simple user Registration form..., Database that used is Access 2002

Hi guys, I have decided to update the user tracking system. The updates are: -Prevent database login based on IP address. The reason for this feature is because I got tired of login my own IP and those of search engines. -View blocked IP’s -Delete blocked IP’s -All pages are password protected Note: This code only works on servers supporting ASP (active server pages) 1. Unzip files to the root (warning! If you already started logging hits then your entire database will be overwritten) 2. Go to /fpdb/ open the database, open the Login table, and modify the username and password fields, by default the username is rebel and the password is moon. 3. Make your /fpdb/ directory executable trough IIS management console, this will prevent someone from downloading it's contents, which in this case is the database ServerVariables.mdb. 4. Give the IUSR_Machine account, write permissions to the /fpdb/ServerVariables.mdb database, otherwise you will receive and ODBC error 5. Include this snippet into every page you want tracked. Every page you want tracked must have the .asp extension, otherwise it wont log to the database 6. That's it. Go to http://www.yourhost.com/users, login and start viewing your hits. [b]Download the files at http://dev.pagedream.com/Track_UserVer2.zip [/b] View snapshots at http://dev.pagedream.com Let me know if you have any questions, or problems. --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 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