Re: Another newbie NET.Data issue -- WEB400

yeah it is

%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.

On 6/7/07, rking@xxxxxxxxxxxxxxxxx <rking@xxxxxxxxxxxxxxxxx> wrote:

Do you have the following in your function that has the SQL?

%message { 100 : "" : continue %}

That is just a guess, see if you can copy/paste the error message though.

-Robert

"Mark Allen"
<scprideandms@gma To: "Web Enabling the
AS400 / iSeries" <web400@xxxxxxxxxxxx>
il.com> cc:
Sent by: Subject: [WEB400] Another
newbie NET.Data issue
web400-bounces@mi
drange.com

06/07/2007 11:37
AM
Please respond to
Web Enabling the
AS400 / iSeries

Sigh...... I really hope we get our "web" programmer position filled
soon.

Anyways, this time I've got one page that consistently (for every combo of
selection criteria) basically gives me the page/table headings but
instead
of showing the data retrieved we get a wonderful SQL Error on the page
instead of the data that should have been returned. I've checked the 400
database and there 'Should" be data and it is also "supposed" to show a
message of "No learners have been assigned to you" if there is no returned
data from the SQL. See below for partial screen shot.

I've checked every log I know of in the IFS (/home/httplogs files starting
with accesslog and errorlog for the last few days) and no indication of
any
issues. Is there an SQL log somewhere, something else I am missing.

Basically I don't know what else to do with the tools I have available. I
looked over our former Web Programmers shoulder a couple of times on other
debugging issues and IIRC he had a way to check/run (using some
IDE/Client,
not WDSC, maybe Visual Studio?) Net.Data macro's in test/debug to see
where/what it was doing and that sometimes pinpointed the exact issue.

I am going to fire up his PC later and do some digging but since we get to
move our data center tonight, might not get to it and not sure if I could
find anything anyways, or know it if I found it.

Screen shot:

My 1st Core Learners Click learner ID to open a new browser window and
sign-on as the learner. In Credit Hrs column, Red indicates learner not
engaged for that term; Green indicates learner engaged for that term. The
Learner's Current Term is in [brackets], again Red or Green dependent upon
Attendance/Engagement. The Red or Green is only indicated for the term
that
is current.

Click on the Show Grades link to see the learner's grades, and the
Comprehensive
Degree Plan link to see the learner's CDP. *Core Type* *ID Number*
*Learner
Contact Information
(Click name for additional contact information) * *Status*
*Academic Year Registration Group* *Credit Hours* *SQL Error.*
--
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.