The dynamic image feature in MX Kollection 3 allows you to show images from your database the same way you would show data. Normally, the field would just list the image filename as text, but this InterAKT feature will recognize the file as an image and display it accordingly
(dynamic) thumbnail
A thumbnail is an image that is resized several times smaller in order to fit many images onto one page. The tiny thumbnail picture usually serves as a link to the full-size image. MX Kollection 3 contains a dynamic thumbnail feature where the original image is taken from the database, and automatically resized to a thumbnail version
A means of verifying that the account is real, by sending an e-mail with an activation link.
ADODB (PHP_ADODB)
ADOdb is a database abstraction library for PHP, allowing access through a standard set of functions to several types of databases
AFTER trigger
An AFTER trigger is a specific type of trigger which is executed after a database transaction. Common uses of AFTER triggers are to propagate values to fields other than those involved directly in the transaction, or to accomplish tasks such as sending a confirmation e-mail message.
A BEFORE trigger is a type of trigger executed before a transaction occurs. For example, a before trigger can be used to back up data contained in a table before a particular batch of statements is executed. Use a trigger before an INSERT, UPDATE, or DELETE statement to check for certain conditions before performing the corresponding transaction, or to change the input values before they are stored in the table.
A character encoding is a code that pairs a set of natural language characters (such as an alphabet or syllabary) with a set of something else, such as numbers or electrical pulses. A common example is ASCII, which encodes letters, numerals, and other symbols as both integers, and 7-bit binary versions of those integers
CMS (Content Management System)
A system used to organize and facilitate collaborative digital content creation. Recently, the term has been associated with programs for managing the content of web sites
conditional region
A conditional region is a page section that is displayed or hidden depending on the evaluation of a condition. For instance, certain information can be displayed only when the user is logged in to the website.
CSS (Cascading Style Sheets)
Cascading style sheets allow you to control the layout of a document and easily maintain many pages at once.
A database refers to data organized and stored on a computer that can be searched and retrieved by a computer program. Most industrial-strength and many smaller database applications can be addressed using SQL (Structured Query Language).
database table
A table is a data grid used to store similar information. It is made up of columns (also known as fields), which represent entity attributes, or pieces of data, and rows, which represent individual records. All records in a table share the same fields.
detail record
A database row from the detail table. The detail table is defined by a many-to-one relation to another table (the master table)
dispatcher
A dispatcher is a component of the Transaction Engine which contains all the transactions on a page and handles all interactions between that page and the transactions: executes the transactions, feeds the recordsets generated by the transactions to the page, displays the transaction's error messages, etc.
dynamic data
The InterAKT Dynamic Data tool is a replacement for the standard dynamic data dialog. It is used in the MX Kollection 3, to provide a unified way of building mark-ups, or place holders. These are recordset fields, server or session variables, and other types of dynamic data that are replaced at runtime by their corresponding values
Encryption is the transformation of data into a form unreadable by without a secret decryption key. Its purpose is to ensure privacy by keeping the information hidden from anyone for whom it was not intended, including those who can see the encrypted data
END trigger
An END trigger is always the last action to be performed after executing a transaction. Use an END trigger to redirect the user to another page after performing an insert or an update transaction, for instance.
ERROR trigger
An ERROR trigger defines the steps to take when an error occurs during a transaction. For example, if the user tries to insert a duplicate record in the database, the transaction will fail and the ERROR trigger will display an error message on the screen.
A foreign key is a field from a database table that refers to (or targets) a specific key, usually the primary key, in another table. This is a convenient way of logically linking information from related tables in the same database. For instance, a table that stores information about products can contain a foreign key that references the primary key field in a table that stores manufacturers. This way, each product has an associated manufacturer – its associated foreign key points to the unique identifier of the manufacturer. Please note that the foreign key is not unique, but the referenced field (the primary key in the referenced table) usually is.
forgot password
Forgot Password is a feature in MX Kollection 3 which lets users obtain either their current password or a new password by email if they have forgotten their's
An image library is a component of your server model language (PHP, ASP, ColdFusion) which contains functions for manipulating images in a variety of formats. Some MX Kollection 3 server behaviors use these libraries to generate and process dynamic images and thumbnails. Examples include the GD library for PHP or ImageMagick for ColdFusion. For a complete list of required image libraries, see \"What's New in MX Kollection 3 > Improved compatibility\".
inner join
The INNER JOIN returns all the rows from two related tables where there is a match in a common field.
The JOIN is a SQL command used to retrieve data from 2 or more database tables with existing relationship based on a common attribute.
The LEFT JOIN returns all the rows from the first table (Departments), even if there are no matches in the second table (Employees). If there are no rows in Departmentss that do not have matches in Employees, those rows also will be listed
A database row from the master table. The master table is defined by a one-to-many relation to another table (the detail table)
meta description
The meta description tag includes a concise yet eloquent summary of a site page. When looking for the page on the web, its description will be displayed in the results list of the search engine.
meta keywords
The meta keywords tag includes the list of words and phrases (two or more words) that represent the best the content of a site page. List them in order of importance. The search engines that support this tag (not all do) index the tag and rank the respective site.
multiple delete
A multiple delete transaction is a database operation which removes several records from the same database. It can be viewed as a sequence of several standard delete operations. If one or more of the simple delete transactions fails for whatever reason, the rest of the simple deletes which were executed successfully will not be rolled-back.
multiple insert
A multiple insert is a database operation which adds several records to the same database table. A multiple insert can be regarded as a sequence of consecutive standard insert transactions. If one or more of the simple insert transactions fail for whatever reason, the rest of the simple inserts which were executed successfully will not be rolled-back.
multiple update
A multiple update transaction is a database operation where information can be modified in several records of the same table. A multiple update can be regarded as a sequence of consecutive standard update transactions. If one or more of the simple update transactions fail for whatever reason, the rest of the simple updates which were executed successfully will not be rolled-back.
In web development, a nugget is a small portion of an interface or web page that provides additional information or functionality, but can also be used separately, as a stand-alone page. Nugget is synonim to block or module. The same nugget can also be included on several pages, using Server-Side Includes (see Sever-Side Includes for details).
Is a computer programming paradigm in which a software system is modeled as a set of objects that interact with each other
PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP 5 is the latest version to be released
primary key
A primary key is one or more table columns whose values uniquely identify each record in a table. In general, a primary key is defined on a single column, but it is not uncommon to have it defined on two columns.
A query is a SQL command that will extract information from the tables of a database. Essentially, a query is a request for information from your database.
A random key is a randomly generated set of characters (alphanumeric) used for improving website security. It is commonly used in user account activation, online purchases, or other activities that use URL's which must be difficult to guess. This prevents potentially malvolent users to access the URL's by directly entering them in the browser window, in order to activate accounts for other users. for instance.
recordset
A recordset is the result of executing an SQL query. It is composed of multiple rows, each row having multiple columns. The columns presented in the query result depend on the column list declared in the query (they can belong to different tables). The number of rows and their order depend on the query conditions (WHERE, GROUP BY, HAVING, ORDER). The recordset acts as a source of dynamic data in web applications.
redirect
The redirect server behavior loads a new site page after a transaction is executed. For instance, users could be automatically redirected to their inbox after they log in to the website.
RegExp
See \"regular expression\".
regular expression
A regular expression (RegExp, for short) is a formula for matching strings that follow some pattern. You can think of regular expressions as wildcard characters that enforce a validation pattern. Regular expressions have a special syntax. To learn more about defining a regular expression, visit http://sitescooper.org/tao_regexps.html.
relation
In a database, tables are usually linked together in a logical way. A link between two tables is called a \"relation\". A relation always involves two tables ad two columns from them (one can create a relation between a table and itself for representing a tree like structure)
remember me
The \"remember me\" feature allows users to automatically log in to a web site by using the user login information stored in a cookie on the local computer.
repeat region
A repeat region lets you display multiple records from a recordset within a page. Any dynamic data selection can be turned into a repeat region. However, the most common regions are a table, table row, or a series of table rows.
right join
The RIGHT JOIN returns all the rows from the second table (Employees), even if there are no matches in the first table (Departments). If there had been any rows in Employees that did not have matches in Departments, those rows also would have been listed
roll-back
A roll-back is a SQL command which cancels the proposed changes in a pending database transaction and marks the end of the transaction.
A server behavior is a reusable component for server-side development. They add blocks of code to your pages for accomplishing specific tasks. Dreamweaver comes with several default server behaviors and the InterAKT extensions add many more to this list.
server model
The server model is the Dreamweaver term for your combination of the scripting language and/ or database software used for development on your server, for instance PHP_MySQL, ASP.NET, ASP VBScript, ColdFusion, etc. InterAKT extensions generate server side code. Therefore, setting the correct server model in your site definition is important so that extensions generate the proper code for your development framework.
session
A session is a way to preserve certain data across subsequent accesses of the same web application. The session object contains many variables to store user information on the web server in a location that you choose in special files. The session support allows you to register arbitrary numbers of variables to be preserved across requests. Sessions are specific to individual users. As a result, every user has a separate session and has access to a separate set of Session variables.
session variable
Session variables are pieces of information stored in the session (see session). Session variables make that information available to all of the application's pages for the duration of the user's visit. For instance, the username can be stored as a session variable.
skin
In web development, skins are custom graphical appearances that can be applied to certain websites in order to suit the different tastes of different users. Such websites are referred to as being skinnable, and the process of writing or applying such a skin is known as skinning. Applying a skin changes a website's look and feel - some skins merely make the website more aesthetically pleasing, but others can rearrange elements of the interface.
STARTER trigger
A STARTER trigger defines when a transaction is executed. For example, in a web form, the user clicking the Submit button could call a STARTER trigger which passes parameters allowing the transaction to take place.
style sheet
Style sheets describe how documents are presented on screens, in print, or perhaps how they are pronounced. By attaching style sheets to structured documents on the Web (eg. HTML), authors and readers can influence the presentation of documents without sacrificing device-independence or adding new HTML tags. (W3C)
A time value, expressed in milliseconds, typically since the last server reset. Timestamp values wrap around (after about 49.7 days). The server, given its current time is represented by timestamp T, always interprets timestamps from clients by treating half of the timestamp space as being earlier in time than T, and half of the timestamp space as being later in time than T. One timestamp value, represented by the constant CurrentTime is never generated by the server. This value is reserved for use in requests to represent the current server time.
transaction
A transaction is a group of SQL statements whose effects are logically connected. Anything from simple queries to inserting, and deleting operations can be considered a transaction, as well as more complex groups of several statements which accomplish a specific task.
Translator
A translator is the visual representation of a code block in Dreamweaver. It is not visible, nor generated in the page viewed in a browser. It is visible only in Dreamweaver, to provide a better view on the page under development.
trigger
A trigger is a SQL procedure that performs an action when a transaction (INSERT, UPDATE, DELETE) occurs. You can use triggers to perform validation of input data, to automatically generate a value for a newly inserted row, to read from other tables for cross-referencing purposes, or to support alerts through e-mail messages.
trigger priority
The trigger priority is a setting that sets the order amongst all the triggers associated to a transaction. In many cases, the sequence in which triggers are executed is important. For instance, an AFTER trigger that sends an e-mail must always be executed after a BEFORE trigger that validates data entered by users in some form. A larger trigger priority (say, 90) means the trigger will be executed later in the sequence, while a smaller priority (such as 18) means the trigger will be executed sooner.
A unique key is defined to have no two of its values the same. The columns of a unique key cannot contain null values. The constraint is enforced by the database manager during the execution of INSERT and UPDATE statements. A table can have multiple unique keys. Unique keys are optional and can be defined in CREATE TABLE or ALTER TABLE statements.
user authentication
The process of protecting a web site by requiring a user to enter an authorized ID and password before entering the site
WAI (Web Accessibility Initiative)
A program whose goal is to increase the availability of the Internet through technology, guidelines, tools, education and outreach, and research and development