The two most important concepts in SQLPage are components and parameters.This page documents all the components that you can use in SQLPage and their parameters. Use this as a reference when building your SQL application.
The "text" component
A paragraph of text. The entire component will render as a single paragraph, with each item being rendered as a span of text inside it, the styling of which can be customized using parameters.
Whether to center the title.
Raw html code to include on the page. Don't use that if you are not sure what you are doing, it may have security implications.
Text header before the paragraph.
How wide the paragraph should be, in characters.
REQUIRED. A span of text to display
Whether the span of text should be displayed as bold.
Indicates that the current span of text starts a new paragraph.
Use a monospace font. Useful to display the text as code.
The name of a color for this span of text.
Whether the span of text should be displayed as italics.
An URL to which the user should be taken when they click on this span of text.
A number between 1 and 6 indicating the font size.
Whether the span of text should be underlined.
Rendering a simple text paragraph.
SELECT 'text' as component, 'Hello, world ! <3' as contents;
Hello, world ! <3
Rendering a paragraph with links and styling.
SELECT 'text' as component, 'About SQL' as title; SELECT 'SQL' as contents, '1' as bold, '1' as italics; SELECT ' is a domain-specific language used in programming and designed for managing data held in a ' as contents; SELECT 'relational database management system' as contents, 'https://en.wikipedia.org/wiki/Relational_database' as link; SELECT '. It is particularly useful in handling structured data.' as contents;
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system. It is particularly useful in handling structured data.