Databases Reference
In-Depth Information
Then we add a
TEXT
field,
keywords
, to our
books
table and fill in the
MIME-related information, entering
'0','-r'
as the transformation options:
The
'0'
here refers to the index number for
sort
, and the
'-r'
is a parameter for
sort
,
which makes the program sort in reverse order.
Next we
Edit
the row for the topic
A hundred years of cinema (volume 1)
, entering some
keywords in no particular order and hitting
Go
to save:
To test the effects of the external program, we browse our table and see the sorted
in-cell keywords:
Indeed, the keywords are displayed in reverse sorted order in this cell.
Summary
In this chapter, we saw how we can improve the browsing experience by
transforming data using various methods. We can see thumbnail and full-size images
of
.jpeg
and
.png
BLOB
fields, generate links, format dates, display only parts of
texts, and execute external programs to reformat each cell's contents.
Search WWH ::
Custom Search