18:24:34.69 ACECODE.ONPROCESSINIT !!showschedule 18:24:34.69 ACECODE.ONPROCESSINIT !!showschedule 18:24:34.69 ACECODE.ONPROCESSINIT !!showschedule 18:24:34.69 ACECODE.ONPROCESSINIT !!showschedule 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.70 AWBUSINESSOBJECT.INIT Biz object - VFP data. 18:24:34.73 ACECODE.SHOWSCHEDULE !!ShowSchedule .awp Criteria=colocid=%2522362062514208%2522&Title=Spanish+Street+Farmacy+++++++++++++++++++++++++++++++++ Called by 18:24:34.75 ACECODE.SHOWSCHEDULE !Passed in Cursor Criteria=colocid=%22362062514208%22 Group= Cat Criteria= Passed in SQL criteria= 18:24:34.75 ACECODE.SHOWSCHEDULE Parameter Criteria=colocid=%22362062514208%22 18:24:34.76 ACECODE.SHOWSCHEDULE Title=Spanish Street Farmacy Target= URL=https://ace.capetigers.com/wconnect/ShowSchedule.awp? Mode= 18:24:34.76 ACECODE.SHOWSCHEDULE HTML Template=C:\INETPUB\wwwroot\wconnect\ace\XShowSchedule.htm 18:24:34.78 ACECODE.SHOWSCHEDULE Template INI=C:\INETPUB\wwwroot\wconnect\ace\ShowSchedule.INI 18:24:34.78 ACECODE.SHOWSCHEDULE Group= 18:24:34.80 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 18:24:34.80 ACECODE.SHOWSCHEDULE Joining location table 18:24:34.80 ACECODE.SHOWSCHEDULE Joining location table 18:24:34.81 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 18:24:35.09 ACECODE.SHOWSCHEDULE Finished initial Course query: 236 records Session: fm9Jtn0jXjsRfrz80 18:24:35.09 ACECODE.SHOWSCHEDULE Finished initial Course query: 236 records Session: fm9Jtn0jXjsRfrz80 18:24:35.12 ACECODE.SHOWSCHEDULE Schedule with Fullfee: 83 records, grouped by cocrse 18:24:35.12 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 83 18:24:35.12 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 83 18:24:35.12 ACECODE.SHOWSCHEDULE !Finished supplemental queries. Record count= 83 18:24:35.14 ACECODE.SHOWSCHEDULE Cursor Criteria=colocid=%22362062514208%22 Extra Criteria= 18:24:35.16 ACECODE.SHOWSCHEDULE Criteria=(colocid=%22362062514208%22) Groupmode=.F. 18:24:35.16 ACECODE.SHOWSCHEDULE Criteria applied to tSchedule. 83 records, done with Schedule queries 18:24:35.17 ACECODE.SHOWSCHEDULE Found 83 matching courses. Async? No Criteria to be applied=(colocid=%22362062514208%22) Mode= Target=
|