Re: Net.Data - extra blank rows and an SQLSTATE 22003

I was doing the following:

select a.ndc_upc_hri, INGDRGNM

from medispan.actingrd A

where a.ndc_upc_hri = $(NDC)



$NDC is from an input box on the page.



The table column ndc_upc_hri is a CHAR(20). However the values in it are
all numeric.



So for instance I might be looking for 00002080303.



I changed the query to

select a.ndc_upc_hri, INGDRGNM

from medispan.actingrd A

where a.ndc_upc_hri = ‘$(NDC)’



And my error went away! J


Do I always need to quote character values? Or is this some funkyness due
to the numeric value in a character column?


Strange that it'd work as far as returning data, and only give an error if
there was one row to return...





On Thu, Oct 23, 2014 at 4:59 PM, Holger Scherer <hs@xxxxxxx> wrote:

Can you post the relevant function and parameter?

-h

Am 23.10.2014 um 22:54 schrieb Charles Wilt <charles.wilt@xxxxxxxxx>:

So far, every time the query results in 1 row, I see that row, a bunch of
blanks and the error. It doesn't matter if I use the default report or a
custom one.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.