Another newbie NET.Data issue

["Mark Allen" <scprideandms@xxxxxxxxx>]

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