Results for "Category: String Manipulation"

This is a simple procedure to show how to use an XML file as datasource to build a datagrid in ASP. If you like it please vote. P/S: future updates will be available on http://www.aspwebsolution.com

It gets event better...From user requests I have made some additions to the ASP Report Wizard 2.1. This version includes the ability to save reports and queries. It also includes the absolute capability of exporting reports to different format including Excel, XML, Text and CSV formats. If you need more functionality, please let me know. If you like this code, please vote for me. Thanx

Compact and Repair You can use the "Compact and Repair" function in Access from ASP code. The following code is an example of how this can be done. Note that when you decide to "Compact and Repair" your Access database, some autonumbers can be changed. Access makes all autonumbers consecutive. This code uses one database, but I'm sure the code can easily be changed so that the listbox displays, for example, all the databases in one folder.

This modification of Lewis Moten's RC4 algorithm will allow you to send encrypted strings to DataSources through SQL.

This article demonstrates how to get the ID of just inserted database record using INSERT clause.

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