× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.