SQLEdit Field properties.

In this tab you can set various properties of the fields.

Label
This item set the label field value to a different value from database column name. Can be obtain in the template by field.label variable

Type
It determines the element type of the form to show.

Status
It sets up the way in which the user can interact with the field.

Identity
Field is an auto-incremental element and so, it will be showed in read-only mode when admin is off.

Hidden
Field will be hidden when admin is off.

Visible
Field will be showed in read-only mode

Editable
Field will be showed in normal mode and user can edit its value

Required
Field is required and use can not leave it empty.

Default
This configures the default field value when user tries to add a new record. You can use WebGUI macros to configure this field. As an example, if this parameter is set to ^User(userId); this field will be initialized with the userId of the user that are adding a new record.

Possible values
It configures possible values for field. Possible values must be added one for row. If row have a string, this is used as key and as values for field. If row is an associative item the first item will be used as key (this will be saved in database), the second item will be used as value (this will be showed to user). It's possible to use WebGUI macros but it's important that macro will return a value for row as "key1 => value1\n" or "key1\n". As an example, you can use ^SQL("select * from users","^0; => ^1;\n"); to show a list of current WebGUI users.

Possible values will be showed
It determines in which ordering the list of the possible parameters will be visualized.

Null value
This parameter determines what value SQLEdit must interpreter as NULL database value. This parameter is meaningless if database field is not nullable.

Template
Select a template for your field. This parameter is meaningless if the global template of SQLEdit element don't use the <TMPL_VAR name="form.fields.template"> but the <TMPL_LOOP name="fields_loop"> loop to render form fields.

JavaScript Menu Courtesy of Milonic.com




	Site Utility



	Printer version Leggilo in italiano Site stats Read forums Site map




	Resources



	Download SQLEdit Download SQLEdit beta How to install ChangeLog




	Documentation



	Add/Edit Template Template for fields Field properties Field check Database operation Upload type Template usage Master-detail tables Events usage




	Ads by Google




	Chat with me



	My nickname is emi but now I am offline. However you can usually find me on these channels of the Azzurra networks: areanetworking, telug, controguerra, webgui, geeks, pescaralug




	Internal related links



	WebGUI BlobViewer Wobject Allow to insert in your web pages and, however, to download, binary or textual data stored in database columns of BLOB type. These data can be of whatever type such as images, pdf documents, autocad files, etcetera. WebGUI SQLExt Macro A WebGUI Macro to execute SQL statements. As regard to WebGUI standard macro, it allows to execute query to external database and to execute DELETE, UPDATE and INSERT statements. WebGUI GDWGraph Wobject A WebGUI Wobject to create graphs from external sources. Support for lines chart, point chart, area chart, bar chart, 3D bar chart and 3D lines chart WebGUI DateTime patch Rewriting of the standard module WebGUI::DateTime that solves the fact that, in all WebGUI versions,is not possible to enter date before 01/01/1970 WebGUI, a C.M.S. for everybody. The ideal solution to realize and update web contents in a collaborative environment or anyhow from whom is 'not assigned to the jobs' requires the use of a content management system. Of these environments we'll analyze the salient characteristics for dealing therefore the main installation and property of one of theirs: WebGUI.




	External related links



	WebGUI Home page A versatile content managment system (C.M.S.) to simply build dynamical web site. Written in Perl, it generates dynamical content from templates using the HTML::Template module. It represents a simple framework to give also to who knows nothing about HTML.




	Credits



	Mason All this website has built using Mason. Without this language derived from Perl, most of the tools used for the manage of this site would never been developed. JavaScript Menu The great menu at the top of this page.

Comments


Copyright© 1997-2006 Emiliano Bruni	Online from 16/08/1998 with visitors	Write me to:


Name	E-mail	URI