Pignatelli.com - programming and social media marketing

Requirements: No requirements

I decided to write this tutorial, divided into several classes, for the understanding of SQL, as by his instructions in a few steps we can issue commands that would otherwise need to perhaps tens of lines of code, not counting the number of variables use. Furthermore, the code we're going to write the script will be much more compact and readable by anyone. Continue reading ...

Requirements: no requirements

In this lecture we will present the SQL data types and provide a list of language keywords.

Data Types

There are three main types of data:

• Numbers;
• Characters;
• Time;

The first category those represented by integers or floating point.
In the second category, we can enclose individual characters or strings.
In the latter case, enclose the dates, times and intervals.

Continue reading ...

Requirements:

• Server with IIS (Internet Information Services) or PWS (Personal Web Server), installed;
• File creation. Mdb (Access format) to put messages created by the visitors;

First we create the file that will contain the guestbook.mdb Access database. We create a table named guestbook with the following fields:

• ID: AutoNumber field, unique;
• Name: Text field containing the visitor's name, 255 characters long;
• Date: Date type field;
• Time: Time type field;
• Text: Memo field;
• Email: field of type text, 50 characters long.

In this tutorial you will insert the code also for paging of results, that you will see a number of records at a time, but you can also skip if you do not want to use.

The first few lines of ASP code to insert in the view page of existing records, which I will call index.asp, are as follows:

Continue reading ...