transparent results from the CPAN

DBD-Chart

$sth->execute('Southwest', 4569.78);
$sth->execute('Northwest', 33456.78);

$rsth = $dbh->prepare(
"SELECT PIECHART FROM pie
 WHERE WIDTH=400 AND HEIGHT=400 AND
 TITLE = 'Sales By Region' AND
 COLOR IN ('red', 'green', 'blue', 'lyellow', 'lpurple') AND
 BACKGROUND='lgray' AND
 SIGNATURE='Copyright(C) 2001, GOWI Systems, Inc.'");
$rsth->execute;
$rsth->bind_col(1, \$buf);
$rsth->fetch;
</pre>
<img src="imgs/simppie.png" alt="Simple Pie Chart">
<p>
<a name="barchart"></a>
<h3>3-D Bar Chart</h3>
<pre>
#
# multi-range 3-D bar chart
#
$dbh->do('CREATE TABLE bars (quarter SMALLINT, East FLOAT, '.
'Southeast FLOAT, Midwest FLOAT, Southwest FLOAT, Northwest FLOAT)');
$sth = $dbh->prepare('INSERT INTO bars VALUES(?, ?, ?, ?, ?, ?)');
$sth->execute(1, -2756.34, 3456.78, 1234.56, -4569.78, 33456.78);
$sth->execute(2, 2756.34, 3456.78, 1234.56, 4569.78, 33456.78);
$sth->execute(3, 2756.34, 3456.78, -1234.56, 4569.78, 33456.78);
$sth->execute(4, 2756.34, -3456.78, 1234.56, 4569.78, 33456.78);

$rsth = $dbh->prepare(
"SELECT BARCHART FROM bars
WHERE WIDTH=600 AND HEIGHT=400 AND X_AXIS='Quarter' AND
Y_AXIS='Revenue' AND TITLE = 'Quarterly Revenue By Region' AND
THREE_D=1 AND SHOWVALUES=1 AND
COLORS IN ('red', 'green', 'blue', 'yellow', 'dbrown')");
$rsth->execute;
$rsth->bind_col(1, \$buf);
$rsth->fetch;
</pre>
<img src="imgs/multibar.png" alt="Bar Chart">
<p>
<a name="pointgraph"></a>
<h3>Point Graph</h3>
<pre>
#
# scatter graph
#
$dbh->do('CREATE CHART line (Month SMALLINT, sales FLOAT)');
$sth = $dbh->prepare('INSERT INTO line VALUES( ?, ?)');
$sth->execute(1, 2756.34);
$sth->execute(2, 3456.78);
        ...insert some more rows.....
$sth->execute(12, 90.57);

$rsth = $dbh->prepare(
"SELECT POINTGRAPH FROM line
WHERE WIDTH=500 AND HEIGHT=300 AND X_AXIS='Sales' AND
TITLE = 'Sales By Region' AND COLOR='black' AND SHOWGRID=0 AND
SHAPE='filldiamond' AND SHOWVALUES=1
AND BACKGROUND='transparent'");
$rsth->execute;
$rsth->bind_col(1, \$buf);
$rsth->fetch;
</pre>
<img src="imgs/simppts.png" alt="Scatter Graph">
<p>
<a name="linegraph"></a>
<h3>Multi-range Linegraph, with Logo and Signature</h3>
<pre>
#
# multi-range line w/ points, bkground image, and signature
#
$dbh->do('DROP CHART line');
$dbh->do('CREATE CHART line (Month SMALLINT, East FLOAT, ' .
'Southeast float, Midwest float, Southwest float, Northwest float)');
$sth = $dbh->prepare('INSERT INTO line VALUES( ?, ?, ?, ?, ?, ?)');
$sth->execute(1, 2756.34, 3456.90, 1234.99, 1005.34, 2876.34);
$sth->execute(2, 3456.78, undef, 4321.25, 9001.34, 997.68);
        ...insert some more rows.....
$sth->execute(12, 90.57,3456.90, 1234.99, undef, 2876.34);

$rsth = $dbh->prepare(
"SELECT LINEGRAPH FROM line
WHERE WIDTH=? AND HEIGHT=? AND X_AXIS=? AND Y_AXIS=? AND
TITLE = 'Monthly Sales By Region' AND
COLOR IN ('red', 'green', 'blue', 'yellow', 'lbrown') AND
SHOWPOINTS=1 AND SHOWGRID=1 AND
SHAPE IN ('fillcircle', 'fillsquare', 'filldiamond', 'horizcross',
    'diagcross') AND
LOGO='gowilogo.png' AND BACKGROUND='lgray' AND
X_ORIENT='VERTICAL' AND
SIGNATURE='Copyright(C) 2001, GOWI Systems, Inc.'");
$rsth->execute(400, 400, 'Month', 'Sales');
$rsth->bind_col(1, \$buf);
$rsth->fetch;
</pre>
<img src="imgs/multipt.png" alt="Multiline Graph">
<p>
<a name="areagraph"></a>
<h3>Multi-range Area Graph</h3>
<pre>
$dbh->do('CREATE CHART line (Month SMALLINT, East FLOAT, ' .
'Southeast float, Midwest float, Southwest float, Northwest float)');
$sth = $dbh->prepare('INSERT INTO line VALUES( ?, ?, ?, ?, ?, ?)');

@month = (1,2,3,4,5,6,7,8,9,10,11,12);
@east = ( 2756.34, 3456.90, 1234.99, 1005.34, 2876.34, 3456.78, undef,
	4321.25, 9001.34, 997.68, 1234.56, 7783.20);
@seast = ( 5321.11, 3333.33, 876.10, 4569.78, 4326.3,  -7895.44, 4444.44,
	12345.29, 3456.78, 12094.5, 6666.66, 3322.11);
@midwest = ( 9090.90, 908.57, -2367.4, 3399.55, 5555.55, 887.3, 756.34,
	1111.11, 2222.22, 8888.88, 9456.3, undef);
@swest = ( 7783.20, 5321.11, 3333.33, 876.10, 12349.56, 12094.5, 6666.66,
	3322.11, 9090.90, 4569.78, 3456.99, 4321.25);
@nwest = ( 9001.34, 997.68, 13456.78, 2367.4, 3399.55, 5555.55, 887.3,
	90.57, 3456.90, 1234.99, undef, 2876.34);

$sth->func(1, \@month, chart_bind_param_array);
$sth->func(2, \@east, chart_bind_param_array);
$sth->func(3, \@seast, chart_bind_param_array);

dbdchart.html view on Meta::CPAN

	determines whether the datapoint values are displayed.
	When set to 1, the (X,Y) values are displayed  using a 6pt font either just above
	the plotted datapoint for line, area, and point graphs;
	for candlesticks, the minimum and maximum Y values
	are plotted just above and below each candlestick. For barcharts and histograms,
	the Y axis value of each bar is displayed. For box & whisker charts,
	the median and lower and upper quartile	values are displayed. If set to a positive
	value greater than 1, the value is used to determine the size of the font.</td>
	<td valign=top>0</td>
	<td valign=top>No</td>
	<td valign=top>single value only, valid values are positive integers,
	ignored for pie charts and quadtrees.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>X_LOG</b><br>(<i>aka</i> <b>X-LOG</b>)</td>
	<td valign=top>for line, area, point, and candlestick graphs, causes values along the X axis to be plotted in log<sub>10</sub> form;</td>
	<td valign=top>0</td>
	<td valign=top>Yes</td>
	<td valign=top>All domain values must be &gt; 0 when X_LOG is enabled.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>Y_LOG</b><br>(<i>aka</i> <b>Y-LOG</b>)</td>
	<td valign=top>for barchart, line, area, point, and candlestick graphs, causes values along the Y axis to be plotted in log<sub>10</sub> form;</td>
	<td valign=top>0</td>
	<td valign=top>Yes</td>
	<td valign=top>All range values must be &gt; 0 when Y_LOG is enabled.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>X_AXIS</b><br>(<i>aka</i> <b>X-AXIS</b>)</td>
	<td valign=top>sets the label string on the X axis of line, area, point, and candlestick graphs.</td>
	<td valign=top>'X-Axis'</td>
	<td valign=top>Yes</td>
	<td valign=top>Single string value</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>Y_AXIS</b><br>(<i>aka</i> <b>Y-AXIS</b>)</td>
	<td valign=top>sets the label string on the Y axis.</td>
	<td valign=top>'Y-Axis'</td>
	<td valign=top>Yes</td>
	<td valign=top>Single string value; ignored for piecharts and box&whisker charts</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>Z_AXIS</b><br>(<i>aka</i> <b>Z-AXIS</b>)</td>
	<td valign=top>sets the label string on the Z axis. Also directs plotting engine to render
	true 3 axis barchart.</td>
	<td valign=top>'Z-Axis'</td>
	<td valign=top>Yes</td>
	<td valign=top>Single string value; valid for barcharts/histograms only, ignored for all others</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>TITLE</b></td>
	<td valign=top>sets the title string of the graph.</td>
	<td valign=top>None.</td>
	<td valign=top>Yes</td>
	<td>&nbsp;</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>THREE_D</b><br>(<i>aka</i> <b>3-D</b>)</td>
	<td valign=top>sets the 3-D effect on piecharts, barcharts, and histograms.</td>
	<td valign=top>0</td>
	<td valign=top>No</td>
	<td>&nbsp;</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>BACKGROUND</b></td>
	<td valign=top>sets the background color</td>
	<td valign=top>'white'</td>
	<td valign=top>Yes</td>
	<td valign=top>single string value only, from list of legal colors or <code>transparent</code>.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>TEXTCOLOR</b></td>
	<td valign=top>sets the color of text in the image.</td>
	<td valign=top>'black'</td>
	<td valign=top>No</td>
	<td valign=top>Single string value from the list of valid colors.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>LOGO</b></td>
	<td valign=top>sets a background image; default none, single value only. Accepts a filename
(optionally including path info) of an image file of either PNG, JPEG, or GIF format.
The image will be centered under the graph image.</td>
	<td valign=top>None.</td>
	<td valign=top>Yes</td>
	<td valign=top>If the image size is less than the defined
specified WIDTH and/or HEIGHT, the BACKGROUND color will be used to fill to the edges. If
the image exceeds the WIDTH and/or HEIGHT, the image will be clipped to fit.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>SIGNATURE</b></td>
	<td valign=top>sets a signature string to be printed in tiny font in the
lower right hand corner of the image. E.g. "Copyright(C) 2001, GOWI Systems. All rights reserved.".</td>
	<td valign=top>None.</td>
	<td valign=top>Yes</td>
	<td valign=top>single value, text string only, default none.</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>FORMAT</b></td>
	<td valign=top>sets the output image format, either PNG, JPEG, or GIF</td>
	<td valign=top>PNG</td>
	<td valign=top>Yes</td>
	<td valign=top>Single value, string, either 'PNG','JPEG', 'GIF' (case insensitive).
	Some formats require additional support libraries (See <a href="#conform">PREREQUISITE SOFTWARE</a> below).</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>X_ORIENT</b><br>(<i>aka</i> <b>X-ORIENT</b>)</td>
	<td valign=top>sets the display angle of the X-axis tick labels</td>
	<td valign=top>Horizontal</td>
	<td valign=top>Yes</td>
	<td valign=top>single value, case-insensitive string, 'horizontal' or 'vertical'</td></tr>
<tr bgcolor=white>
	<td valign=top align=center><b>KEEPORIGIN</b></td>
	<td valign=top>forces the origin axes (0,0) in the image.
	Normally, bar, line, point, area, and candlestick graphs automatically
clip away the origin axes if the plot does not cross the origin axis. Set this property
to 1 to force the origin axis to be included. </td>
	<td valign=top>0</td>
	<td valign=top>Yes</td>
	<td valign=top>single value, either 0 or 1. Ignored for piecharts.</td></tr>
<!--
<tr bgcolor=white>
	<td valign=top align=center><b>TEMPLATE</b></td>
	<td valign=top>Establishes an XML template that describes graph properties. Any additional
	properties provided in the WHERE clause will override the template value(s).</td>
	<td valign=top>None.</td>
	<td>Single string value of a URI: e.g., 'http://www.presicient.com/simplebars.xml' or
	'file://topdir/childdir/sample.xml'</td></tr> -->
<tr bgcolor=white>
	<td valign=top align=center><b>FONT</b></td>
	<td valign=top>sets the font face for text in the image; may be multivalued,
	in which case the list of fonts is scanned left to right to find the first
	instance supported on the current platform.</td>
	<td valign=top>Default GD::Text font for PNG, JPEG, and GIF</td>
	<td valign=top>No</td>

dbdchart.html view on Meta::CPAN

Removes one (or more) data points from the chart. Valid <i>&lt;operator&gt;</i>s are
&lt;, &lt;=, =, &gt;, &gt;=, &lt;&gt;.
E.g., this could be used to render realtime
scrolling linegraphs where old values are rolled off the left of the graph, and new values are appended
on the right.<br>
<b>NOTE:</b>Deleting from a barchart, then inserting new rows, will cause new
rows to be displayed at the right end of the chart. Use UPDATE if you want to
modified the bar values, but maintain the original display order.
</li>

</ul>
Note that the &lt;, &lt;=, &gt;, &gt;= predicate operators now fully support temporal values.
<p>

<a name="colormap"></a>
<h3>Colormaps</h3>
The colors used to render the various image elments can be adjusted by the
application by modifying the predefined COLORMAP table. The COLORMAP table
is predefined as follows:
<pre>
CREATE TABLE COLORMAP (
	Name VARCHAR(30),	-- name of color
	RedValue INTEGER,	-- value of red component
	GreenValue INTEGER,	-- value of green component
	BlueValue INTEGER,	-- value of blue component
);
</pre>
The color component values must be specified between 0 and 255.
<p>
The following values are predefined in the COLORMAP table:
<table border=1><tr><th bgcolor=lightgrey>Name</th><th bgcolor=red>RedValue</th><th bgcolor=green>GreenValue</th><th bgcolor=blue>BlueValue</th></tr>
<tr bgcolor=white><td align=center>white</td><td>255</td><td>255</td><td>255</td></tr>
<tr bgcolor=white><td align=center>lgray</td><td>191</td><td>191</td><td>191</td></tr>
<tr bgcolor=white><td align=center>gray</td><td>127</td><td>127</td><td>127</td></tr>
<tr bgcolor=white><td align=center>dgray</td><td>63</td><td>63</td><td>63</td></tr>
<tr bgcolor=white><td align=center>black</td><td>0</td><td>0</td><td>0</td></tr>
<tr bgcolor=white><td align=center>lblue</td><td>0</td><td>0</td><td>255</td></tr>
<tr bgcolor=white><td align=center>blue</td><td>0</td><td>0</td><td>191</td></tr>
<tr bgcolor=white><td align=center>dblue</td><td>0</td><td>0</td><td>127</td></tr>
<tr bgcolor=white><td align=center>gold</td><td>255</td><td>215</td><td>0</td></tr>
<tr bgcolor=white><td align=center>lyellow</td><td>255</td><td>255</td><td>0</td></tr>
<tr bgcolor=white><td align=center>yellow</td><td>191</td><td>191</td><td>0</td></tr>
<tr bgcolor=white><td align=center>dyellow</td><td>127</td><td>127</td><td>0</td></tr>
<tr bgcolor=white><td align=center>lgreen</td><td>0</td><td>255</td><td>0</td></tr>
<tr bgcolor=white><td align=center>green</td><td>0</td><td>191</td><td>0</td></tr>
<tr bgcolor=white><td align=center>dgreen</td><td>0</td><td>127</td><td>0</td></tr>
<tr bgcolor=white><td align=center>lred</td><td>255</td><td>0</td><td>0</td></tr>
<tr bgcolor=white><td align=center>red</td><td>191</td><td>0</td><td>0</td></tr>
<tr bgcolor=white><td align=center>dred</td><td>127</td><td>0</td><td>0</td></tr>
<tr bgcolor=white><td align=center>lpurple</td><td>255</td><td>0</td><td>255</td></tr>
<tr bgcolor=white><td align=center>purple</td><td>191</td><td>0</td><td>191</td></tr>
<tr bgcolor=white><td align=center>dpurple</td><td>127</td><td>0</td><td>127</td></tr>
<tr bgcolor=white><td align=center>lorange</td><td>255</td><td>183</td><td>0</td></tr>
<tr bgcolor=white><td align=center>orange</td><td>255</td><td>127</td><td>0</td></tr>
<tr bgcolor=white><td align=center>pink</td><td>255</td><td>183</td><td>193</td></tr>
<tr bgcolor=white><td align=center>dpink</td><td>255</td><td>105</td><td>180</td></tr>
<tr bgcolor=white><td align=center>marine</td><td>127</td><td>127</td><td>255</td></tr>
<tr bgcolor=white><td align=center>cyan</td><td>0</td><td>255</td><td>255</td></tr>
<tr bgcolor=white><td align=center>lbrown</td><td>210</td><td>180</td><td>140</td></tr>
<tr bgcolor=white><td align=center>dbrown</td><td>165</td><td>42</td><td>42</td></tr>
<tr bgcolor=white><td align=center>transparent</td><td>1</td><td>1</td><td>1</td></tr>
</table><p>
For example, to define a new color:
<pre>
$dbh-&gt;do('INSERT INTO COLORMAP VALUES('chartreuse', 230, 179, 180);
</pre>
To modify an existing color:
<pre>
$dbh-&gt;do("UPDATE COLORMAP SET REDVALUE=100 WHERE NAME='marine'");
</pre>
To fetch the current values of an existing color:
<pre>
$sth = $dbh-&gt;prepare("SELECT * FROM COLORMAP NAME='marine'");
$sth-&gt;execute;
$row = $sth-&gt;fetchrow_arrayref;
</pre>
Finally, a generic parameterized statement can be used to define colors at runtime:
<pre>
$sth = $dbh-&gt;prepare("INSERT INTO COLORMAP VALUES(?, ?, ?, ?)");
$sth-&gt;execute('marine', 127, 127, 255);
</pre>
Note that using non-alphanumeric characters in color names may cause parsing
problems, so stick to alphanumerics, e.g., 'red3'.
<p>

<a name="imagemaps"></a>
<h3>Imagemaps</h3>
Imagemaps can be generated by including the <code>IMAGEMAP</code> column as the 2nd field
in the SELECTed fieldlist.
HTML client-side imagemaps are generated if the <code>MAPTYPE</code> qualifier is 'HTML',
or if no qualifier is provided.
A Perl compatible array of hashrefs of attributes and coordinates is provided if the
<code>MAPTYPE</code> qualifier is 'PERL'.<p>
The resulting HTML imagemap will have the following behaviors based on the type of chart/graph
requested, and the values specified (if any) for the MAPURL and MAPSCRIPT qualifiers:<p>
<table border=1>
<tr bgcolor=lightsteelblue><th>Graph Type</th><th>Hotspot Area</th><th>ALT tag</th><th>Special Variable<br>Values</th></tr>
<tr bgcolor=white><td valign=top align=center><b>Piechart</b></td>
	<td valign=top>Polygon starting from center and<br>connecting 10&deg; arcs along the circumference of the wedge.</td>
	<td valign=top>Wedge value followed by wedge percent in parentheses<br>
	e.g., "1234(16%)"</td>
	<td>
		<ol>
		<li>:PLOTNUM = 0
		<li>:X = &lt;wedge-label&gt;
		<li>:Y = &lt;assoc. wedge value&gt;
		<li>:Z = &lt;wedge's percent of total&gt;
		</ol>
	</td></tr>
<tr bgcolor=white><td valign=top align=center><b>2-D Barchart and Histogram</b></td>
	<td valign=top>Complete area of each bar</td>
	<td valign=top>Range value for the bar</td>
	<td>
		<ol>
		<li>:PLOTNUM = &lt;range number of the bar&gt;
		<li>:X = &lt;domain label for the bar&gt;
		<li>:Y = &lt;range value for the bar&gt;
		<li>:Z = &lt;empty-string&gt;
		</ol>
	</td></tr>
<tr bgcolor=white><td valign=top align=center><b>3-D Barchart(Histogram)<br>(including 3-axis)</b></td>

dbdchart.html view on Meta::CPAN

Release 0.60:
<ul>
<li>temporal data type support
<li>histogram support
<li>composite images via derived tables
<li>user defined colors
<li>Gantt charts
</ul>

Release 0.52:
<ul>
<li>fix for 2D max range values
</ul>

Release 0.51:
<ul>
<li>3-D piechart support
<li>multicolor, single range barcharts
</ul>

Release 0.50:
<ul>
<li>remove dependencies on GD::Graph (ie., added internal piechart, barchart rendering in DBD::Chart::Plot)
<li>added iconic barcharts and datapoints (ie., use small images instead of solid bars/points)
<li>3-D, 3 axis barcharts (X, Y, Z datapoints)
<li>support for imagemap hotspot generation (i.e., SELECT LINEGRAPH, IMAGEMAP FROM...)
<li>added box&whisker charts
<li>moved logo processing from DBD::Chart to DBD::Chart::Plot
<li>bug fix for symbolic domain areagraphs
<li>bug fix for escaping single quotes inside a string
</ul>

Release 0.43:
<ul>
<li>fix to support GIF via older GD packages (many thanks to Peter Scott!)
<li>other cosmetic fixes
</ul>

Release 0.42:
<ul>
<li>fix to support X-ORIENT='HORIZONTAL' on symbolic domains, candlesticks
</ul>

Release 0.41:
<ul>
<li>fix to strip quotes from string literal in INSERT statement
<li>fix for string literal column index variable in prepare of INSERT
<li>fix for Y-axis tick alignment when no grid is requested
</ul>

Release 0.40:<p>
<ul>
<li>fix for DECIMAL, INTEGER, etc. last columns in CREATE TABLE</li>
<li>fix for FORMAT property to properly handle as string value</li>
<li>added Y-MAX, Y-MIN properties to control Y-axis min/max values for barcharts</li>
</ul>

Release 0.30:<p>
<ul>
<li>strip newlines from SQL for prepare()
<li>add BACKGROUND property to set background color, incl. transparent background
<li>add FORMAT property to select PNG or JPEG
<li>add X-ORIENT property to set X-tick label orientation
<li>add LOGO property to set a background image
<li>add SIGNATURE property to set a signature string in image
<li>add placeholder support in SELECT WHERE clause
<li>add KEEPORIGIN property to force (0,0) in the graph
<li>auto-skip symbolic X-axis vertical tick labels when they overlap
<li>add parameterized chart datasource (i.e., SELECT BARCHART FROM ? WHERE...)
</ul><p>

Release 0.20:<p>
<ul>
<li>added support for 3-D bar and pie charts (via GD::Graph3d)
<li>added logarithmic line/point graph support
<li>added area graphs
<li>added candlestick charts (e.g., for daily trading range charts)
<li>added support for non-numeric domain values
<li>packaged for CPAN
</ul><p>

Release 0.10:<p>
<ul>
<li>Coded; first alpha release
</ul><p>

<a name="bugs"></a>
<h2>Known Bugs</h2><p>

<table border=1><tr bgcolor=white>
<th align=center>Bug Number</th>
    <th align=center>Report<br>Date</th>
    <th align=center>Release<br>Reported in</th>
    <th align=center>Description</th>
    <th align=center>Status</th>
    <th align=center>Fix<br>Release</th>
</tr><tr bgcolor=white>
	<td align=center>1</td>
	<td align=center>2001-Mar-16</td>
	<td align=center>0.20</td>
	<td align=left>SQL statements with newlines won't prepare()</td>
	<td align=center>Fixed</td>
	<td align=center>0.30</td>
</tr><tr bgcolor=white>
	<td align=center>2</td>
	<td align=center>2001-May-09</td>
	<td align=center>0.30</td>
	<td align=left>INTEGER column definition as last column in CREATE TABLE causes an error</td>
	<td align=center>Fixed</td>
	<td align=center>0.40</td>
</tr><tr bgcolor=white>
	<td align=center>3</td>
	<td align=center>2001-May-09</td>
	<td align=center>0.30</td>
	<td align=left>FORMAT property not properly handled as string property</td>
	<td align=center>Fixed</td>
	<td align=center>0.40</td>
</tr><tr bgcolor=white>
	<td align=center>4</td>
	<td align=center>2001-Jun-01</td>
	<td align=center>0.40</td>

( run in 1.742 second using v1.01-cache-2.11-cpan-437f7b0c052 )