Records displayed in Enterprise aren't complete

[Nathaniel Tucker]

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

[Frank]

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

Frank,

I tried that! No Luck! Is there a place on the website that lists the major changes in EP compared to Pro?

Here is my code:
<%
Set MyDb1 = Server.CreateObject(&#34;AspDB.EP&#34
MyDb1.dbDSN=&#34;Provider=IBMDA400; Data Source=LEEIBM; User ID=XXXXXX; Password=XXXXXX&#34;
MyDb1.dbDBType=&#34;SQL&#34;
MyDb1.dbUnit=&#34;StudAddAlert&#34;
MyDb1.dbMode=&#34;Grid&#34;
MyDb1.dbDisplayLookUpList=&#34;(;|)KCOURSE||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39;&#34;
EDF = &#34;(;|)KCOURSE||||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CNUMBR||||DISTINCT;&#34;
EDF = EDF & &#34;KSECTION||||Select Distinct CSECTN FROM CSBRGD.COURSE Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CSECTN||||DISTINCT;&#34;
MyDb1.dbEditDropFlds = EDF
MyDb1.dbEditFlds = &#34;KSOC[&#34; & Session(&#34;ASPdb_StudAllInfo_MSOC&#34 & &#34;],KSEMC[&#34; & CurSem & &#34;],KCOURSE,KSECTION,KINFO,KDATE[timestamp(yyyy/mm/dd)],KTIME[timestamp(hh:mm:ss)],KICODE[&#34; & Session(&#34;AdvCode&#34 & &#34;]&#34;
EP = &#34;Tablename=LEEWEB.HIGHRISK, BookmarkFlds=KSOC,KSEMC,KCOURSE,KSECTION,KDATE,KTI ME, TableTagBorder=0&#34;
EP = EP & &#34;, RecordScope=single, InputSize=5x75&#34;
MyDb1.dbEditParams = EP
Mydb1.dbEditAddROFlds=&#34;KSOC,KDATE,KTIME,KICODE ,KSEMC&#34;
MyDb1.dbNameMap=&#34;KSOC,<font color=black>Soc. Sec. No.</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSEMC,<font color=black>Semester</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KCOURSE,<font color=black>Course</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSECTION,<font color=black>Section</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KDATE,<font color=black>Date Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KTIME,<font color=black>Time Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;CTRNDS,<font color=black>Course Description</font>,valign=top bgcolor=Silver;&#34;&_
&#34;IFNAME,<font color=black>Instructor Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;&_
&#34;KINFO,<font color=black>Alert Information</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KICODE,<font color=black>Instructor Code</font>,valign=top bgcolor=Silver;&#34;&_
&#34;MFST,<font color=black>Student Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;
MyDb1.dbGridTableTag=&#34;BORDER=0 CELLPADDING=5 Cellspacing=0 align=center&#34;
MyDb1.dbGridColSort=&#34;False&#34;
MyDb1.dbGridIncMax=-1
MyDb1.dbNavigation=&#34;Bottom&#34;
MyDb1.dbNavigationItem=&#34;add&#34;
MyDb1.dbMemoTextSize=31500
MyDb1.dbStatusBar=False
MyDb1.dbHeader=&#34;True&#34;
MyDb1.dbGridDisplayFlds=&#34;KSEMC,CTRNDS,IFNAME,I LNAME&#34;
&#39;MyDb1.dbGridDisplayFlds=&#34;-1&#34;
MyDb1.dbGridTHBGtag=&#34;Align=Left&#34;
MyDb1.dbFormHideFlds=&#34;KIndex,KICODE,KDATE,KTIM E&#34;
MyDb1.dbSuppressMsg=True
MyDb1.dbColor=&#34;1,,#FFFFFF&#34;
MyDb1.dbGridHideDuprecFlds=&#34;KSEMC&#34;
MyDb1.dbMagicCell=&#34;CTRNDS,,<a href=/studentinfo/alerts_individual.asp?SSN=#KSOC#&SEM=#KSEMC#&CRSE= #KCOURSE#&SECT=#KSECTION#>#CTRNDS#</a>;&#34;&_
&#34;KSOC,,Format=[###-##-####];&#34;&_
&#34;KCOURSE,,#KCOURSE##KSECTION#;&#34;
MyDb1.dbGridIndex=&#34;False&#34;
MyDb1.dbSQL=&#34;Select LEEWEB.HIGHRISK.KSOC, CSBMAD.STUDENT.MFST, CSBMAD.STUDENT.MLST, LEEWEB.HIGHRISK.KSEMC, LEEWEB.HIGHRISK.KCOURSE, LEEWEB.HIGHRISK.KSECTION,&#34;&_
&#34; LEEWEB.HIGHRISK.KINFO, LEEWEB.HIGHRISK.KDATE, LEEWEB.HIGHRISK.KTIME, LEEWEB.HIGHRISK.KINDEX,&#34;&_
&#34; LEEWEB.HIGHRISK.KICODE, CSBRGD.COURSE.CTRNDS, CSBMAD.INSTRCT.IFNAME, CSBMAD.INSTRCT.ILNAME&#34;&_
&#34; FROM LEEWEB.HIGHRISK&#34; &_
&#34; LEFT OUTER JOIN CSBRGD.COURSE ON LEEWEB.HIGHRISK.KSEMC = CSBRGD.COURSE.CSEMC AND LEEWEB.HIGHRISK.KCOURSE = CSBRGD.COURSE.CNUMBR AND LEEWEB.HIGHRISK.KSECTION = CSBRGD.COURSE.CSECTN&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.INSTRCT ON LEEWEB.HIGHRISK.KICODE = CSBMAD.INSTRCT.ICODE&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.STUDENT ON LEEWEB.HIGHRISK.KSOC = CSBMAD.STUDENT.MSOC&#34; &_
&#34; Where (KSOC=&#39;&#34; & Request(&#34;SSN&#34 & &#34;&#39&#34; &_
&#34; order by KSEMC DESC, KCOURSE, KSECTION&#34;
ULT = zDrop & &#34;,none;&#34;
ULT = ULT & zMemoText & &#34;,Insert Comments Here!;&#34;
ULT = ULT & zNewRec & &#34;, ;&#34;
ULT = ULT & zField & &#34;, ;&#34;
ULT = ULT & zAdd & &#34;,Click here to ADD Comment!;&#34;
ULT = ULT & zAddHead & &#34;,<font size=+1 color=Red>ADD a Comment on &#34; & Session(&#34;ASPdb_StudAllInfo_MFST&#34 & &#34; &#34; & Session(&#34;ASPdb_StudAllInfo_MLST&#34 & &#34;</font>;&#34;
MyDb1.dbUserLocalText = ULT
MyDb1.aspDBEP
%>

------------
Frank at 5/14/00 1:11:35 AM

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

[Nathaniel Tucker]

I realized that the code was hard to read after posting. It can be found here: http://www.leeuniversity.edu/misc/toolbox_code.txt . Thanks!


------------
at 5/15/00 8:20:52 AM

Frank,

I tried that! No Luck! Is there a place on the website that lists the major changes in EP compared to Pro?

Here is my code:
<%
Set MyDb1 = Server.CreateObject(&#34;AspDB.EP&#34
MyDb1.dbDSN=&#34;Provider=IBMDA400; Data Source=LEEIBM; User ID=XXXXXX; Password=XXXXXX&#34;
MyDb1.dbDBType=&#34;SQL&#34;
MyDb1.dbUnit=&#34;StudAddAlert&#34;
MyDb1.dbMode=&#34;Grid&#34;
MyDb1.dbDisplayLookUpList=&#34;(;|)KCOURSE||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39;&#34;
EDF = &#34;(;|)KCOURSE||||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CNUMBR||||DISTINCT;&#34;
EDF = EDF & &#34;KSECTION||||Select Distinct CSECTN FROM CSBRGD.COURSE Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CSECTN||||DISTINCT;&#34;
MyDb1.dbEditDropFlds = EDF
MyDb1.dbEditFlds = &#34;KSOC[&#34; & Session(&#34;ASPdb_StudAllInfo_MSOC&#34 & &#34;],KSEMC[&#34; & CurSem & &#34;],KCOURSE,KSECTION,KINFO,KDATE[timestamp(yyyy/mm/dd)],KTIME[timestamp(hh:mm:ss)],KICODE[&#34; & Session(&#34;AdvCode&#34 & &#34;]&#34;
EP = &#34;Tablename=LEEWEB.HIGHRISK, BookmarkFlds=KSOC,KSEMC,KCOURSE,KSECTION,KDATE,KTI ME, TableTagBorder=0&#34;
EP = EP & &#34;, RecordScope=single, InputSize=5x75&#34;
MyDb1.dbEditParams = EP
Mydb1.dbEditAddROFlds=&#34;KSOC,KDATE,KTIME,KICODE ,KSEMC&#34;
MyDb1.dbNameMap=&#34;KSOC,<font color=black>Soc. Sec. No.</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSEMC,<font color=black>Semester</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KCOURSE,<font color=black>Course</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSECTION,<font color=black>Section</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KDATE,<font color=black>Date Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KTIME,<font color=black>Time Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;CTRNDS,<font color=black>Course Description</font>,valign=top bgcolor=Silver;&#34;&_
&#34;IFNAME,<font color=black>Instructor Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;&_
&#34;KINFO,<font color=black>Alert Information</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KICODE,<font color=black>Instructor Code</font>,valign=top bgcolor=Silver;&#34;&_
&#34;MFST,<font color=black>Student Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;
MyDb1.dbGridTableTag=&#34;BORDER=0 CELLPADDING=5 Cellspacing=0 align=center&#34;
MyDb1.dbGridColSort=&#34;False&#34;
MyDb1.dbGridIncMax=-1
MyDb1.dbNavigation=&#34;Bottom&#34;
MyDb1.dbNavigationItem=&#34;add&#34;
MyDb1.dbMemoTextSize=31500
MyDb1.dbStatusBar=False
MyDb1.dbHeader=&#34;True&#34;
MyDb1.dbGridDisplayFlds=&#34;KSEMC,CTRNDS,IFNAME,I LNAME&#34;
&#39;MyDb1.dbGridDisplayFlds=&#34;-1&#34;
MyDb1.dbGridTHBGtag=&#34;Align=Left&#34;
MyDb1.dbFormHideFlds=&#34;KIndex,KICODE,KDATE,KTIM E&#34;
MyDb1.dbSuppressMsg=True
MyDb1.dbColor=&#34;1,,#FFFFFF&#34;
MyDb1.dbGridHideDuprecFlds=&#34;KSEMC&#34;
MyDb1.dbMagicCell=&#34;CTRNDS,,<a href=/studentinfo/alerts_individual.asp?SSN=#KSOC#&SEM=#KSEMC#&CRSE= #KCOURSE#&SECT=#KSECTION#>#CTRNDS#</a>;&#34;&_
&#34;KSOC,,Format=[###-##-####];&#34;&_
&#34;KCOURSE,,#KCOURSE##KSECTION#;&#34;
MyDb1.dbGridIndex=&#34;False&#34;
MyDb1.dbSQL=&#34;Select LEEWEB.HIGHRISK.KSOC, CSBMAD.STUDENT.MFST, CSBMAD.STUDENT.MLST, LEEWEB.HIGHRISK.KSEMC, LEEWEB.HIGHRISK.KCOURSE, LEEWEB.HIGHRISK.KSECTION,&#34;&_
&#34; LEEWEB.HIGHRISK.KINFO, LEEWEB.HIGHRISK.KDATE, LEEWEB.HIGHRISK.KTIME, LEEWEB.HIGHRISK.KINDEX,&#34;&_
&#34; LEEWEB.HIGHRISK.KICODE, CSBRGD.COURSE.CTRNDS, CSBMAD.INSTRCT.IFNAME, CSBMAD.INSTRCT.ILNAME&#34;&_
&#34; FROM LEEWEB.HIGHRISK&#34; &_
&#34; LEFT OUTER JOIN CSBRGD.COURSE ON LEEWEB.HIGHRISK.KSEMC = CSBRGD.COURSE.CSEMC AND LEEWEB.HIGHRISK.KCOURSE = CSBRGD.COURSE.CNUMBR AND LEEWEB.HIGHRISK.KSECTION = CSBRGD.COURSE.CSECTN&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.INSTRCT ON LEEWEB.HIGHRISK.KICODE = CSBMAD.INSTRCT.ICODE&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.STUDENT ON LEEWEB.HIGHRISK.KSOC = CSBMAD.STUDENT.MSOC&#34; &_
&#34; Where (KSOC=&#39;&#34; & Request(&#34;SSN&#34 & &#34;&#39&#34; &_
&#34; order by KSEMC DESC, KCOURSE, KSECTION&#34;
ULT = zDrop & &#34;,none;&#34;
ULT = ULT & zMemoText & &#34;,Insert Comments Here!;&#34;
ULT = ULT & zNewRec & &#34;, ;&#34;
ULT = ULT & zField & &#34;, ;&#34;
ULT = ULT & zAdd & &#34;,Click here to ADD Comment!;&#34;
ULT = ULT & zAddHead & &#34;,<font size=+1 color=Red>ADD a Comment on &#34; & Session(&#34;ASPdb_StudAllInfo_MFST&#34 & &#34; &#34; & Session(&#34;ASPdb_StudAllInfo_MLST&#34 & &#34;</font>;&#34;
MyDb1.dbUserLocalText = ULT
MyDb1.aspDBEP
%>

------------
Frank at 5/14/00 1:11:35 AM

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

[Frank Kwong]

Ah... I found the line....

MyDb1.dbGridIncMax=-1

try

MyDb1.dbGridIncMax=1000
MyDb1.dbGridInc=10 &#39;example

Now you should be able to control the GridInc.

Are yo using the AS400 ODBC driver ? Do yo uhave any luck with it. If so, who is the supplier of this ODBC driver. A few client has problem with AS400 driver in the cursor area.


FK


------------
at 5/15/00 8:20:52 AM

Frank,

I tried that! No Luck! Is there a place on the website that lists the major changes in EP compared to Pro?

Here is my code:
<%
Set MyDb1 = Server.CreateObject(&#34;AspDB.EP&#34
MyDb1.dbDSN=&#34;Provider=IBMDA400; Data Source=LEEIBM; User ID=XXXXXX; Password=XXXXXX&#34;
MyDb1.dbDBType=&#34;SQL&#34;
MyDb1.dbUnit=&#34;StudAddAlert&#34;
MyDb1.dbMode=&#34;Grid&#34;
MyDb1.dbDisplayLookUpList=&#34;(;|)KCOURSE||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39;&#34;
EDF = &#34;(;|)KCOURSE||||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CNUMBR||||DISTINCT;&#34;
EDF = EDF & &#34;KSECTION||||Select Distinct CSECTN FROM CSBRGD.COURSE Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CSECTN||||DISTINCT;&#34;
MyDb1.dbEditDropFlds = EDF
MyDb1.dbEditFlds = &#34;KSOC[&#34; & Session(&#34;ASPdb_StudAllInfo_MSOC&#34 & &#34;],KSEMC[&#34; & CurSem & &#34;],KCOURSE,KSECTION,KINFO,KDATE[timestamp(yyyy/mm/dd)],KTIME[timestamp(hh:mm:ss)],KICODE[&#34; & Session(&#34;AdvCode&#34 & &#34;]&#34;
EP = &#34;Tablename=LEEWEB.HIGHRISK, BookmarkFlds=KSOC,KSEMC,KCOURSE,KSECTION,KDATE,KTI ME, TableTagBorder=0&#34;
EP = EP & &#34;, RecordScope=single, InputSize=5x75&#34;
MyDb1.dbEditParams = EP
Mydb1.dbEditAddROFlds=&#34;KSOC,KDATE,KTIME,KICODE ,KSEMC&#34;
MyDb1.dbNameMap=&#34;KSOC,<font color=black>Soc. Sec. No.</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSEMC,<font color=black>Semester</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KCOURSE,<font color=black>Course</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSECTION,<font color=black>Section</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KDATE,<font color=black>Date Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KTIME,<font color=black>Time Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;CTRNDS,<font color=black>Course Description</font>,valign=top bgcolor=Silver;&#34;&_
&#34;IFNAME,<font color=black>Instructor Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;&_
&#34;KINFO,<font color=black>Alert Information</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KICODE,<font color=black>Instructor Code</font>,valign=top bgcolor=Silver;&#34;&_
&#34;MFST,<font color=black>Student Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;
MyDb1.dbGridTableTag=&#34;BORDER=0 CELLPADDING=5 Cellspacing=0 align=center&#34;
MyDb1.dbGridColSort=&#34;False&#34;
MyDb1.dbGridIncMax=-1
MyDb1.dbNavigation=&#34;Bottom&#34;
MyDb1.dbNavigationItem=&#34;add&#34;
MyDb1.dbMemoTextSize=31500
MyDb1.dbStatusBar=False
MyDb1.dbHeader=&#34;True&#34;
MyDb1.dbGridDisplayFlds=&#34;KSEMC,CTRNDS,IFNAME,I LNAME&#34;
&#39;MyDb1.dbGridDisplayFlds=&#34;-1&#34;
MyDb1.dbGridTHBGtag=&#34;Align=Left&#34;
MyDb1.dbFormHideFlds=&#34;KIndex,KICODE,KDATE,KTIM E&#34;
MyDb1.dbSuppressMsg=True
MyDb1.dbColor=&#34;1,,#FFFFFF&#34;
MyDb1.dbGridHideDuprecFlds=&#34;KSEMC&#34;
MyDb1.dbMagicCell=&#34;CTRNDS,,<a href=/studentinfo/alerts_individual.asp?SSN=#KSOC#&SEM=#KSEMC#&CRSE= #KCOURSE#&SECT=#KSECTION#>#CTRNDS#</a>;&#34;&_
&#34;KSOC,,Format=[###-##-####];&#34;&_
&#34;KCOURSE,,#KCOURSE##KSECTION#;&#34;
MyDb1.dbGridIndex=&#34;False&#34;
MyDb1.dbSQL=&#34;Select LEEWEB.HIGHRISK.KSOC, CSBMAD.STUDENT.MFST, CSBMAD.STUDENT.MLST, LEEWEB.HIGHRISK.KSEMC, LEEWEB.HIGHRISK.KCOURSE, LEEWEB.HIGHRISK.KSECTION,&#34;&_
&#34; LEEWEB.HIGHRISK.KINFO, LEEWEB.HIGHRISK.KDATE, LEEWEB.HIGHRISK.KTIME, LEEWEB.HIGHRISK.KINDEX,&#34;&_
&#34; LEEWEB.HIGHRISK.KICODE, CSBRGD.COURSE.CTRNDS, CSBMAD.INSTRCT.IFNAME, CSBMAD.INSTRCT.ILNAME&#34;&_
&#34; FROM LEEWEB.HIGHRISK&#34; &_
&#34; LEFT OUTER JOIN CSBRGD.COURSE ON LEEWEB.HIGHRISK.KSEMC = CSBRGD.COURSE.CSEMC AND LEEWEB.HIGHRISK.KCOURSE = CSBRGD.COURSE.CNUMBR AND LEEWEB.HIGHRISK.KSECTION = CSBRGD.COURSE.CSECTN&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.INSTRCT ON LEEWEB.HIGHRISK.KICODE = CSBMAD.INSTRCT.ICODE&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.STUDENT ON LEEWEB.HIGHRISK.KSOC = CSBMAD.STUDENT.MSOC&#34; &_
&#34; Where (KSOC=&#39;&#34; & Request(&#34;SSN&#34 & &#34;&#39&#34; &_
&#34; order by KSEMC DESC, KCOURSE, KSECTION&#34;
ULT = zDrop & &#34;,none;&#34;
ULT = ULT & zMemoText & &#34;,Insert Comments Here!;&#34;
ULT = ULT & zNewRec & &#34;, ;&#34;
ULT = ULT & zField & &#34;, ;&#34;
ULT = ULT & zAdd & &#34;,Click here to ADD Comment!;&#34;
ULT = ULT & zAddHead & &#34;,<font size=+1 color=Red>ADD a Comment on &#34; & Session(&#34;ASPdb_StudAllInfo_MFST&#34 & &#34; &#34; & Session(&#34;ASPdb_StudAllInfo_MLST&#34 & &#34;</font>;&#34;
MyDb1.dbUserLocalText = ULT
MyDb1.aspDBEP
%>

------------
Frank at 5/14/00 1:11:35 AM

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

[Nathaniel Tucker]

Frank,

Thanks. That worked. I see that you have to use both properties in EP.

I am using the IBMDA400 OLEDB driver for Client Access V4R4 to access the data on our AS/400. We haven&#39;t had any problems. What did you mean by problems in the cursor area?

Thanks,

Nate Tucker



------------
Frank Kwong at 5/15/00 10:10:22 AM

Ah... I found the line....

MyDb1.dbGridIncMax=-1

try

MyDb1.dbGridIncMax=1000
MyDb1.dbGridInc=10 &#39;example

Now you should be able to control the GridInc.

Are yo using the AS400 ODBC driver ? Do yo uhave any luck with it. If so, who is the supplier of this ODBC driver. A few client has problem with AS400 driver in the cursor area.


FK


------------
at 5/15/00 8:20:52 AM

Frank,

I tried that! No Luck! Is there a place on the website that lists the major changes in EP compared to Pro?

Here is my code:
<%
Set MyDb1 = Server.CreateObject(&#34;AspDB.EP&#34
MyDb1.dbDSN=&#34;Provider=IBMDA400; Data Source=LEEIBM; User ID=XXXXXX; Password=XXXXXX&#34;
MyDb1.dbDBType=&#34;SQL&#34;
MyDb1.dbUnit=&#34;StudAddAlert&#34;
MyDb1.dbMode=&#34;Grid&#34;
MyDb1.dbDisplayLookUpList=&#34;(;|)KCOURSE||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39;&#34;
EDF = &#34;(;|)KCOURSE||||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CNUMBR||||DISTINCT;&#34;
EDF = EDF & &#34;KSECTION||||Select Distinct CSECTN FROM CSBRGD.COURSE Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CSECTN||||DISTINCT;&#34;
MyDb1.dbEditDropFlds = EDF
MyDb1.dbEditFlds = &#34;KSOC[&#34; & Session(&#34;ASPdb_StudAllInfo_MSOC&#34 & &#34;],KSEMC[&#34; & CurSem & &#34;],KCOURSE,KSECTION,KINFO,KDATE[timestamp(yyyy/mm/dd)],KTIME[timestamp(hh:mm:ss)],KICODE[&#34; & Session(&#34;AdvCode&#34 & &#34;]&#34;
EP = &#34;Tablename=LEEWEB.HIGHRISK, BookmarkFlds=KSOC,KSEMC,KCOURSE,KSECTION,KDATE,KTI ME, TableTagBorder=0&#34;
EP = EP & &#34;, RecordScope=single, InputSize=5x75&#34;
MyDb1.dbEditParams = EP
Mydb1.dbEditAddROFlds=&#34;KSOC,KDATE,KTIME,KICODE ,KSEMC&#34;
MyDb1.dbNameMap=&#34;KSOC,<font color=black>Soc. Sec. No.</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSEMC,<font color=black>Semester</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KCOURSE,<font color=black>Course</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSECTION,<font color=black>Section</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KDATE,<font color=black>Date Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KTIME,<font color=black>Time Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;CTRNDS,<font color=black>Course Description</font>,valign=top bgcolor=Silver;&#34;&_
&#34;IFNAME,<font color=black>Instructor Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;&_
&#34;KINFO,<font color=black>Alert Information</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KICODE,<font color=black>Instructor Code</font>,valign=top bgcolor=Silver;&#34;&_
&#34;MFST,<font color=black>Student Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;
MyDb1.dbGridTableTag=&#34;BORDER=0 CELLPADDING=5 Cellspacing=0 align=center&#34;
MyDb1.dbGridColSort=&#34;False&#34;
MyDb1.dbGridIncMax=-1
MyDb1.dbNavigation=&#34;Bottom&#34;
MyDb1.dbNavigationItem=&#34;add&#34;
MyDb1.dbMemoTextSize=31500
MyDb1.dbStatusBar=False
MyDb1.dbHeader=&#34;True&#34;
MyDb1.dbGridDisplayFlds=&#34;KSEMC,CTRNDS,IFNAME,I LNAME&#34;
&#39;MyDb1.dbGridDisplayFlds=&#34;-1&#34;
MyDb1.dbGridTHBGtag=&#34;Align=Left&#34;
MyDb1.dbFormHideFlds=&#34;KIndex,KICODE,KDATE,KTIM E&#34;
MyDb1.dbSuppressMsg=True
MyDb1.dbColor=&#34;1,,#FFFFFF&#34;
MyDb1.dbGridHideDuprecFlds=&#34;KSEMC&#34;
MyDb1.dbMagicCell=&#34;CTRNDS,,<a href=/studentinfo/alerts_individual.asp?SSN=#KSOC#&SEM=#KSEMC#&CRSE= #KCOURSE#&SECT=#KSECTION#>#CTRNDS#</a>;&#34;&_
&#34;KSOC,,Format=[###-##-####];&#34;&_
&#34;KCOURSE,,#KCOURSE##KSECTION#;&#34;
MyDb1.dbGridIndex=&#34;False&#34;
MyDb1.dbSQL=&#34;Select LEEWEB.HIGHRISK.KSOC, CSBMAD.STUDENT.MFST, CSBMAD.STUDENT.MLST, LEEWEB.HIGHRISK.KSEMC, LEEWEB.HIGHRISK.KCOURSE, LEEWEB.HIGHRISK.KSECTION,&#34;&_
&#34; LEEWEB.HIGHRISK.KINFO, LEEWEB.HIGHRISK.KDATE, LEEWEB.HIGHRISK.KTIME, LEEWEB.HIGHRISK.KINDEX,&#34;&_
&#34; LEEWEB.HIGHRISK.KICODE, CSBRGD.COURSE.CTRNDS, CSBMAD.INSTRCT.IFNAME, CSBMAD.INSTRCT.ILNAME&#34;&_
&#34; FROM LEEWEB.HIGHRISK&#34; &_
&#34; LEFT OUTER JOIN CSBRGD.COURSE ON LEEWEB.HIGHRISK.KSEMC = CSBRGD.COURSE.CSEMC AND LEEWEB.HIGHRISK.KCOURSE = CSBRGD.COURSE.CNUMBR AND LEEWEB.HIGHRISK.KSECTION = CSBRGD.COURSE.CSECTN&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.INSTRCT ON LEEWEB.HIGHRISK.KICODE = CSBMAD.INSTRCT.ICODE&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.STUDENT ON LEEWEB.HIGHRISK.KSOC = CSBMAD.STUDENT.MSOC&#34; &_
&#34; Where (KSOC=&#39;&#34; & Request(&#34;SSN&#34 & &#34;&#39&#34; &_
&#34; order by KSEMC DESC, KCOURSE, KSECTION&#34;
ULT = zDrop & &#34;,none;&#34;
ULT = ULT & zMemoText & &#34;,Insert Comments Here!;&#34;
ULT = ULT & zNewRec & &#34;, ;&#34;
ULT = ULT & zField & &#34;, ;&#34;
ULT = ULT & zAdd & &#34;,Click here to ADD Comment!;&#34;
ULT = ULT & zAddHead & &#34;,<font size=+1 color=Red>ADD a Comment on &#34; & Session(&#34;ASPdb_StudAllInfo_MFST&#34 & &#34; &#34; & Session(&#34;ASPdb_StudAllInfo_MLST&#34 & &#34;</font>;&#34;
MyDb1.dbUserLocalText = ULT
MyDb1.aspDBEP
%>

------------
Frank at 5/14/00 1:11:35 AM

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker

[Frank Kwong]

Nate
I have several OEM users installing ASPDB on thier clients site using AS400 and the driver they use has cursor problems like somthime it requires a 0 and other time they need to use a 1. I&#39;ll have an opportunity to go in an debug for them in the near future. If you can tell me the info of the functional ODBC driver for AS400 like manufacturer, phone # pr URL, version, price etc. I can mention that to these folks.

Thanks,


Frank


------------
Nathaniel Tucker at 5/15/00 4:52:43 PM

Frank,

Thanks. That worked. I see that you have to use both properties in EP.

I am using the IBMDA400 OLEDB driver for Client Access V4R4 to access the data on our AS/400. We haven&#39;t had any problems. What did you mean by problems in the cursor area?

Thanks,

Nate Tucker



------------
Frank Kwong at 5/15/00 10:10:22 AM

Ah... I found the line....

MyDb1.dbGridIncMax=-1

try

MyDb1.dbGridIncMax=1000
MyDb1.dbGridInc=10 &#39;example

Now you should be able to control the GridInc.

Are yo using the AS400 ODBC driver ? Do yo uhave any luck with it. If so, who is the supplier of this ODBC driver. A few client has problem with AS400 driver in the cursor area.


FK


------------
at 5/15/00 8:20:52 AM

Frank,

I tried that! No Luck! Is there a place on the website that lists the major changes in EP compared to Pro?

Here is my code:
<%
Set MyDb1 = Server.CreateObject(&#34;AspDB.EP&#34
MyDb1.dbDSN=&#34;Provider=IBMDA400; Data Source=LEEIBM; User ID=XXXXXX; Password=XXXXXX&#34;
MyDb1.dbDBType=&#34;SQL&#34;
MyDb1.dbUnit=&#34;StudAddAlert&#34;
MyDb1.dbMode=&#34;Grid&#34;
MyDb1.dbDisplayLookUpList=&#34;(;|)KCOURSE||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39;&#34;
EDF = &#34;(;|)KCOURSE||||Select CNUMBR,CCOURSE as CourseName FROM LEEWEB.CLASALTL1 Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CNUMBR||||DISTINCT;&#34;
EDF = EDF & &#34;KSECTION||||Select Distinct CSECTN FROM CSBRGD.COURSE Where (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST1=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST2=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 or (CSEMC=&#39;&#34; & CurSem & &#34;&#39 AND (CINST3=&#39;&#34; & Session(&#34;ASPdb_&#34; & Session(&#34;myUnit&#34 & &#34;_EICODE&#34 & &#34;&#39 ORDER BY CSECTN||||DISTINCT;&#34;
MyDb1.dbEditDropFlds = EDF
MyDb1.dbEditFlds = &#34;KSOC[&#34; & Session(&#34;ASPdb_StudAllInfo_MSOC&#34 & &#34;],KSEMC[&#34; & CurSem & &#34;],KCOURSE,KSECTION,KINFO,KDATE[timestamp(yyyy/mm/dd)],KTIME[timestamp(hh:mm:ss)],KICODE[&#34; & Session(&#34;AdvCode&#34 & &#34;]&#34;
EP = &#34;Tablename=LEEWEB.HIGHRISK, BookmarkFlds=KSOC,KSEMC,KCOURSE,KSECTION,KDATE,KTI ME, TableTagBorder=0&#34;
EP = EP & &#34;, RecordScope=single, InputSize=5x75&#34;
MyDb1.dbEditParams = EP
Mydb1.dbEditAddROFlds=&#34;KSOC,KDATE,KTIME,KICODE ,KSEMC&#34;
MyDb1.dbNameMap=&#34;KSOC,<font color=black>Soc. Sec. No.</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSEMC,<font color=black>Semester</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KCOURSE,<font color=black>Course</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KSECTION,<font color=black>Section</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KDATE,<font color=black>Date Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KTIME,<font color=black>Time Entered</font>,valign=top bgcolor=Silver;&#34;&_
&#34;CTRNDS,<font color=black>Course Description</font>,valign=top bgcolor=Silver;&#34;&_
&#34;IFNAME,<font color=black>Instructor Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;&_
&#34;KINFO,<font color=black>Alert Information</font>,valign=top bgcolor=Silver;&#34;&_
&#34;KICODE,<font color=black>Instructor Code</font>,valign=top bgcolor=Silver;&#34;&_
&#34;MFST,<font color=black>Student Name</font>,SPAN=2 valign=top bgcolor=Silver;&#34;
MyDb1.dbGridTableTag=&#34;BORDER=0 CELLPADDING=5 Cellspacing=0 align=center&#34;
MyDb1.dbGridColSort=&#34;False&#34;
MyDb1.dbGridIncMax=-1
MyDb1.dbNavigation=&#34;Bottom&#34;
MyDb1.dbNavigationItem=&#34;add&#34;
MyDb1.dbMemoTextSize=31500
MyDb1.dbStatusBar=False
MyDb1.dbHeader=&#34;True&#34;
MyDb1.dbGridDisplayFlds=&#34;KSEMC,CTRNDS,IFNAME,I LNAME&#34;
&#39;MyDb1.dbGridDisplayFlds=&#34;-1&#34;
MyDb1.dbGridTHBGtag=&#34;Align=Left&#34;
MyDb1.dbFormHideFlds=&#34;KIndex,KICODE,KDATE,KTIM E&#34;
MyDb1.dbSuppressMsg=True
MyDb1.dbColor=&#34;1,,#FFFFFF&#34;
MyDb1.dbGridHideDuprecFlds=&#34;KSEMC&#34;
MyDb1.dbMagicCell=&#34;CTRNDS,,<a href=/studentinfo/alerts_individual.asp?SSN=#KSOC#&SEM=#KSEMC#&CRSE= #KCOURSE#&SECT=#KSECTION#>#CTRNDS#</a>;&#34;&_
&#34;KSOC,,Format=[###-##-####];&#34;&_
&#34;KCOURSE,,#KCOURSE##KSECTION#;&#34;
MyDb1.dbGridIndex=&#34;False&#34;
MyDb1.dbSQL=&#34;Select LEEWEB.HIGHRISK.KSOC, CSBMAD.STUDENT.MFST, CSBMAD.STUDENT.MLST, LEEWEB.HIGHRISK.KSEMC, LEEWEB.HIGHRISK.KCOURSE, LEEWEB.HIGHRISK.KSECTION,&#34;&_
&#34; LEEWEB.HIGHRISK.KINFO, LEEWEB.HIGHRISK.KDATE, LEEWEB.HIGHRISK.KTIME, LEEWEB.HIGHRISK.KINDEX,&#34;&_
&#34; LEEWEB.HIGHRISK.KICODE, CSBRGD.COURSE.CTRNDS, CSBMAD.INSTRCT.IFNAME, CSBMAD.INSTRCT.ILNAME&#34;&_
&#34; FROM LEEWEB.HIGHRISK&#34; &_
&#34; LEFT OUTER JOIN CSBRGD.COURSE ON LEEWEB.HIGHRISK.KSEMC = CSBRGD.COURSE.CSEMC AND LEEWEB.HIGHRISK.KCOURSE = CSBRGD.COURSE.CNUMBR AND LEEWEB.HIGHRISK.KSECTION = CSBRGD.COURSE.CSECTN&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.INSTRCT ON LEEWEB.HIGHRISK.KICODE = CSBMAD.INSTRCT.ICODE&#34; &_
&#34; LEFT OUTER JOIN CSBMAD.STUDENT ON LEEWEB.HIGHRISK.KSOC = CSBMAD.STUDENT.MSOC&#34; &_
&#34; Where (KSOC=&#39;&#34; & Request(&#34;SSN&#34 & &#34;&#39&#34; &_
&#34; order by KSEMC DESC, KCOURSE, KSECTION&#34;
ULT = zDrop & &#34;,none;&#34;
ULT = ULT & zMemoText & &#34;,Insert Comments Here!;&#34;
ULT = ULT & zNewRec & &#34;, ;&#34;
ULT = ULT & zField & &#34;, ;&#34;
ULT = ULT & zAdd & &#34;,Click here to ADD Comment!;&#34;
ULT = ULT & zAddHead & &#34;,<font size=+1 color=Red>ADD a Comment on &#34; & Session(&#34;ASPdb_StudAllInfo_MFST&#34 & &#34; &#34; & Session(&#34;ASPdb_StudAllInfo_MLST&#34 & &#34;</font>;&#34;
MyDb1.dbUserLocalText = ULT
MyDb1.aspDBEP
%>

------------
Frank at 5/14/00 1:11:35 AM

Do not see any code and therefore do not really see any problem hence can only make a guess. EP has a new problem called dbGridIncMax see ->(http://2000.aspdb.com/htmldoc/dbGrids.shtm)
This property set the Max Page length to prohibit the use of dbGridInc=-1 and Display a large # of records. Add this to match your Pro code.
Spend a day or so to review all the new features.

These incompatabilities of the versions will dispear soon as they will be uniform with the next major release.

FK


------------
Nathaniel Tucker at 5/13/00 7:03:30 PM

I have just installed enterprise about a week ago. I am in the process of creating a faculty toolkit so that faculty can see class rosters in real time. This is one of the few things that I am doing. The Problem: I can use ASPdbPro to see the rosters and get a complete list. If I use the same code and only change the object at the top of the code and the call at the bottom, I only get 5 records no matter how many should be in there. I tried using the reset feature and I am getting no where. Is anyone having this problem? Have you found a solution?<br><br> I&#39;ve been using ASPdbPro for three years now and I am quite familiar with the language, but this one has gotten me. Any help is appreciated. Thanks, Nate Tucker