Results for "Category: String Manipulation"

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

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.