50 recent changes in MasonSQL Web retrieved at 07:28 (GMT)

Statistics for MasonSQL Web Month: Topic views: Topic saves: File uploads: Most popular topic views: Top contributors for topic save and uploads:...

htmlselect.comp The HtmlSelect widget is an upgrade of the basic HTML select button. It is not buffered in contrast to the Select widget. Input Parameters: Html...

string.comp The String widget is used for input fields that contain a strings. The string length can be defined in the .mql file or preferably directly in the da...

Il framework MasonSQL dispone di un generatore di report nei formati ODT e PDF. I dati da includere nel report vengono estratti dal database mediante delle query....

The MasonSQL is a Mason based web application framework. In combination with the Linux platform, the Apache web server and Perl scripting language it forms a web ...

Creating Table With Empty SQL File In this chapter we will create an example demo application for a small bakery shop, to this purpose we need to create some kind...

divselect.comp The DivSelect widget is the most sophisticated of the three available select widgets. Its intended for showing more complex drop down lists. It has...

User Self Registration Management Self Registration Processing Initial Understanding Document * Initial Understanding Document Overview MasonSQL framewor...

Initial Understanding Document User Self Registration { border="1" cellpadding="2" Date Version Modified By Comments 09032016 Draft r.1.0 Main.Rajes...

Queste istruzioni per l'installazione sono state verificate su Ubuntu Precise (12.04) e Ubuntu Trusty (14.04) con il downgrade ad Apache 2.2 These instructions fo...

MasonSQL 1.6.3 Nel documento viene descritta l'interfaccia per lo scambio dei dati per le classiche operazioni di Creazione(Create), Lettura(Retrieve), Aggiorname...

Deploy Let's Encrypt SSL certificates With the non profit certificate authority Let's Encrypt, it is possible to get free https certificates. Certificates expire...

sudo su # Locale settings update locale LC_ALL=it_IT.UTF 8 LANG=it_IT.UTF 8 locale gen dpkg reconfigure tzdata # Update packages apt get update apt get upgrade ...

Import data from XLS tables and others formats (XLS, JSON, ...) Preliminary * Now the framework permit to export data, but not to import and the exported tabl...

global_autohandler GenericSelect_FIELD Method The drop down lists in the MasonSQL framework are implemented with select, htmlselect or divselect widgets, their i...

Il framework MasonSQL è dotato di un sistema di messaggistica per gli utenti con le seguenti modalità di inoltro: * visualizzazione dei messaggi nel portale we...

# apt get install cpanminus build essential Utilizzando mpm_event o mpm_worker abbiamo riscontrato degli errori nell'esecuzione e pertanto la configurazione con...

Upgrade from Ubuntu Xenial VPS to Bionic On this page: Upgrade O.S. * https://linuxconfig.org/how to upgrade to ubuntu 18 04 lts bionic beaver Upgrade Postgr...

Creata la VM con almeno 512M/RAM e 2Gbye di disco si procede con l'aggiornamento del sistema operativo e con l'installazione dei package. Create the VM with at le...

Installazione Macchina Virtuale Install Virtual Machine wget http://download.proxmox.com/appliances/system/ubuntu 12.04 standard_12.04 1_amd64.tar.gz Creata la V...

Upgrade from Ubuntu Precise VPS to Xenial # E' importante sapere qual'e' la versione presente lsb_release a # La risposta sara' di questo tipo: # # No LSB modul...

Ubuntu 18_04 LTS (Bionic) # apt get y install cpanminus build essential Utilizzando mpm_event o mpm_worker abbiamo riscontrato degli errori nell'esecuzione e ...

Common Parameters Parameters common to select.comp, htmlselect.comp and divselect.comp widgets: Parameter Name Description Default Value id Select Com...

FATHER, CHILD Methods The web page with a father and one or more children can be configured with a collection of methods: Method Name Desc...

XLS Methods Method Name Description Default Contents xls Is the method that is called when user presses the XLS button.Its default behavior can be cha...

MasonSQL Web Preferences The following settings are web preferences of the MasonSQL web. These preferences overwrite the site level preferences in . and ,...

Inheriting Table Properties In this chapter we will make the orders3.mql file which inherits properties from orders2.mql file. We will add the properties that we ...

* .MasonSQLGroup: *

Recoding optimizations 2018 ATTENTION: These changes (from svn version 534) are not compatible with older versions! Update Dojo Toolkit Update code to the most r...

Internal Database The MasonSQL component /opt/masonsql/htdocs/lib/dbms_library.comp makes SQL queries to internal PostgreSQL database 9.5 which conforms to SQL st...

INSERT, UPDATE, DELETE Method Name Arguments Description Default Contents INSERT Insert a new record.The metod is cal...

SELECT Method Name Arguments Description Default Contents Example Usage SELECT_FIELDS A list of fields to be inserted into table's select query....

Files.comp The Files widget enables users to attach files to records in a table. Input Parameters: Parameters Parameter Name Description Default Value ...

frame.html On this page: Input Parameters Input Parameter Description Default Value form Indicates which type of form will be di...

select.comp The Select widget is the simplest of the three available select widgets. The displayed selection is a result of the specified query. The selection is...

Session Management to manage user connection from many workstation and mobiles. Preface MasonSQL framework uses authentication based on Cookie. If the user open...

Testing MasonSQL Queries On this page: Running test_callRemote.html This test file /opt/masonsql/htdocs/test/test_callRemote.html is small enough to analyze it q...

_FIELD Methods As shown in the examples from previous chapters each field can also be uniquely configured. Here's the list of the FIELD methods: Method Name A...

Using Select and HtmlSelect Widgets We already have an example table with Commission ID and Employee ID fields pointing to their children tables which is not very...

Using DivSelect Widget On this page: Defining Children's Fields In this example we'll be adding the divselect widget to the employee field.The FIELDS_NOT_NULL co...

library.comp Subroutines The library component is the MasonSQL root component which initializes logging, includes most essential Perl modules and provides a coupl...

form.comp The Form widget provides possibility to use forms in a popup window. Input Parameters: Parameters Parameter Name Description Default Value id...

DisplayBinding Class On this page: Subroutines Function Name Parameter Name Valid Input Value Description printUrl() Joins the input argument...

Creating Table With Simple SQL File In this chapter we will make the orders2.mql file and fill it up with a few simple methods. We will also add the table in the ...

Managing Groups An authorization mechanism in the MasonSQL framework is implemented with groups. Its a concept similar to Unix file system authorization although ...

Universal Methods and Subroutines Method orSubroutine Name Parameter Name Valid Input Value orAttribute Value Description Default Value Find_Compone...

Query Subroutines Name Arguments Description Array2UpdateSql() The subroutine is used for updating or inserting records sent by GUI in an array for...

PRE, POST, POST_NO The hooks for these methods are available to be executed prior or after the INSERT, UPDATE or DELETE queries. The methods can generate a SQL co...

FIELDS Methods Some of the FIELDS methods were already encountered in previous chapters; Here's the complete list of the FIELDS methods: Method Name Descripti...

DBMS Library Component The dbms_library.comp provides database interface. Some of its methods are also used by frame.html. Its less complex methods are intended ...