Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

All pages tagged

PHP: Sending Email (Text/HTML/Attachments)

So, you want to send automated email messages from your PHP application. This can be in direct response to a user's action, such as signing up for your site, or a recurring event at a set time, such as a monthly newsletter. Sometimes email contains file attachments, both plain text and HTML portions, and so on. To understand how to send each variation that may exist on an email, we will start with the simple example and move to the more complicated. More...

Tags: PHP SEND EMAIL TEXT HTML DUAL FORMAT ATTACHMENT SMTP SERVER Hits: 1071096 Comments: 20

PHP: How to Get the Current Page URL

Sometimes, you might want to get the current page URL that is shown in the browser URL window. For example if you want to let your visitors submit a blog post to Digg you need to get that same exact URL. There are plenty of other reasons as well. In this tutorial we will show how you can do that. More...

Tags: PHP CURRENT URL SERVER BROWSER Hits: 1043974 Comments: 26

Using Regular Expressions with PHP

Regular expressions are a powerful tool for examining and modifying text. They enable you to search for patterns within a string, extracting matches flexibly and precisely. This tutorial gives a brief overview of basic regular expression syntax and then considers the functions that PHP provides for working with regular expressions. More...

Tags: PHP REGULAR EXPRESSION MATCH REPLACE PATTERN SPLIT FILTER PERL Hits: 802408 Comments: 27

PHP: Multidimensional Arrays

Array does not have to be a simple list of keys and values; each array element can contain another array as a value, which in turn can hold other arrays as well. This way, you can create a multi-dimensional array. In this article principles of using multidimensional arrays are explained and source code defining multidimensional array and displaying the array values on the web page is given. More...

JavaScript: Form Validation

Client side form validation usually done with javascript. For the majority of your users, JavaScript form validation will save a lot of time up front. More...

PHP: How to connect to MSSQL database

This tutorial describes how to connect to MSSQL database with a DSN and without a DSN. More...

Tags: PHP CONNECTION DATABASE MSSQL DSN ADODB DRIVER RETRIEVE PRINT Hits: 447863 Comments: 21

Creating Word, Excel and CSV files with PHP

In this article we demonstrate several ways to create Microsoft Word and Excel documents, and also CSV files using PHP. Learn how to create files using HTTP headers, COM objects, OpenOffice templates, fputcsv function. More...

Tags: PHP CREATE WORD EXCEL CSV FILE Hits: 429754 Comments: 0

Secure File Upload with PHP

PHP makes uploading files easy. You can upload any type of file to your Web server. In spite of security issues that should be addressed before enabling file uploads, the actual mechanisms to allow this are straight forward. In this tutorial we will consider how to upload files to some directory on your Web server. We will also discuss security issues concerned with the file uploading. More...

Tags: PHP SECURE FILE UPLOAD HTML VALIDATION SIZE TYPE UNIQUE Hits: 390572 Comments: 45

Back Up and Restore a MySQL Database

If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server. More...

Tags: MYSQL BACKUP RESTORE ZIP SHELL PHPMYADMIN HOW-TO Hits: 365260 Comments: 3

PHP: Create Thumbnail Images

This tutorial will describe how to create thumbnail images on the fly using PHP. Furthermore you will learn how to process a whole folder of images and create their thumbnails. Since this requires the GD library, you will need an installation of PHP with at least GD 2.0.1 enabled. More...

Tags: PHP DYNAMIC IMAGE THUMBNAIL GENERATION GD2 STORE Hits: 335537 Comments: 46

Create CAPTCHA Protection using PHP and AJAX

CAPTCHA is a simple test to determine if a user is a computer or a human. It is used to prevent spam abuse on the websites. The goal of this tutorial is to demonstrate how to make your own simple CAPTCHA protection using PHP and AJAX technologies. More...

Tags: PHP JAVASCRIPT AJAX CAPTCHA DYNAMIC IMAGE GENERATION GD SECURE SPAM Hits: 247277 Comments: 34

PHP: How to Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready. More...

PHP: Passing Javascript variables to PHP

JavaScript is mainly used as a client side scripting language, while PHP is a server side technology. Unlike Java or ASP.Net, PHP doesn't have tools to make it work client side. That is why you need to combine JavaScript and PHP scripts to develop powerful web-applications. More...

Tags: PHP JAVASCRIPT VARIABLES PASSING SCRIPTS GET Hits: 210169 Comments: 14

PHP: How to connect to MySQL database using PHP

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running. More...

Tags: PHP CONNECTION DATABASE MYSQL FUNCTIONS RETRIEVE PRINT SQL QUERY Hits: 184270 Comments: 25

PHP: Dynamic Image Generation

Creating images on the fly can be a very useful skill. In this tutorial we will show you how to get quite interesting and useful effects using image handling functions. We will review two practical tasks: creating security images (captcha) on the fly and building a bar chart using numerical values retrieved from MySQL database. More...

Tags: DYNAMIC IMAGE GENERATION GD CAPTCHA GRAPH STORE CACHE Hits: 166961 Comments: 20

HTML: How to Control Tab Order

All elements (except hidden elements) in the HTML form are part of the form's tab order. When the user presses the Tab key, the browser shifts the input focus from element to element in order the elements appear in the HTML code. However, sometimes you want the tab order to flow a little differently. More...

Tags: HTML CONTROL ORDER TABINDEX ATTRIBUTES Hits: 166834 Comments: 1

Access: Format Function

In Access, the Format function returns a string containing an expression formatted according to instructions contained in a format expression. More...

Tags: ACCESS FUNCTION FORMAT EXPRESSION Hits: 166512 Comments: 6

Sending email with ASP

In this article we demonstrate how to generate and send emails with ASP using CDOSYS - Microsoft's improved interface for SMTP email. You will learn how to send text and html emails, emails with attachments, use a remote server, load recipients from a database, set the priority / importance of an email and request a read/return receipt. More...

