50 recent changes in MasonSQL Web retrieved at 19:11 (GMT)

Autohandlers The autohandlers offer improved inherit mechanism. That means they might just as well be used as normal libraries. If we want to write a generalized ...

Adding Child Frame In this example we will display a table together with one linking table. We will also do some improvements of the input fields. On this page: ...

Access to PostgreSQL Database On this page: Setting Up pgAdmin With Tunneling It is convenient to use pgAdmin for the PostgreSQL database administration. After i...

Report Manager Use of Report Manager (Reportman in short) with MasonSQL is deprecated. Report Manager currently supports Wine version, Kylix version is deprecated...

Attention! Perlbrew deploy is necessary only on Ubutu 12.04! # Install Perlbrew apt get y update apt get y install perlbrew mkdir /opt/masonsql/perlbrew # Add P...

Mason Configuration File The MasonSQL configuration file path /opt/masonsql/etc/apache2.masonsql.conf must be included in the application config file: Eg. /opt/de...

MasonSQL Support Matrix SVN Release Operating System Server Apache Mason Perl Perlbrew Perl Dojo masonsql/tags/1.9.1 Ubuntu 12.04 LTS (Preci...

Report Component The report.pdf component receives a command line parameters that are passed on to the Reportman or to the ODT Report library which in turn gener...

ODT Reportman User's Guide In this guide it will be explained the usage of the ODT Report web form using an example report. In the example it will be described th...

ODT Reportman Library ODT Reportman library produces a MasonSQL reports using an .odt files as templates. The template files are created with the LibreOffice's ap...

Duplicating Application to New Server OS: Ubuntu 12.04 LTS (Precise Pangolin) in VPS (OpenVZ) In this example we will duplicate the https://gas devel.leader.it ...

DisplayBinding Class On this page: Subroutines Function Name Parameter Name Valid Input Value Description printSelected() Sets the dataBindin...

Report Methods The report methods are called when a browser makes a pdf query request (see Testing Queries). The query request is initiated with printSelected()...

Forms Methods Forms Some of these methods are related to methods in frame.html. Method Name Parameter Name Description Default Value FORM_TYPE T...

file.comp The file widget contains the base64 encoded content of a file. An upload window pops up in edit mode on mouse click on the widget. On double click the c...

Base Component The input.comp is a father of all available widgets. On this page: Input Class The input.js contains definition of a base class which is used by t...

Copy Paste features in MasonSQL TABLE form Preface In the MasonSQl form of type TABLE at the left, for each row, there is a flag used to select colums to delete ...

MasonSql porting to Apache 2.4 The current (2016) version of MasonSQL is compatible with Apache 2.0 and 2.2 with part of it compatible with very old version 1.3....

Auxiliary Methods Method Name Arguments Description Default Contents DELETE_IF_FIELD_EMPTY Contains a list of field names. Defines which fi...

number.comp The Number widget is used for input fields that should contain a numeric value. Additional restrictions on the numbers can be specified. Input Parame...

color.comp The color widget allows user to find a color. On this page: Parameters Parameter Name Description Default Value $value A color string whic...

Input Widgets The Input widgets are a JavaScript widgets that provide means to input or display different types of data into or from the internal database. A typ...

MasonSQL::Report Revision $Revision: $ Description MasonSQL implementation of reporting. Included Libraries and Subroutines Library or Function Name ...

image.comp The image widget displays the base64 encoded string as an image. An image upload window pops up in edit mode on mouse click inside the image frame. On ...

report.pdf Revision $Revision: $ Description A component for generating MasonSQL reports in PDF or ODT format. Arguments B B B $ba...

Query Methods and Subroutines There's a general convention to use the PRE, POST and POST_NO methods for handling fields in the tables and INSERT, UPDATE and DELET...

FIND Methods Method Name Parameter Name Description Default Value FIND The method displays a find bar for filtering the records. The method can p...

Report Subroutines DBMS Library subroutines related to reporting. Subroutine Name Parameter Name Valid Input Value Description Array2report_idSql() ...

Report Methods, Subroutines and Component Report Component report.pdf Component

Authorization Methods and Subroutines SQL injection check Queries generated by the GUI are controlled by the server. Subroutines Subroutine Name Parameter ...

button.comp The Button widget is a graphical control element that provides to user a simple way to trigger an event. On this page: Parameters Parameter Name ...

Message Forwarding The /opt/masonsql/bin/cronjobs file is forwarding authority for email messages and text messages in the queue.It reads the PerlSetVar variables...

codfisc_pi.comp This widget is used for personal fiscal and VAT identification codes used in Italy. Input Parameters: Parameters The widget checks the validity o...

timestamp.comp The Timestamp widget is combination of date and time widgets. It is used when it is required both date and time. The date and time must be specifie...

checkbox.comp The Checkbox is commonly used when more than one option may need to be selected. Checking the box enables that option and unchecking it disables it....

Permission.comp The Permission widget is used for allowing different types of authorizations to different groups of users for every function. Input Parameters: P...

FCKeditor.comp FCKEditor is a browser based WYSIWYG content editor. This means the content being edited is a genuine graphical representation of the published con...

url.comp The Url widget is used for opening URLs in a separate window or box area. Input Parameters: Parameters Parameter Name Description Default Value ...

time.comp The Time widget is used for setting the time. The time must be specified in HH:MM format. If the time is specified as value 01:02:33 the widget will d...

span.comp The Text Span widget is used for grouping elements in a document without being itself visually changed. It also provides a way to add a hook to a part o...

radio.comp The Radio Button widget allows the user to choose from one of a predefined set of options. Input Parameters: Parameters Parameter Name Description...

date.comp The Date widget is used for displaying or setting a date. Input Parameters: Parameters The date must be specified in DD/MM/YYYY format. Parameter Nam...

Application to export POD documentation from SVN/GIT to Foswiki portal Introduction Leader.IT uses a Foswiki Web portal to manage documentations, also this docum...

Mason Literature The Mason Book There is a great book about Mason, titled Embedding Perl in HTML with Mason, by Dave Rolsky and Ken Williams. The book's website ...

Report Manager Prints a report manager (.rep) file to a Adobe PDF file. Version: printreptopdf 2.9a Usage: printreptopdf Options stdin reportfilename outputfi...

GUI framework Examples with italian interface language. Gui Framework Difference Screenshot according to user role root user guest user ...

Configure backup system to preserve database integrity The backup system copy every file in the server, but database files during backup can change and final re...

Provider=MSDASQL.1;Persist Security Info=False;Mode=Read;Extended Properties="DRIVER={PostgreSQL Unicode};DATABASE=masonsql;SERVER=127.0.0.1;USER=report;PASSWORD=...

Handling Email and SMS Messages On this page: Messaging Procedure To send message the application must save the message information into the database with all of...

Using Number Widget The number widget is input number widget, it is used for input fields that should contain a numeric value. You can set restrictions on the nu...