Home | SourceForge | Documentation | FAQ | What's New | To-Do List | Forums | Download | Contact

sqlaction Tag

Attribute List:

This tag just indicates where the "action buttons" should go. There can be only one sqlaction button of each type in a template.

Type of tag: Self-closing



Required: Yes
Values: See below

Indicates which type of button this tag should represent.
add = the "Add New Entry" button, for "add" templates only.
edit = the "Update" button for "edit" templates.
delete = the "Delete" button for "edit" templates.
previous = if there are previous values to the data the user is viewing, the user can click this to view them. Ignored in "add" templates.
next = ditto for if there are further values.
search = the Search button, assuming you have at least one sqlfield with isSearch being true.
reset = Resets the template to start again at page 0 with no searches set.
action = This will be treated as edit for edit templates, and add for add templates. Useful when repeating an sqlrow for two separate templates; see Referencing Tags.
csv = Save the current view as a CSV file.
csv-all: Save the entire dataset as a CSV file (ignoring limit and current page, but keeping search and sort information).

Note: For edit templates, there are really two ways of going about things. You can put one or both action buttons inside the sqlrow tag; this will cause them to be displayed for each row, and therefore each row will be a separate form. On the other hand, you can place the edit button outside the sqlrow tag, which will allow the user to edit all fields at once. Mixing and matching these two types is a bad idea and won't work. If there's an edit button outside the sqlrow tag, all other edit and delete buttons will be ignored.


Required: No
Values: URL of an image

The given image will be displayed rather than a button.


Required: No
Values: CSS style

Works like any other style attribute.


Required: No
Values: CSS class

Works like any other class attribute.


Required: No
Values: Any string

Changes the text display of the button.


Required: No
Values: Any URL

This will redirect the user to the given URL after the action is taken. URLs can be relative or absolute. Note that you cannot use Ajax functionality for this sqlaction button if onAction is defined.