20:12:07.76 ACECODE.ONPROCESSINIT !!showschedule 20:12:07.76 ACECODE.ONPROCESSINIT !!showschedule 20:12:07.76 ACECODE.ONPROCESSINIT !!showschedule 20:12:07.76 ACECODE.ONPROCESSINIT !!showschedule 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.78 AWBUSINESSOBJECT.INIT Biz object - VFP data. 20:12:07.81 ACECODE.SHOWSCHEDULE !!ShowSchedule .awp &Criteria=ALLTRIM(LEFT(loclocat,40))=%2522Annex%2522&Title=Annex Called by 20:12:07.82 ACECODE.SHOWSCHEDULE !Passed in Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Annex%22 Group= Cat Criteria= Passed in SQL criteria= 20:12:07.82 ACECODE.SHOWSCHEDULE Parameter Criteria=ALLTRIM(LEFT(loclocat,40))=%22Annex%22 AND !EMPTY(loclocat) 20:12:07.84 ACECODE.SHOWSCHEDULE Title=Annex Target= URL=https://ace.capetigers.com/wconnect/ShowSchedule.awp? Mode= 20:12:07.84 ACECODE.SHOWSCHEDULE HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm 20:12:07.86 ACECODE.SHOWSCHEDULE Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI 20:12:07.86 ACECODE.SHOWSCHEDULE Group= 20:12:07.87 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 20:12:07.87 ACECODE.SHOWSCHEDULE Joining location table 20:12:07.87 ACECODE.SHOWSCHEDULE Joining location table 20:12:07.89 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 20:12:08.17 ACECODE.SHOWSCHEDULE Finished initial Course query: 237 records Session: 50y1mX8nnNegepcM0 20:12:08.17 ACECODE.SHOWSCHEDULE Finished initial Course query: 237 records Session: 50y1mX8nnNegepcM0 20:12:08.19 ACECODE.SHOWSCHEDULE Schedule with Fullfee: 84 records, grouped by cocrse 20:12:08.20 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 20:12:08.20 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 20:12:08.20 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 84 20:12:08.22 ACECODE.SHOWSCHEDULE Cursor Criteria=ALLTRIM(LEFT(loclocat,40))=%22Annex%22 AND !EMPTY(loclocat) Extra Criteria= 20:12:08.22 ACECODE.SHOWSCHEDULE Criteria=(ALLTRIM(LEFT(loclocat,40))=%22Annex%22 AND !EMPTY(loclocat) ) Groupmode=.F. 20:12:08.23 ACECODE.SHOWSCHEDULE Criteria applied to tSchedule. 84 records, done with Schedule queries 20:12:08.23 ACECODE.SHOWSCHEDULE Found 84 matching courses. Async? No Criteria to be applied=(ALLTRIM(LEFT(loclocat,40))=%22Annex%22 AND !EMPTY(loclocat) ) Mode= Target=
|