Planetary Data Systems

Business Internet Services

Main Menu

Home

Planetary CRM
  Benefits
  Features
  Demo

E-Mail Services
  E-mail Hosting
  Newsletters
  Discussion Lists

Web Hosting

Server Co-location
and Administration

Web Applications

Technical Support

DXP Samples

DxpHome || Samples || Details || Docs || Trees || xml-xsl || Links

Here is a set of records from a database query

No.	Username	Beverage	Cost
1	Mark	Beer	3.50
2	Mark	Latte	2.50
3	Mark	Water	0.00

We can strip off a row: Mark, Beer, 3.50
Or a col: Beer, Latte, Water

We can use a RecordSet tag to create a local set

No.	Username	Beverage	Cost
1	Bill	Coffee	1.50
2	John	Tea	1.25

Both sets have the same number of cols so we can use a StringMatrix tag to merge them by row.

No.	Username	Beverage	Cost
1	Mark	Beer	3.50
2	Mark	Latte	2.50
3	Mark	Water	0.00
4	Bill	Coffee	1.50
5	John	Tea	1.25

Or add a single row with values supplied by an ArrayParameter

No.	Username	Beverage	Cost
1	Mark	Beer	3.50
2	Mark	Latte	2.50
3	Mark	Water	0.00
4	Bill	Coffee	1.50
5	John	Tea	1.25
6	Mary	Coke	0.75

Or add cols with values supplied by ArrayParmater or single Parameter tags.
These will be repeated if there are not enough to fill all the rows.

No.	Username	Beverage	Cost	Array	Const
1	Mark	Beer	3.50	A	ID
2	Mark	Latte	2.50	B	ID
3	Mark	Water	0.00	A	ID
4	Bill	Coffee	1.50	B	ID
5	John	Tea	1.25	A	ID
6	Mary	Coke	0.75	B	ID

Source