|
|
|
|
|
Total Hits: 245 | Today: 0 |
Author: Robert Hess
|
Rating:
|
|
|
How can I detect if a user clicks the browser's Stop button while viewing my Web page?
Starting with Microsoft® Internet Explorer 5.0, your client-side code can trap the onstop event. This will let you know when the user clicks the Stop button, hits the Escape key, or when the page is being unloaded.
Trapping the onstop event is handy when your page is performing some process that you want to stop when the user clicks the Stop button. Some processes that users might want to stop include ba...
|
|
|
|
Total Hits: 134 | Today: 0 |
Author: Vic Mackey
|
Rating:
|
|
|
This is an extended stored procedure for Microsoft SQL Server 2000 that implements an optimized MD5 hash algorithm. It is intended to work much like the MySQL MD5() function. The algorithm was taken from here. I only added the md5_string() function. The DLL should work for older versions of SQL Server too, although I have not tested that. The source was compiled and tested on Microsoft Visual C++ 6.0 and .NET 2003....
|
|
|
|
Total Hits: 129 | Today: 0 |
Author: Jonathan Hodgson
|
Rating:
|
|
|
This article describes using a Wiki for knowledge sharing and database schema documentation. In a departure from normal CodeProject articles this is less about the code and more about improving development practices. We will discuss what a Wiki is and how you might use one. Hopefully from this overview you'll be able to see how it might benefit you and your team to share information. After the summary of what a Wiki is, I'll discuss customising a free Microsoft Active Server Pages (ASP) implemen...
|
|
|
|
Total Hits: 170 | Today: 0 |
Author: Paul Yao and David Durant
|
Rating:
|
|
|
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SQL Server and IIS. The architecture of SQL Server CE, along with data manipulation, s...
|
|
|
|
Total Hits: 3120 | Today: 0 |
|
Rating:
|
|
|
I''ve scoured the Web for a good article on how to put images into SQL server using ASP. None seemed to exist. So I invested in an inexpensive COM object, ASPUpload, which solved most of the problem. However, now that I could get images into SQL, I needed to find out how to get them out and properly display them. There was a lack of information about this as well, and the ASPUpload sample code didn''t work consistantly....
|
|
|
|
Total Hits: 743 | Today: 0 |
|
Rating:
|
|
|
Recently while we were upsizing an MS Access application to SQL Server, we noticed some strange behaviour regarding the way dates were displayed. Some data entry screens in our MS Access client required users to enter time values in the format: 8:15 am, with no corresponding date value. Although the application displayed and treated these values as pure time values with no date portion, Access was storing a default date (or zero date) along with the time value
...
|
|
|
|
Total Hits: 1089 | Today: 0 |
|
Rating:
|
|
|
Performance tuning and optimization techniques for Microsoft SQL Server, including SQL/ASP performance tips....
|
|
|
|
Total Hits: 99 | Today: 0 |
Author: BrianLaF.
|
Rating:
|
|
|
This project is for Milonic menu users. It edits mm_items and mm_menus tables in the Milonic's sample mssql database. Some field additions must be made and the first field set as the primary key.
Features include a preview menu and the option to publish the menu after making changes. Records can be inserted, updated or deleted....
|
|
|
|
Total Hits: 121 | Today: 0 |
Author: Jesudas Chinnathampi (Das)
|
Rating:
|
|
|
There will be many occassion, in which we will be urged to store images in the Database. In some applications we may have some sensitive information which cannot be stored in a file system, since if anything is in the file system, then it may be very easy for the users to hack the pictures/images....
|
|
|
|
Total Hits: 210 | Today: 0 |
Author: Dan Pomerchik
|
Rating:
|
|
|
You've probably heard of SQL. What does it mean, you ask. Well, SQL (Structured Query Language) is a very handy tool for database programmers (including ASP programmers). Without SQL, it would be very difficult to perform many common tasks relating to databases. In this article, I will teach you the basics and the common uses of SQL...
|
|
|
|
Total Hits: 226 | Today: 0 |
Author: Abdul (Rajib) Bahar
|
Rating:
|
|
|
Try and Catch is very popular among the developer community writing code in C#, C++, or other high level languages. The conventional term referring to Try-Catch blocks is Exception Handling. Exception Handling is simply a breach of an application's predefined assumptions. It enables us to provide a reliable data/process validation mechanism in our applications. SQL Server did not have any close counterpart for it until now. Prior to SQL Server 2005, many of us relied on the variable @@ERROR. If ...
|
|
|
|
Total Hits: 131 | Today: 0 |
Author: Andrew Starling
|
Rating:
|
|
|
UltraDev is very good at creating SQLSelect statements for recordsets, as explained in our earlier articles ASP using Dreamweaver UltraDev and PWS and More ASP using Dreamweaver UltraDev. But if you want to do really flashy things in SQL there comes a point when UltraDev runs out of steam and you have to write the code yourself. Here are some examples of hand-coding, followed by a guide to debugging errors. As before, these examples are taken from a real (and therefore sometimes imperfect!) deve...
|
|
|
|
Total Hits: 179 | Today: 0 |
|
Rating:
|
|
|
OK, so you got through our SQL Basics Tutorial. Now, we are moving on to some more advanced SQL statements. As a refresher, here is our standard connection and recordset information, which shows you where your SQL will go....
|
|
|
|
Total Hits: 326 | Today: 0 |
Author: aspdev
|
Rating:
|
|
|
Before you can access your MS SQL Server database from ASP, you need to connect to it using one of the following methods:
. Connect to a MS SQL Server database with OLE DB.
. Connect to a MS SQL Server database with SQL Driver....
|
|
|
|
Total Hits: 1584 | Today: 0 |
Author: Joe O'Donnell
|
Rating:
|
|
|
ASP allows even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular. In this article Joe teaches us how to connect to SQL Server 2000 using system DSN's and an OLEDB connection string....
|
|
|
|
Total Hits: 727 | Today: 0 |
Author: Carvin Wilson
|
Rating:
|
|
|
How to use the SQL Distributed Management Objects from ASP...
|
|
|
|
Total Hits: 5527 | Today: 0 |
|
Rating:
|
|
|
This article describes how to run SQL Server stored procedures and use parameters from an Active Server Pages (ASP) page. This article assumes that you are familiar with the procedure to use ActiveX Data Objects (ADO) in an ASP page....
|
|
|
|
Total Hits: 979 | Today: 0 |
|
Rating:
|
|
|
This article helps you build an Active Server Pages (ASP) page, which you can use anytime, anywhere to get the latest schema in today''s most accepted file format: HTML. So, whenever a development team member changes any part of the schema, the page will reflect the changes at the next access, even if the time gap between the change and the access is as short as a second. Because this page becomes a part of your Web-based database project and thus is available on your development Web server.....
|
|
|
|
Total Hits: 1583 | Today: 0 |
|
Rating:
|
|
|
If you are working with the Enterprise Edition of Microsoft Visual Studio®, Visual InterDev includes an SQL debugger that you can use to debug SQL Server stored procedures and triggers in much the same way that you debug other kinds of scripts or programs. However, there are some differences in how you set up SQL debugging and how the debugger runs....
|
|
|
|
Total Hits: 2089 | Today: 0 |
|
Rating:
|
|
|
Full text indexing is a great feature that solves a long running database problem, the searching of textual data columns for specific words and phrases in SQL Server databases. However, as the full-text search engine is a separate component of SQL Server (it uses the Microsoft Search Service) this can be a potential performance problem due to the way full-text search interacts with SQL Server. Full-text search works really well when you are searching...
|
|
|
|
|
|
|
