Results for "Category: String Manipulation"
Easy Forums is a fully functional message board system, developed using MS Active server pages: Features: - Authenticated login to registered users and facility of registration of new users - Sorting the Message board threads on the basis of Date, Email, Name, Subject etc. by a single click - Allows users to post new messages and reply to old messages. Feel free to modify, distribute, use this code as you may please, and if you like it please VOTE FOR ME in the contest.
I wrote this for my company's intranet to display a search for our standard operating procedures. It will search a table in my database that contains SOP titles and is multi-word capable. It will also display the results as hyperlinks to htm files containing the SOP's.
the sample will show how to display message fromt he database when a user logs in and how his session will get expired and after session expiration he was not able to read hiw messages until he logs in again
This code delete duplicate records in MSAcces database.
Shows how to get recordset data into a VB (or other) application from remote databases on the web, edit it, and put back the changes - all from simple ASP pages on the server via HTTP using ADO + XML - 1 line of code in VB to retrieve, 3 to return (+ not more than 25 lines of ASP on the server) for the simplest case. Requires :IE5 (IE4 will not work!), ADO 2.5+, XML (3 preferred) on Client PC / IIS4+ or PWS, ADO 2.5+, XML3 on Server
the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality). although it is coded in vb, it can be compiled into a dll to be used as an object referenced by asp. otherwise it can be run as a stand-alone vb app. i have included a screen shot and added commenting to my code to make it more understandable. if you do not have a lot of experience in vb and asp this will be difficult for you to modify although it can be implemented by anyone.
Hello, This is a complete security small webpages I using ASP. Its allows user to enter their username/userpassword, in order to getting further into your webpages. Its also allows new user to creates a very simple account like: User FullName, User nickname and User password. I hope that it will gives you ideas to program better in ASP. Thank you for using this Tri Nguyen PS: Please dont forget to rate and drop me a line for this my friends!
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.
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.
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.
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
This code snippet will compact your Access DB online. You can do this via a web browser!
This Article explain and gives an example how to create a tool-tips in ASP page includes the data from one or more fields in the database in a grid.
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.
Looking for faster performance? If you have an older database driven ASP app, it probably uses an ODBC DSN in its connection string to reach the database. It probably looks alot like this: "DSN=myDSNName;". If you see this you should immediately upgrade the code to ADO/OLEDB--Microsoft's new standard. Not only will this help you keep the code current, but it will run faster and take up less memory. Below are the connection strings for OLEDB/ADO for both Access and SQL Server--the two most common databases for IIS platforms. If you are using another database, you'll need to consult your db's ADO Provider's documentation for the proper connection string.
Display a page that allows you to type in a SQL Query statement, and display the results in HTML Table format. The number of field parameters and field names are immaterial. It will display the results in an easy to read format. Great for customer reports. The Code will not allow an Update or Delete query.