ESQL: Problems getting null values

[Derek Hohls <DH...@csir.co.za>]

(using Cocoon 2.1.3)

I am trying to get null values in the database showing
up in XML via an ESQL query.

The original table is a mySQL table, where the "Value"
column is a double type.

When I use:

<esql:get-string column="Value"/>
I get
0.000000000000

And when I try:

<esql:get-double column="Value"/>
I get
0.0

As some values in the database are "genuine" zeroes,
how can I tell which are genuine and which are null
if the ESQL methods do not return the correct response?

Thanks
Derek

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

RE: ESQL: Problems getting null values

[Leszek Gawron <ou...@wlkp.org>]

> I am trying to get null values in the database showing
> up in XML via an ESQL query.
<esql:is-null/>

My regards
	Leszek Gawron


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org