When I tried to print a value of that NULL column in SQL,
I am getting an empty string (v1='').
Oh, I think I know the answer from the existing code:
<xsl:when test="normalize-space(v1) = '' or string(v1) = 'NaN'">
...do something
</xsl:when>
Does it make sense to you ?
TIA,
Oleg.
On 7/24/06, Michael Kay <mike(_at_)saxonica(_dot_)com> wrote:
There are two main ways of representing an absent value in XML. The relevant
element might be omitted entirely, or it might be present with empty
content. (There's a third way, the xsi:nil attribute, but I don't think
anyone uses it.) To answer your question we need to know what the XML looks
like, and what $v1 is.
Michael Kay
http://www.saxonica.com/
> -----Original Message-----
> From: Oleg Konovalov [mailto:olegkon(_at_)gmail(_dot_)com]
> Sent: 24 July 2006 20:41
> To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
> Subject: [xsl] Comparing to SQL NULL
>
> Hi,
>
> I am writing some XSL code processing database columns
> (actually, adding a new column to the existing table in old
> application) and need to handle a situation when the column
> does not have a value yet.
> So how do I express that condition in XSL:
> <xsl:when test="$v1 = 'NULL'">
> ... do something
> </xsl:when>
> or <xsl:when test="$v1 = 'NaN'">
> ... do something
> </xsl:when>
> or <xsl:when test="$v1 = ''"> ... blank string: ''
> ... do something
> </xsl:when> ???
>
> Please help.
>
> Sorry for the newbie question.
> Using XSLT1.0 [and Cocoon 2.0.x]
>
> Thank you,
> Oleg.
>
> --~------------------------------------------------------------------
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
> --~--
>
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--