Re: Another newbie NET.Data issue

["Mark Allen" <scprideandms@xxxxxxxxx>]

Thanks, that may just do it, I'll give it a shot and let y'all know.....

<having multiple personalities wouldn't be so bad if the other ones would at
least work part time, but then what can ya expect from guys named Bubba and
Zeke>

On 6/8/07, Matt.Haas@xxxxxxxxxxx <Matt.Haas@xxxxxxxxxxx> wrote:
> If memory serves, you have to do both. You'll also need to restart the
> HTTP server after you change the INI file.
>
> Also, there is a way to print out the values of SQLCOD and SQLSTT but
> it's been a long time since I needed to do it and I don't recall what
> they are. The Net.Data documentation is at
> http://www-03.ibm.com/servers/eserver/iseries/software/netdata/ and I
> know that the documentation covers that.
>
> Matt
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of rick baird
> Sent: Friday, June 08, 2007 10:02 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] Another newbie NET.Data issue
>
> Mark,
>
> Try putting this in your definitions. it's been awhile, but I think
> shows your the resolved SQL statement and maybe even the actual error
> message.
>
> %DEFINE {
>    SHOWSQL  = "YES"
> %}
>
> if that doesn't work, try putting this in your DB2WWW initiator source
> member:
>
> DTW_SHOWSQL YES
>
> hth,
>
> On 6/7/07, Mark Allen <scprideandms@xxxxxxxxx> wrote:
> > Do you rmember how to do that, I could change that easily.....
> >
> > On 6/7/07, DennisRootes@xxxxxxxxxxx <DennisRootes@xxxxxxxxxxx> wrote:
> > >
> > > Mind you it's been a couple years since I dealt with Net.Data, but
> can't
> > > you print out the Sqlcode when it errors to make sure you are
> getting a
> > > 100 error.  Possibly you are throwing a error different code?
> > >
> > > %MESSAGE
> > >     {
> > >         100 :
> > >             "<b>Currently you are not assigned to any core
> > > committees.</b>"
> > >         : CONTINUE
> > >         %INCLUDE "SQLDEFAULT.MBR"
> > >     %}
> > >
> > > Which is what we "used" to get if the SQL retrieved no data, now I
> just
> > > get
> > > that SQL Error even though when I look at the data on the 400 (using
> > > query)
> > > I should get returned data.
> > > --
> > > This is the Web Enabling the AS400 / 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.
> > >
> > >
> > --
> > This is the Web Enabling the AS400 / 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.
> >
> >
> --
> This is the Web Enabling the AS400 / 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.
>
>
> --
> This is the Web Enabling the AS400 / 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.