Re: xsql results returning empty rowset

From: Chris Laatinen <cl_at_nospam.08002go.com>
Date: Fri, 31 Aug 2001 19:46:04 +0100
Message-ID: <MPG.15f9ebc69308234c989682@news.08002go.com>

In article <2OOj7.3001$ld2.47713_at_newsread2.prod.itd.earthlink.net>, rkopitzke_at_earthlink.net says...

> The XSQL is:
>
> <?xml version="1.0"?>
> <xsql:query connection="efads" xmlns:xsql="urn:oracle-xsql">
> SELECT title from book_table where isbn='1'
> </xsql:query>
>
> The result is:
> <?xml version="1.0"?>
> <ROWSET/>
>
> Any suggestions?

if isbn field is VARCHAR2 then you are only going to get those books which are exactly '1'. If your intention is to get ISBNs containing '1' use 'like'.

If isbn is NUMBER then you are never going to get anything (I.e. empty recordset)... Received on Fri Aug 31 2001 - 13:46:04 CDT