08:31:35.56 ACECODE.ONPROCESSINIT !!showschedule 08:31:35.56 ACECODE.ONPROCESSINIT !!showschedule 08:31:35.56 ACECODE.ONPROCESSINIT !!showschedule 08:31:35.56 ACECODE.ONPROCESSINIT !!showschedule 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.59 AWBUSINESSOBJECT.INIT Biz object - VFP data. 08:31:35.60 ACECODE.SHOWSCHEDULE !!ShowSchedule .awp Criteria=colocid=%2522353555015823%2522&Title=Room+303,+305++++++++++++++++++++++++++++++++++++++++++ Called by 08:31:35.64 ACECODE.SHOWSCHEDULE !Passed in Cursor Criteria=colocid=%22353555015823%22 Group= Cat Criteria= Passed in SQL criteria= 08:31:35.64 ACECODE.SHOWSCHEDULE Parameter Criteria=colocid=%22353555015823%22 08:31:35.65 ACECODE.SHOWSCHEDULE Title=Room 303, 305 Target= URL=https://ace.capetigers.com/wconnect/ShowSchedule.awp? Mode= 08:31:35.67 ACECODE.SHOWSCHEDULE HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm 08:31:35.67 ACECODE.SHOWSCHEDULE Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI 08:31:35.68 ACECODE.SHOWSCHEDULE Group= 08:31:35.68 ACECODE.SHOWSCHEDULE Ready for main query: Course_Name:Course Name;Begins:Begins;Ends:Ends;Meets:Meets;FullFee:Fee Course_Name:Title; cotype:Type; FullFee:Fee 0 08:31:35.70 ACECODE.SHOWSCHEDULE Joining location table 08:31:35.70 ACECODE.SHOWSCHEDULE Joining location table 08:31:35.71 ACECODE.SHOWSCHEDULE
VFP: SELECT Course.* , Fees.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus FROM Course JOIN Fees ON UPPER(fecrse) == UPPER(cocrse) AND NOT fees.fewebhide AND (fees.feauto OR (fees.feident=[F] AND feorder = 1)) JOIN Location ON Course.colocid = Location.locid WHERE ((DTOS(cobegdate) >= DTOS(DATE() - coweblag) ) OR (NOT EMPTY(coopendat) AND coopendat <= DATE()) AND (EMPTY(coenddate) OR coenddate >= DATE())) AND coactive AND NOT cocancel AND (cowebreg > 3 - __Override ) and (EMPTY(copubdate) or copubdate <= DATE()) ORDER BY cocrsenm, cobegdate
SQL: SELECT Course.* , Fees.* , locid, loclocat, locinfo, loccity, locstate, locudf1, locudf2, loccampus FROM Course JOIN Fees ON UPPER(fecrse) = UPPER(cocrse) AND fees.fewebhide = 0 AND (fees.feauto=1 OR (fees.feident='F' AND fees.feorder=1)) JOIN Location ON Course.colocid = Location.locid WHERE ((cobegdate >= CONVERT(date, GETDATE() - coweblag) ) OR ((coopendat IS NOT NULL AND coopendat <> '1900-01-01') AND coopendat <= CONVERT(date, GETDATE())) AND ((coenddate IS NULL OR coenddate = '1900-01-01') OR coenddate >= CONVERT(date, GETDATE()))) AND coactive=1 AND cocancel=0 AND (cowebreg > 3 - ?__Override ) and (copubdate is null or copubdate <= CONVERT(date, GETDATE())) ORDER BY cocrsenm, cobegdate 08:31:36.97 ACECODE.SHOWSCHEDULE Finished initial Course query: 237 records Session: 3eTpWYhe9Uoe3dXd0 08:31:36.97 ACECODE.SHOWSCHEDULE Finished initial Course query: 237 records Session: 3eTpWYhe9Uoe3dXd0 08:31:37.00 ACECODE.SHOWSCHEDULE Schedule with Fullfee: 84 records, grouped by cocrse 08:31:37.01 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 08:31:37.01 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 08:31:37.01 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 08:31:37.03 ACECODE.SHOWSCHEDULE Cursor Criteria=colocid=%22353555015823%22 Extra Criteria= 08:31:37.03 ACECODE.SHOWSCHEDULE Criteria=(colocid=%22353555015823%22) Groupmode=.F. 08:31:37.04 ACECODE.SHOWSCHEDULE Criteria applied to tSchedule. 84 records, done with Schedule queries 08:31:37.06 ACECODE.SHOWSCHEDULE Found 84 matching courses. Async? No Criteria to be applied=(colocid=%22353555015823%22) Mode= Target=
|