JavaScript: How to disable the Enter key on HTML form

Normally when you have a form with several text input fields, it is undesirable that the form gets submitted when the user hits ENTER in a field. Some people are pressing the enter key instead of the tab key to get to the next field. They often do that by accident or because they are accustomed to terminate field input that way. If a browser regards hitting ENTER in a text input field as a request to submit the form immediately, there is no sure way to prevent that. More...

Tags: JAVASCRIPT FORM ENTER KEY DISABLE CONTROL INPUT Hits: 150790 Comments: 23

jQuery File Upload

Wow, Yet another upload plugin! What makes it different?

  • It's new. Supports all modern technologies.
  • It's good looking and works out of the box. Based on Bootstrap and Glyphicons icons.
  • Cross domain upload, client size images resing.
  • Supports multiple platforms (PHP, Python, Ruby on Rails, Java, Node.js, etc)

More...

Tags: PHP UPLOAD JQUERY PYTHON Hits: 144875 Comments: 0

How to install and cofigure PHP 5 on Windows box

This article explains the steps you need to follow to configure PHP and secure its correct operation. More...

Tags: PHP INSTALLATION CONFIGURE PHP5 WINDOWS HOW-TO SETUP IIS APACHE Hits: 137891 Comments: 11

JavaScript: Arrays

Arrays can be used in many ways to store and organize data quickly and efficiently. It is one of the more useful data types available to any programming language. This article describes the basics to create and make operations with indexed, associative, and multidimensional arrays. More...

Form Processing with PHP

One of the best features of PHP is possibility to respond to user queries or data submitted from HTML forms. You can process information gathered by an HTML form and use PHP code to make decisions based off this information to create dynamic web pages. In this tutorial we will show how to create an HTML form and process the data. More...

Tags: PHP FORM PROCESSING GET POST TIPS DYNAMIC Hits: 115407 Comments: 11

PHP: Working with Directories

As is necessary for any language, PHP has a complete set of directory support functions. PHP gives you a variety of functions to read and manipulate directories and directory entries. Like other file-related parts of PHP, the functions are similar to the C functions that accomplish the same tasks, with some simplifications. This tutorial describes how PHP handles directories. You will look at how to create, remove, and read them. More...

Tags: PHP PHP5 DIRECTORIES FILES FUNCTIONS RECURSION ITERATORS Hits: 109556 Comments: 2

PHP: Conditional Statements

Sometimes when you write code, you want to perform different actions for different decisions. You can use conditional statements in your code to do this. In this tutorial we will look at two structures: if...else and switch statements. In this tutorial we will will show you how to use both of them. More...

Tags: PHP CONDITIONALS IF SWITCH ACTION CONDITION Hits: 108941 Comments: 2

BBCode editor

As soon as you've decided to implement BBCode in your software product, we propose you to examine the jquery.BBCode plugin. This Jquery library plugin is a simple BBCode editor with preview option, which can be easily placed on any website. More...

Tags: BBCODE EDITOR PREVIEW Hits: 107344 Comments: 0

Debugging PHP with Xdebug

The Xdebug is the extension for PHP that helps debugging PHP scripts by providing a lot of valuable debug information. Using the Xdebug you can debug your scripts in the Notepad++ and other PHP IDEs. More...

Tags: PHP DEBUG XDEBUG NOTEPAD++ Hits: 100099 Comments: 0

How to create a dump of MySQL database in one click

Your users probably asked you to add an option to export the whole database to SQL file. This can be done in phpMyAdmin or Navicat of course but your users want something simpler than that. More...

Tags: PHP MYSQL BACKUP DUMP EXPORT Hits: 99963 Comments: 0

Bike - drop in phpMyAdmin replacement

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps.

Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

More...

Tags: PHP MYSQL PHPMYADMIN Hits: 98144 Comments: 0

ASP: How to connect to MS SQL Server database

In this tutorial we will show you how to connect to a MS SQL Server database using a DSN and without a DSN. More...

Tags: ASP CONNECTION DATABASE MSSQL DSN DRIVER RECORDSET SQL Hits: 90905 Comments: 5

PHP: Export Database Schema as XML

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema. More...

Tags: PHP MYSQL XML SCHEMA Hits: 80150 Comments: 7

Access: IIF Function

In Access, the IIF function returns one of two arguments depending on the evaluation of an expression. More...

Tags: ACCESS FUNCTION IIF EXPRESSION Hits: 79174 Comments: 0

PHP: Arrays

Arrays can be used in many ways to store and organize data quickly and efficiently. It is one of the more useful data types available to any programming language. This article describes the basics to create and make operations with indexed, associative, and multidimensional arrays. More...

PHP: Blocking access to the login page after three unsuccessful login attempts

Sometimes you need to add an extra protection to password-protected website. This article explains how access to the login page can be restricted after three unsuccessful login attempts. This schema uses visitors IP address to store log attempts in the database and block access to login feature for 30 minutes after third unsuccessful attempt. More...

ASP: How to Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready. More...

Access: Date Function

In Access, the Date function returns the current system date. More...

Tags: ACCESS FUNCTION DATE SYSTEM CURRENT Hits: 63302 Comments: 0

ASP: How to connect to MySQL database

In this tutorial we will show you how to connect to MySQL database using a DSN and without a DSN. More...

PHP: How to Sort an Array

It is often necessary to arrange the elements in an array in numerical order from highest to lowest values (descending order) or vice versa (ascending order). If the array contains string values, alphabetical order may be needed. Sorting a one-dimensional arrays is quite easy. More...

Tags: PHP ARRAYS SORTING INDEXED ASSOCIATIVE REVERSE NUMBER STRING Hits: 63204 Comments: 2

ASP: How to connect to database using a connection string

The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to our Access database and retrieve all the records from the table. More...

Tags: ASP CONNECTION DATABASE ADO ACCESS OLEDB ODBC SQL RETRIEVE PRINT Hits: 62277 Comments: 2

