This example shows the use of the
GlobalSeparators property. The ViewFieldFormat
property has been redefined so that the primary separator becomes
the ' #' character instead of the ' ;' character.
Please, note that this way you can also use semicolons in your formattings, and
so you are free to add Javascript to your Grid and Form cells!
|
1 |
Chai
|
10 boxes x 20 bags;
|
18
|
|
2 |
Chang
|
24 - 12 oz bottles;
|
19
|
|
3 |
Aniseed Syrup
|
12 - 550 ml bottles;
|
10
|
|
4 |
Chef Anton's Cajun Seasoning
|
48 - 6 oz jars;
|
22
|
|
5 |
Chef Anton's Gumbo Mix
|
36 boxes;
|
21.35
|
|
|
|
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb
objVbsDb( "MdbPath" ) = "data/nwind.mdb"
objVbsDb( "Sql" ) = "select ProductName,QuantityPerUnit,UnitPrice from Products"
objVbsDb( "GlobalSeparators" ) = "ViewFieldFormats # |"
objVbsDb( "ViewFieldFormats" ) = "ProductName|<font color=green>{{ProductName}}</font>#" & _
"QuantityPerUnit|{{QuantityPerUnit}}<font color=red>;</font>"
VbsDb objVbsDb
%>
This demonstrative program connects to
Nwind.mdb, the well known Microsoft Access sample database: the names of companies,
products, people,
characters, and/or data mentioned herein are fictious and are in no way
intended to represent any real individual, company, product, or event.
To download a copy of Nwind.mdb, please visit
Microsoft's site.
| 