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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.