MS Access Connection Strings

MS Access ODBC and OLEDB connection strings More...

Tags: ACCESS ODBC OLEDB CONNECTION STRING Hits: 62236 Comments: 0

ASP: How to Get the Current Page URL

Sometimes, you might want to get the current page URL that is shown in the browser URL window. For example if you want to let your visitors submit a blog post to Digg you need to get that same exact URL. There are plenty of other reasons as well. In this tutorial we will show how you can do that. More...

Tags: ASP CURRENT URL SERVER BROWSER Hits: 61063 Comments: 8

PHP: Variables

A variable is a holder for a type of data. So, based on its type, a variable can hold numbers, strings, booleans, objects, resources or it can be NULL. In PHP all the variables begin with a dollar sign "$" and the value can be assignes using the "=" operator. This article shows the basic idea on how to use variables in PHP, along with examples, and descriptions of the examples. More...

Access: DateDiff Function

In Access, the DateDiff function returns the number of time intervals between two dates. More...

Tags: ACCESS FUNCTION DATEDIFF TIME INTERVAL DATE Hits: 58984 Comments: 0

JavaScript: Conditional Statements

Sometimes when you write code, you want to perform different actions for different decisions. You can use conditional statements in your code to do this. avaScript supports two conditional statements: if...else and switch. In this tutorial we will will show you how to use both of them. More...

Tags: JAVASCRIPT CONDITIONALS IF ELSE SWITCH CONDITION ACTION Hits: 57963 Comments: 0

Better PHP developer

Many web developers consider PHP as a second class language. The truth is, as DHH puts it: "You can build the best web application in the world with any language you want". We are here not to start a religious war but to help beginner PHP developers get better. Here is the some of the best advice from season PHP programmers.

