Databases Reference
In-Depth Information
Figure 12-22.
Section with SQL tags
When using SQL tags, you need to explicitly define whether the query will return a single value or multiple rows
and columns. A SQL tag defined as
sqlvalue:
means a single value will be returned and be embedded within a
sentence such that the single value appears as a word in the sentence. Using
sql:
means multiple rows and columns
will be returned. When a query returns multiple rows, its results are displayed in the spreadsheet-like format you see
in Figure
12-22
.
The search box in Figure
12-22
is a result of the second query returning multiple rows. Whenever a query's results
are displayed as a spreadsheet-like grid, that grid is preceded by a search box that you can use to quickly find specific
result rows.
Access Controls
The last thing you need to do for the application is give the other players on the team access to it. You already gave
access to Martin when you created the application. You need to give the other players, Chris and Cameron, access to
view the application. To grant access to the application, follow these steps:
1.
Click the
Administration
tab at the top of the screen.
2.
Click the
Access Control
option in the drop-down menu.
3.
Click the
Create Entry
button.
4.
Enter Chris for
Username
, and select
Reader
for
Privilege
. Click the
Create and Create
Another
button.
Enter
Cameron
for
Username
, and select
Reader
for
Privilege
. Click
Create
.
5.
Now Chris and Cameron can log in to the application. They can't modify any of the sections or data grids. If you
need to give someone access to modify the application, you can grant them the Contributor role in the Access Control
section.
Summary
The last two chapters introduced websheets and what they can do. From here, you can go on to make complex
websheet applications without having to know much about databases or SQL. Now that you have a base knowledge of
websheets, installing and analyzing the websheet sample application would be a good next step to understanding the
capabilities of a websheet.
