SQLPage documentation
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.
components
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.
Top-level parameters
center
Whether to center the title.
html
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.
title
Text header before the paragraph.
width
How wide the paragraph should be, in characters.
Row-level parameters
contents
REQUIRED. A span of text to display
bold
Whether the span of text should be displayed as bold.
break
Indicates that the current span of text starts a new paragraph.
code
Use a monospace font. Useful to display the text as code.
color
The name of a color for this span of text.
italics
Whether the span of text should be displayed as italics.
link
An URL to which the user should be taken when they click on this span of text.
size
A number between 1 and 6 indicating the font size.
underline
Whether the span of text should be underlined.
Example 1
Rendering a simple text paragraph.
SELECT
'text' as component,
'Hello, world ! <3' as contents;
Result
Hello, world ! <3
Example 2
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;
Result
About SQL
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.