First steps

  1. Get into the habit of commenting your code thoroughly from the outset, your future self will thank you https://www.phpdoc.org/
  2. Ignore any online tutorials, stack-overflow solutions or any other PHP code snippets on the internet that are older than 3 or 4 years (use Google's advanced search date tools to filter out older content). PHP had evolved dramatically in the last few years, and much of what is out there is wrong, insecure and bad practice. More...

    Tags: PHP,DEVELOPER,BEGINNER Hits: 57716 Comments: 0

MS SQL Server Connection Strings

MS SQL Server ODBC and OLEDB connection strings More...

Tags: MSSQL ODBC OLEDB CONNECTION STRINGS Hits: 56865 Comments: 0

PHP: Looping Statements

PHP performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in PHP, along with examples, and descriptions of the examples. More...

Tags: PHP LOOPING FOR WHILE DO...WHILE FOREACH BREAK CONTINUE LOOPS Hits: 55667 Comments: 1

ASP: How to process the data submitted from HTML form

The great advantage of ASP is possibility to respond to user queries or data submitted from HTML forms. You can process information gathered by an HTML form and use ASP code to make decisions based off this information to create dynamic web pages. This tutorial demonstrates how to create an HTML form and process the data. More...

JavaScript: Functions

Sometimes instead of just adding your javascript to the page and having the browser perform the tasks as soon as the script is read, you might want your javascript to be performed only upon the detection of a certain event. A function is a block of code which can be called from any point in a script after it has been declared. It is basically a compartmentalized JavaScript designed to accomplish a single task. Furthermore, JavaScript written into functions will not be performed until you specifically ask for it. This way you gain complete control of the timing. Functions are useful because they contribute to rapid, reliable, error-reducing coding, and increase legibility by tiding up complicated code sequences. More...

Access: Replace Function

In Access, the Replace function returns a string in which a sequence of characters has been replaced with another set of characters a specified number of times. More...

Tags: ACCESS FUNCTION REPLACE SEQUENCE SET CHARACTERS Hits: 49120 Comments: 4

Javascript: Variables

A variable's purpose is to store information so that it can be used later. A variable is a name, or identifier, that represents some data that you set. This article shows the basic idea on how to use variables in JavaScript, along with examples, and descriptions of the examples. More...

Access: Count Function

In Access, the Count function calculates the number of records in a select query. More...

Tags: ACCESS FUNCTION COUNT QUANTITY RECORDS SELECT QUEY Hits: 47526 Comments: 0

SQL: IN Operator

In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to the Where clause. When used in this context, we know exactly the value of the returned values we want to see for at least one of the columns. More...

Tags: SQL IN WHERE QUERY RANGE INCLUSION EXCLUSION Hits: 47343 Comments: 2

SQL: ORDER BY

The Order By clause imposes an order on the query results. More...

Reading the "clean" text from PDF

Portable Document Format (PDF) is a file format created for document exchange. Let's read the plain text from the PDF file. More...

Tags: PHP PDF PARSE Hits: 45261 Comments: 1

Access: DatePart Function

In Access, the DatePart function returns the specified part of a given date. More...

Tags: ACCESS FUNCTION DATEPART PART DATE Hits: 43250 Comments: 0

JavaScript: Loops

JavaScript performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in JavaScript, along with examples, and descriptions of the examples. More...

Access: Left Function

In Access, the Left function returns the leftmost n characters of a string. More...

Tags: ACCESS FUNCTION LEFT Hits: 42800 Comments: 0

Access: Sum Function

In Access, the Sum function returns the sum of a set of values in a set of values in a select query. More...

Tags: ACCESS FUNCTION SUM SELECT QUERY VALUE Hits: 42444 Comments: 1

SQL: DISTINCT Clause

The Distinct keyword eliminates duplicate rows from the query results. More...

Tags: SQL DISTINCT DUPLICATE ELIMINATION QUERY Hits: 42282 Comments: 3

SQL: HAVING Clause

The Having clause is optional and used in combination with the Group By clause. It is similar to the Where clause, but the Having clause establishes restrictions that determine which records are displayed after they have been grouped. More...

Tags: SQL HAVING QUERY GROUPBY RESTRICT DETERMINE DISPLAY Hits: 41951 Comments: 0

ASP: Arrays

There are two types of VBScript arrays - static and dynamic. Static arrays remain with fixed size throughout their life span. To use static VBScript arrays you need to know upfront the maximum number of elements this array will contain. If you need more flexible VBScript arrays with variable index size, then you can use dynamic VBScript arrays. VBScript dynamic arrays index size can be increased/decreased during their life span. Further in this article author explains how to create static arrays and how to create and resize dynamic arrays, giving working examples. More...

Tags: ASP ARRAYS STATIC DYNAMIC INDEX SIZE RESIZE EXAMPLES Hits: 41932 Comments: 4

Access: Switch Function

In Access, the Switch function evaluates a list of expressions and returns a Variant value or an expression associated with the first expression in the list that is True. More...

Tags: ACCESS FUNCTION SWITCH LIST VARIANT EXPRESSION Hits: 41794 Comments: 4

Access: DateAdd Function

In Access, the DateAdd function Adds a specified time interval to a date. More...

Tags: ACCESS FUNCTION DATEADD TIME INTERVAL DATE Hits: 41388 Comments: 2

ASP: Looping Statements

ASP performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in ASP, along with examples, and descriptions of the examples. More...

What is PHP?

PHP stands for Hypertext Preprocessor and is a server-side language. This article introduces you to PHP. You will learn basic PHP syntax, what it looks like, and possibilities that PHP provides you with. More...

ASP: Multidimensional Arrays

Arrays do not have to be a simple list of keys and values; each location in the array can hold another array. This way, you can create a multi-dimensional array. The reason you may use this type of array is when you have records of each item. For example, car, year, price,... and you want display one record at a time. In this article principles of using two-dimensional arrays are explained and source code defining two-dimensional array and displaying the array values on the web page is given. More...

Tags: ASP ARRAYS MULTIDIMENSIONAL MATRIX RECORDS UBOUND Hits: 40258 Comments: 2

PHP: Functions

A function is a block of code which can be called from any point in a script after it has been declared. It is basically a compartmentalized PHP script designed to accomplish a single task. Functions are useful because they contribute to rapid, reliable, error-reducing coding, and increase legibility by tiding up complicated code sequences. More...

Tags: PHP FUNCTIONS CREATE SCOPE LIFETIME RE-USABLE CODE Hits: 40122 Comments: 3

ASP: How to set up a system DSN

This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine. More...

Tags: DSN SETUP SYSTEM HOW-TO Hits: 39171 Comments: 0

ADO and ADO.NET Connection Strings

Connection strings are string variables which contain database connection information and then passed to ADO which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. More...

VBScript Functions

This tutorial will provide you with a quick look at the more important VBScript functions. They include functions for type checking, date manipulation, string manipulation, formatting, math, and more. More...

Tags: VBSCRIPT FUNCTIONS REFERENCE Hits: 38802 Comments: 1

ASP: Conditional Statements

Sometimes when you write code, you want to perform different actions for different decisions. You can use conditional statements in your code to do this. There are two types of conditional statements in ASP: if...then and select case. In this tutorial we will will show you how to use both of them. More...

Tags: ASP CONDITIONALS IF SELECT SWITCH CONDITION ACTION Hits: 38445 Comments: 0

Using Cookies in PHP

A cookie is a message given to a Web browser by a Web server. The browser stores the message in a small text file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, the cookie is sent back to the server too. The main purpose of cookies is to identify users and possibly prepare customized Web pages for them. In this tutorial you'll learn about using Cookies in PHP. More...

Access: Mid Function

In Access, the Mid function returns a string containing a specified number of characters from a string. More...

Tags: ACCESS FUNCTION MID SPECIFIED NUMBER Hits: 36072 Comments: 0

Oracle Connection Strings

Oracle ODBC and OLEDB connection strings More...

Tags: ORACLE ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 35521 Comments: 0

Access: Month Function

In Access, the Month function returns an Integer between 1 and 12, inclusive, containing the month part of a date. More...

Tags: ACCESS FUNCTION MONTH RANGE DATE Hits: 34957 Comments: 0

Access: DateValue Function

In Access, the DateValue function returns the date represented by the date of a String argument. More...

Tags: ACCESS FUNCTION DATEVALUE DATE STRING Hits: 34457 Comments: 0

MySQL Connection Strings

MySQL ODBC and OLEDB connection strings More...

Tags: MYSQL ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 34415 Comments: 0

Access: IsNull Function

In Access, the IsNull function returns a boolean value that indicates whether or not an expression contains no valid data (Null). More...

Tags: ACCESS FUNCTION ISNULL VALID Hits: 32068 Comments: 1

Your first PHP Script

Now that you have installed all the support software for running PHP, you are ready to learn how to do a PHP script. Writing a PHP script is very simple. No special software is needed, except a text editor like Notepad in which the script is written. More...

Tags: PHP SYNTAX RULES PRINT OUTPUT Hits: 31411 Comments: 10

ASP: Functions and Subprocedures

You can write functions in ASP similar to the way you write them in Visual Basic. It is good programming practice to use functions to modularize your code and to better provide reuse. This article explains benefits of using functions and subprocedures, shows difference between them, and gives code for function that prints out info or takes an integer value and returns the square of that value. More...

Show different content to search engine visitors

Perhaps, you face a task to show slightly different information to different website visitors. We decided to address this issue by implementing a generic JavaScript solution. More...

Tags: JAVASCRIPT SHOW DIFFERENT CONTENT MESSAGE SEARCH ENGINE USERS Hits: 30165 Comments: 0

PHP: DSN and DSN-less connections

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN. More...

Tags: PHP ACCESS DATABASE DSN DSN-LESS ADODB OLEDB DRIVER CONNECTION Hits: 29580 Comments: 0

ASP Response Object

The Response object is used to send output to the client from the web server. In this tutorial the syntax, collections, properties and methods of the ASP Response object are described. More...

Access: Int Function

In Access, the Int function returns the integer portion of a number. More...

Tags: ACCESS FUNCTION INT INTEGER NUMBER Hits: 28741 Comments: 0

SQL: Join

Single table queries are useful but they do not exploit the full power of the SQL language. SQL is relational database query language and as such, one of its most important features is its ability to retrieve information from several different related tables. In relational database terms, this process is called a join. More...

Tags: SQL JOIN QUERY RETRIEVE RELATIONSHIPS MATCHING Hits: 28706 Comments: 1

Access: DateSerial Function

In Access, the DateSerial function returns the date for a specific year, month, and day. More...

Tags: ACCESS FUNCTION DATESERIAL DATE SPECIFIC DAY MONTH YEAR Hits: 28502 Comments: 0

Access: Year Function

In Access, the Year function returns an integer between 100 and 9999, inclusive, that represents the year of a date argument. More...

Tags: ACCESS FUNCTION YEAR RANGE REPRESENTATION DATE Hits: 28199 Comments: 0

SQL: INSERT Statement

The Insert Into statement can be used to append a record to a table or to append multiple records from one table to another. More...

Tags: SQL INSERT QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 28119 Comments: 2

Access: Trim Function

In Access, the Trim function returns a copy of a string with leading and trailing spaces removed. More...

Tags: ACCESS FUNCTION TRIM LEADING TRAILING SPACE REMOVE Hits: 28090 Comments: 0

JS: Set Focus to First Available Form Control

Sometimes it is necessary to set the focus to the first available form control. The problem is that complex web pages can contain multiple forms and each form individually can contain hidden or disabled elements and controls that cannot accept focus. In this tutorial we will create a function which iterates through all forms until it finds the first available form control. More...

Tags: JAVASCRIPT FORM AVAILABLE CONTROL FOCUS ITERATION Hits: 27772 Comments: 4

How to install ASP on your own computer

It's not difficult to install and run ASP on your own computer. To do that, you must install Microsoft's Personal Web Server (PWS) or Internet Information Services (IIS). More...

Tags: ASP INSTALLATION IIS PWS WINDOWS HOW-TO MICROSOFT Hits: 27710 Comments: 0

ASP Request Object

The Request object retrieves the values that the client browser passed to the server during an HTTP request. It is used to get information from the user. Using this object, you can dynamically create web pages and perform various server-side actions based on input from the user. In this tutorial the syntax, collections, properties and methods of the ASP Request object are described. More...

ASP FileSystemObject Object

The FileSystemObject object provides access to the file system on the web server, allowing us to manipulate text files, folders and drives from within our code. In this tutorial the properties and methods of the FileSystemObject object are described. More...

ASP: Variables

Declaring variables in ASP is simple. You don't have to declare if your variable is an integer, string, or object. You just declare it, and it has the potential to be anything. To declare a variable in ASP/VBScript we use the Dim statement. If you wanted to print out the variables, you could use the ASP Response.Write command. Learn more about the rules for declaring and naming variables in ASP/VBScript and use of Option Explicit statement in our article Variables in ASP. More...

ASP: Cookies

A cookie is a message given to a Web browser by a Web server. The main purpose of cookies is to identify users and possibly prepare customized Web pages for them. This article explains benefits of using cookies and shows how to create and retrieve them. Dictionary cookies are also explained. More...

Access: Chr Function

In Access the Chr function returns the character associated with the specified ANSI code. More...

Tags: ACCESS FUNCTION CHR ANSI CODE Hits: 26558 Comments: 0

Access: First Function

In Access, the First function return a field value from the first record in the result set of a query. More...

Tags: ACCESS FUNCTION FIRST RECORDSET RESULT Hits: 26295 Comments: 1

ASP: Troubleshooting Active Server Pages (ASP) on Windows 2003

This article will help you to find answers to the problems some users have with ASP on Windows 2003. More...

Tags: ASP WINDOWS TROUBLESHOOTING QUESTIONS PROBLEMS ANSWERS LINKS Hits: 25339 Comments: 0

Access: Choose Function

In Access, the Choose function selects and returns a value from a list of arguments based on a given position. More...

Tags: ACCESS FUNCTION CHOOSE LIST ARGUMENTS Hits: 25224 Comments: 0

ASP Dictionary Object

The Dictionary object is used to store name/value pairs (referred to as the key and item respectively). The Dictionary object is like an associative array, but with its own built-in functionality that looks after the basic tasks of storing and manipulating the data, and sizing for the required number of elements. More...

ASP Session Object

The Session object stores information needed for a particular user's session on the web server. It is automatically created every time when an ASP page from the web site or web application is requested by a user who does not already have a session, and it remains available until the session expires. In this tutorial the syntax, collections, properties, methods and events of the ASP Session object are described. More...

Access: StrConv FunctionAccess: StrConv Function

In Access, the StrConv function convert a string to upper case, lower case, proper case, or several other formats. More...

Tags: ACCESS FUNCTION STRCONV UPPERCASE LOWERCASE FORMAT CONVERT Hits: 25013 Comments: 0

Access: Max function

In Access, the Max function returns the maximum of a set of values in a select query. More...

Tags: ACCESS FUNCTION MAX MAXIMUM SELECT QUERY Hits: 24814 Comments: 0

What can php do for you?

List with some of possibilities that PHP provides you with. More...

Tags: PHP POSSIBILITIES ADVANTAGES FEATURES Hits: 24751 Comments: 6

PHP: Constants

Constants just as variables are used to store information. The main difference between constants and variables is that constant value can not be changed in the process of running program. It can be mathematic constants, passwords, paths to files, etc. More...

Tags: PHP CONSTANTS VARIABLES DIFFERENCE BUILT-IN OUTPUT Hits: 24487 Comments: 3

Access: Str Function

In Access, the Str function returns string representation of a number. More...

Tags: ACCESS FUNCTION STR STRING REPRESENTATION Hits: 24321 Comments: 0

Meta Refresh Tag. How to reload the web page.

One of the most common uses of the meta tag is to reload the web page. This is great for displaying real-time data, or as real as the refresh rate. It is very convenient to use it if you have a dynamic content on your page (for example a weather map). This tag is easy to use and misuse. More...

Tags: HTML META REFRESH TAGS RELOAD PAGE DYNAMIC Hits: 24109 Comments: 2

SQL: Union Clause

The Union clause allows you to combine the result sets of 2 or more individual queries. More...

Tags: SQL UNION QUERY COMBINE RESULTS SELECT Hits: 23789 Comments: 1

SQL: LIKE Condition

The Like condition allows you to use wildcard characters to specify one or more string character values. More...

Tags: SQL LIKE CONDITION WHERE QUERY WILDCARD PATTERN Hits: 23446 Comments: 0

Access: Val Function

In Access, the Val function returns a variant indicating the sign of a number. More...

Tags: ACCESS FUNCTION VAL VARIANT INDICATE Hits: 22874 Comments: 0

SQL: SELECT statement

The Select statement allows you to retrieve records from one or more tables in your database. More...

Tags: SQL SELECT RETRIEVE RECORDS DATABASE TABLE Hits: 22243 Comments: 0

Access: Right function

In Access, the Right function returns the rightmost n characters of a string. More...

Tags: ACCESS FUNCTION RIGHT CHARACTERS Hits: 22142 Comments: 0

Microsoft Access Specifications and Limitations

Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum sizes and numbers of various objects defined in Microsoft Access databases. More...

Tags: ACCESS SPECIFICATIONS LIMITATIONS NUMBER SIZE LENGTH Hits: 21547 Comments: 2

Access: Day Function

In Access, the Day function returns an integer between 1 and 31, inclusive, that represents the day of the month corresponding to the date provided as an argument. More...

Tags: ACCESS FUNCTION DAY INCLUSIVE RANGE Hits: 21396 Comments: 0

SQL: UPDATE Statement

The Update statement allows you to update a single record or multiple records in a table. More...

Tags: SQL UPDATE QUERY SINGLE MULTIPLE RECORDS Hits: 21362 Comments: 0

Access: Last Function

In Access, the Last function return a field value from the last record in the result set of a query. More...

Tags: ACCESS FUNCTION LAST RESULT RECORDSET QUERY Hits: 21297 Comments: 0

Access: Asc Function

In Access, the Asc function returns an integer representing the ANSI code corresponding to the first character in a string. More...

Tags: ACCESS ASC FUNCTION ANSI CODE Hits: 19898 Comments: 0

Access: Round Function

In Access, the Round function returns a number rounded to a specified number of decimal places. More...

Tags: ACCESS FUNCTION ROUND SPECIFIED DECIMAL Hits: 19880 Comments: 1

ASP Server Object

The Server object provides access to properties and methods on the server. Much of functionality it provides is simply functionality the web server itself uses in the normal processing of client requests and server responses. In this tutorial the syntax, properties and methods of the ASP Server object are described. More...

Access: Now Function

In Access, the Now function returns the current date and time according your computer's system date and time. More...

Tags: ACCESS FUNCTION NOW CURRENT DATE TIME SYSTEM Hits: 19787 Comments: 0

Access: Time Function

In Access, the Time function returns the current system time. More...

Tags: ACCESS FUNCTION TIME CURRENT SYSTEM TIME Hits: 19569 Comments: 0

Access: Avg function

In Access, the Avg function calculates the arithmetic mean of a set of values in a select query. More...

Tags: ACCESS FUNCTION AVG ARITHMETIC_MEAN SELECT QUERY Hits: 19326 Comments: 0

ASP: How to connect to database with a DSN

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table. More...

SQL: GROUP BY

The Group By clause of the Select statement lets you split up the values in a column as a whole. More...

Tags: SQL GROUPBY QUERY COMBINE RECORDS AGGREGATE SUM COUNT MIN MAX Hits: 19176 Comments: 0

Frames targets. How to target a link to a window.

Targeting windows allows the document writer to assign names to specific windows, and target certain documents to always appear in the window bearing the matching name. Targeting controls where the new document will be displayed when the user follows a link. Most of the time, clicking on a link simply loads a new document in the same window where the link was. In this tutorial we will show you how to deliver the content you want in a new window, or if you are using frames, in another frame. More...

What can JavaScript do?

List with some of possibilities that JavaScript provides you with. More...

Tags: JAVASCRIPT POSSIBILITIES ADVANTAGES FEATURES Hits: 18838 Comments: 0

What is ASP?

ASP stands for Active Server Pages. It is a server side technology that enables you to make dynamic and interactive web pages that are not affected by the type of browser the web site visitor is using. More...

ASP Application Object

The Application object is used to control and manage all items that are available to all users of an Active Server application. The Application items can be variables needed for all users in the application, or they can be instantiated objects that provide special server-side functionality. In this tutorial the syntax, collections, methods and events of the ASP Application object are described. More...

SQL: BETWEEN ... AND...

The Between keyword allows you to define a predicate in the form of a range. More...

Tags: SQL BETWEEN QUERY PREDICATE RANGE UBOUND LBOUND Hits: 18452 Comments: 0

Reading the "clean" text from RTF

Rich Text Format (often abbreviated as RTF), to surprise of many, is quite complex text data format. During its long history RTF bought a lot of add-ons that disturb the process of getting "clean" text. Let's try to solve that... More...

Tags: PHP RTF PARSE Hits: 18208 Comments: 0

Access: LTrim Function

In Access, the LTrim function returns a copy of a string with leading spaces removed. More...

Tags: ACCESS FUNCTION LTRIM LEADING SPACE REMOVE Hits: 18118 Comments: 0

ASP: Constants

Constants just as variables are used to store information. The main difference between constants and variables is that constant value can not be changed in the process of running program. If we attempt to re-assign the value of the constant we'll get a run time error. More...

Tags: ASP CONSTANTS VARIABLES DECLARING CONST KEYWORDS Hits: 17885 Comments: 1

Access: IsDate Function

In Access, the IsDate function returns a value indicating whether or not a variant argument can be converted to a date. More...

Tags: ACCESS FUNCTION ISDATE DATE INDICATE Hits: 17578 Comments: 0

Access: IsNumeric Function

In Access, the IsNumeric function returns a value indicating whether or not an expression can be converted to a numeric data type. More...

Tags: ACCESS FUNCTION ISNUMERIC INDICATE VALUE EXPRESSION Hits: 17561 Comments: 0

Access: Weekday Function

In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week corresponding to the date and the first day of the week provided as arguments. More...

Tags: ACCESS FUNCTION WEEKDAY RANGE REPRESENTATION DATE Hits: 17550 Comments: 0

Access: Len Function

In Access, the Len function returns the length of the specified string. More...

Tags: ACCESS FUNCTION LEN LENGTH STRING Hits: 17427 Comments: 0

Your First ASP Page

This tutorial explains the basics of ASP. It demonstrates how to declare the variables, to do a comment, to output the results and display in a web page time and date on the web server. More...

Access: MonthName Function

In Access, the MonthName function returns a string containing the specified month. More...

Tags: ACCESS FUNCTION MONTHNAME SPECIFIED MONTH Hits: 17209 Comments: 0

Reading text from DOCX and ODT

In this article we will resolve the task of reading the "clean" text from the Office Open XML (more known as DOCX) and OpenDocument Format ODT using PHP. Note that we are not going to apply any third-party software. More...

Tags: PHP DOCX ODT Hits: 16958 Comments: 0

Access: Abs Function

In Access, the Abs funtion returns the absolute value of a number. More...

Tags: ACCESS FUNCTION ABS ABSOLUTE VALUE Hits: 16035 Comments: 0

Access: Rnd Function

In Access, the Rnd function returns a single containing a random number. You can specify the random number to be a value between 2 user-specified numbers. More...

Tags: ACCESS FUNCTION RND RANDOM RANGE Hits: 15606 Comments: 0

ASP TextStream Object

The TextStream object provides sequential access to the contents of text files. This allows you to read, write, or append characters or lines to a text file. In this tutorial the properties and methods of the TextStream object are described. More...

Access: Fix Function

In Access, the Fix function returns the integer portion of a number. More...

Tags: ACCESS FUNCTION FIX INTEGER NUMBER Hits: 15042 Comments: 0

SQL Data Types

The following is a list of general SQL datatypes that may not be supported by all relational databases. More...

Tags: SQL DATA TYPES SUPPORTED RELATIONAL DATABASE Hits: 14682 Comments: 3

Access: RTrim Function

In Access, the RTrim function returns a copy of a string with trailing spaces removed. More...

Tags: ACCESS FUNCTION RTRIM TRAILING SPACE REMOVE Hits: 14590 Comments: 0

Access: Min function

In Access, the Min function returns the minimum of a set of values contained in a select query. More...

Tags: ACCESS FUNCTION MIN MINIMUM SELECT QUERY Hits: 14525 Comments: 0

Access: Exp Function

In Access, the Exp function returns a double specifying e raised to the nth power. The constant e is approximately 2.718282. More...

Tags: ACCESS FUNCTION EXP EXPONENT CONSTANT Hits: 14514 Comments: 0

Access: TimeValue Function

In Access, the TimeValue function returns the time represented by a string argument. More...

Tags: ACCESS FUNCTION TIMEVALUE REPRESENTATION TIME Hits: 14368 Comments: 1

Record locking in Web applications

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem. More...

Tags: PHP RECORD LOCKING WEB APPLICATIONS Hits: 14155 Comments: 0

Javascript: The First Script

JavaScript is a simple to comprehend and easy to use scripting language. When used in conjunction with a Web browser's Document Object Model (DOM), it can produce powerful dynamic HTML browser-based applications. In this tutorial we will print the text in a web page as well as the time and date on your computer. More...

Access: WeekdayName Function

In Access, the WeekdayName function returns the name of the day of the week corresponding to the date and the first day of the week provided as arguments. More...

Tags: ACCESS FUNCTION WEEKDAYNAME NAME DAY WEEK DATE Hits: 13837 Comments: 0

Access: UCase Function

In Access, the UCase function returns a string in which all letters of an argument have been converted to uppercase. More...

Tags: ACCESS FUNCTION UCASE UPPERCASE Hits: 13835 Comments: 0

ASP File Object

The File object represents a specified file on the local machine or on a network share. To work with the File object's properties and methods, you need to create an instance of the FileSystemObject object first and then instantiate the File object through the GetFile method. Also you can get a File object reference from the Folder object, by using the Files Collection. More...

Tags: ASP FILE SCRIPTING OBJECTS FILESYSTEMOBJECT FOLDER REFERENCE Hits: 13628 Comments: 0

ASP Folder Object

The folder object represents a specified file folder on the current machine. We can use the properties and methods of the Folder object to traverse directories on the drive, and to get at all the properties of this or any other folder. To work with the Folder object's properties and methods, you need to create an instance of the FileSystemObject object first and then instantiate the Folder object through the GetFolder method. Also you can get a Folder object reference from the Drive object, by using the RootFolder property. More...

SQL: DELETE Statement

The Delete statement allows you to delete a single record or multiple records from a table. More...

Tags: SQL DE;ETE QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 12728 Comments: 0

What is Javascript?

JavaScript is a cross-platform, object-oriented scripting language invented in web browsers to make web pages more dynamic and give feedback to your user. Adding JavaScript to your HTML code allows you to change completely the document appearance, from changing text, to changing colors, or changing the options available in a drop-down list, or switching one image with another when you roll your mouse over it and much more. More...

SQL: ALTER TABLE

Many times your design may have not accounted for everything it should have. Also, requirements for applications and databases in particular are always subject to change. The ALTER TABLE statement allows to change the structure of a table after it has been created. More...

Tags: SQL ALTER TABLE STRUCTURE ADD DELETE MODIFY Hits: 12396 Comments: 0

Access: CurDir function

In Access, the CurDir function returns a string containing the full path of the specified drive. More...

Tags: ACCESS FUNCTION CURDIR PATH DRIVE Hits: 12280 Comments: 0

SQL: WHERE Clause

The Where clause is used to specify that only certain rows of the table are displayed, based on the criteria described in that Where clause. More...

Tags: SQL WHERE QUERY CRITERIA SELECTIVELY RETRIEVE Hits: 12204 Comments: 1

Access: Space Function

In Access, the Space function returns a string consisting of the specified number of spaces. More...

Tags: ACCESS FUNCTION SPACE QUANTITY Hits: 12018 Comments: 0

Access: LCase Function

In Access, the LCase function returns a Variant in which all letters of an argument have been converted to lowercase. More...

Tags: ACCESS FUNCTION LCASE LOWERCASE VARIANT CONVERT Hits: 11507 Comments: 0

HTML ASCII Reference

HTML and XHTML uses standard 7-BIT ASCII when transmitting data over the Web. 7-BIT ASCII represents 128 different character values (0-127). More...

Tags: HTML XHTML ASCII REFERENCE 7-BIT Hits: 11486 Comments: 0

Access: Hour Function

In Access, the Hour function returns a number between 0 and 23, inclusive, that represents the hour of the day corresponding to the time provided as an argument. More...

Tags: ACCESS FUNCTION HOUR RANGE TIME Hits: 11448 Comments: 0

Access: TimeSerial Function

In Access, the TimeSerial function returns the time for a specific hour, minute, and second. More...

Tags: ACCESS FUNCTION TIMESERIAL TIME SPECIFIC MINUTE SECOND Hits: 11256 Comments: 0

SQL: AND/OR conditions

The scope of the Where clause and the operators used with it can be extended by using the logical operators AND and OR. More...

Tags: SQL AND OR CONDITION LOGICAL OPERATORS SEARCH QUERY Hits: 11116 Comments: 0

Access: FileDateTime Function

In Access, the FileDateTime function returns the date and time when a file was created or last modified. More...

Tags: ACCESS FUNCTION FILEDATETIME FILE DATE TIME CREATE MODIFY Hits: 11099 Comments: 0

Access: Atn Function

In Access, the Atn function returns a double containing the arctangent of a number. More...

Tags: ACCESS FUNCTION ATN ARCTANGENT Hits: 10694 Comments: 0

Access: Log Function

In Access, the Log function returns the natural logarithm of a number. The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282. More...

Tags: ACCESS FUNCTION LOG LOGARITHM NATURAL EXPONENT CONSTANT Hits: 9862 Comments: 0

What can ASP do for you?

List with some of possibilities that ASP provides you with. More...

Access: Sqr Function

In Access, the Sqr function returns the square root of a number. More...

Tags: ACCESS FUNCTION SQR SQUARE ROOT Hits: 9203 Comments: 0

ASP ASPError Object

The ASPError object is a new in ASP 3.0, and is available in IIS5 and later. It provides a range of detailed information about the last error that occurred in script in an ASP page. The ASPError object is only available through the GetLastError method of the Server object. In this tutorial the syntax and properties of the ASPError object are described. More...

Access: Sgn Function

In Access, the Sgn function returns a variant indicating the sign of a number. More...

Tags: ACCESS FUNCTION SGN VARIANT INDICATE SIGN Hits: 8505 Comments: 0

Access: Second Function

In Access, the Second function returns a number between 0 and 59, inclusive, representing the second of the minute of the hour. More...

HTML Entities

The list of HTML Entities More...

Tags: HTML ENTITIES REFERENCE Hits: 7875 Comments: 0

Access: Minute Function

In Access, the Minute function returns an Integer specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. More...

Tags: ACCESS FUNCTION MINUTE RANGE REPRESENTATION Hits: 7792 Comments: 0

Access: Cos Function

In Access, the Cos function returns a double containing the cosine of an angle. More...

Tags: ACCESS FUNCTION COS COSINE ANGLE Hits: 7552 Comments: 0

ASP Drive Object

The Drive object represents a physical drive. This drive can exist on your machine, or it can be a drive shared by another machine. To work with the Drive object's properties, you need to create an instance of the FileSystemObject object first and then instantiate the Drive object through the GetDrive method or the Drives property of the FileSystemObject object. More...

Access: Tan Function

In Access, the Tan function returns the tangent of an angle. More...

Tags: ACCESS FUNCTION TAN TANGENT ANGLE Hits: 6166 Comments: 0

Access: Sin Function

In Access, the Sin function returns the sine of an angle. More...

Tags: ACCESS FUNCTION SIN SINE ANGLE Hits: 6152 Comments: 0

How to determine MySQL version from the command line

How to determine MySQL version from the command line or from MySQL prompt. Quick and useful trick. More...

Tags: MYSQL Hits: 347 Comments: 0

How to transfer SQL Server logins between instances

Learn how to transfer logins and passwords between instances and between different versions of SQL Server. More...

Tags: SQL SERVER, MANAGEMENT STUDIO Hits: 174 Comments: 0

Fix: Insufficient access rights error when doing backup

All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location: "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)" More...

Tags: SQL-SERVER,SQL,BACKUP,PLESK Hits: 159 Comments: 0

Cannot load from mysql.proc. The table is probably corrupted

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat: "Cannot load from mysql.proc. The table is probably corrupted". Luckily there is an easy fix. More...

Tags: SQL,MYSQL,UPGRADE Hits: 139 Comments: 0







Copyright © 2005-2019             www.WebCheatSheet.com All Rights Reserved.