Catch Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| Cause | Struct Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | The multi-part identifier "wl.cid" could not be bound. |
| | NativeErrorCode | | | queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: The multi-part identifier "wl.cid" could not be bound.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721)
at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:523)
at application_cfc$cf.udfCall(/Application.cfc:486)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 719: ORDER BY Webinar_list.webinar_dt desc<br>
720: <br>
<b>721: </CFQUERY></b><br>
722: <cfreturn qGetCourseList><br>
723: </cffunction><br>
|
| | codePrintPlain | | string | 719: ORDER BY Webinar_list.webinar_dt desc
720:
721: </CFQUERY>
722: <cfreturn qGetCourseList>
723: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 654: <div id="free_courses" style="display:none;"><br>
655: <!---start free---><br>
<b>656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)></b><br>
657: <!---<cfdump var="#GetCourseList#" label="D">---><br>
658: <CFOUTPUT QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 654: <div id="free_courses" style="display:none;">
655: <!---start free--->
656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)>
657: <!---<cfdump var="#GetCourseList#" label="D">--->
658: <CFOUTPUT QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/continuing_education.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#"><br>
522: <cfelse><br>
<b>523: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
524: </cfif><br>
525: </cffunction><br>
|
| | codePrintPlain | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#">
522: <cfelse>
523: <cfinclude template="#ARGUMENTS.targetPage#">
524: </cfif>
525: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:523) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 484: <br>
485: <cffunction name="onRequest"><br>
<b>486: <cfargument name="targetPage" type="String" required=true/></b><br>
487: <br>
488: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 484:
485: <cffunction name="onRequest">
486: <cfargument name="targetPage" type="String" required=true/>
487:
488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | The multi-part identifier "wl.cid" could not be bound. |
|
| name | |
| NativeErrorCode | |
| queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
|
| rootCause | Struct Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | The multi-part identifier "wl.cid" could not be bound. |
| | NativeErrorCode | | | queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: The multi-part identifier "wl.cid" could not be bound.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721)
at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:523)
at application_cfc$cf.udfCall(/Application.cfc:486)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 719: ORDER BY Webinar_list.webinar_dt desc<br>
720: <br>
<b>721: </CFQUERY></b><br>
722: <cfreturn qGetCourseList><br>
723: </cffunction><br>
|
| | codePrintPlain | | string | 719: ORDER BY Webinar_list.webinar_dt desc
720:
721: </CFQUERY>
722: <cfreturn qGetCourseList>
723: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 654: <div id="free_courses" style="display:none;"><br>
655: <!---start free---><br>
<b>656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)></b><br>
657: <!---<cfdump var="#GetCourseList#" label="D">---><br>
658: <CFOUTPUT QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 654: <div id="free_courses" style="display:none;">
655: <!---start free--->
656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)>
657: <!---<cfdump var="#GetCourseList#" label="D">--->
658: <CFOUTPUT QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/continuing_education.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#"><br>
522: <cfelse><br>
<b>523: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
524: </cfif><br>
525: </cffunction><br>
|
| | codePrintPlain | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#">
522: <cfelse>
523: <cfinclude template="#ARGUMENTS.targetPage#">
524: </cfif>
525: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:523) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 484: <br>
485: <cffunction name="onRequest"><br>
<b>486: <cfargument name="targetPage" type="String" required=true/></b><br>
487: <br>
488: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 484:
485: <cffunction name="onRequest">
486: <cfargument name="targetPage" type="String" required=true/>
487:
488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary, course_list.cexcerpt,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
convert(VARCHAR(8),Webinar_list.webinar_starttime,108) as webinar_starttime, convert(VARCHAR(8),Webinar_list.webinar_endTime,108) as webinar_endTime, cicon
, Course_Users.paydt, Course_Users.cid as purchasedCid
FROM course_list
LEFT JOIN Course_Users ON Course_Users.cid = course_list.cid
AND Course_Users.uid = 0
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND course_list.cid not in (2,3,4,40)
AND wl.cid <> 2 AND wl.cid <> 3 AND wl.cid <> 4 AND wl.cid <> 16 AND wl.cid <> 17 AND wl.cid <> 24 AND wl.cid <> 29 AND wl.cid <> 31 AND wl.cid <> 38 AND wl.cid <> 41 AND wl.cid <> 42 AND wl.cid <> 44 AND wl.cid <> 18 AND wl.cid <> 23 AND wl.cid <> 21 AND wl.cid <> 22 AND wl.cid <> 19 AND wl.cid <> 25 AND wl.cid <> 27 AND wl.cid <> 26 AND wl.cid <> 28 AND wl.cid <> 30 AND wl.cid <> 32 AND wl.cid <> 33 AND wl.cid <> 34 AND wl.cid <> 35 AND wl.cid <> 37 AND wl.cid <> 36 AND wl.cid <> 39 AND wl.cid <> 43 AND wl.cid <> 51 AND wl.cid <> 50 AND wl.cid <> 55 AND wl.cid <> 49 AND wl.cid <> 46 AND wl.cid <> 47 AND wl.cid <> 53 AND wl.cid <> 48 AND wl.cid <> 52 AND wl.cid <> 54 AND wl.cid <> 57 AND wl.cid <> 58 AND wl.cid <> 59 AND wl.cid <> 60 AND wl.cid <> 62 AND wl.cid <> 63 AND wl.cid <> 61 AND wl.cid <> 65 AND wl.cid <> 66 AND wl.cid <> 67 AND wl.cid <> 68 AND wl.cid <> 69 AND wl.cid <> 71 AND wl.cid <> 72 AND wl.cid <> 73 AND wl.cid <> 70 AND wl.cid <> 76 AND wl.cid <> 75 AND wl.cid <> 77 AND wl.cid <> 78 AND wl.cid <> 79 AND wl.cid <> 80 AND wl.cid <> 81 AND wl.cid <> 83 AND wl.cid <> 84 AND wl.cid <> 87 AND wl.cid <> 88 AND wl.cid <> 89 AND wl.cid <> 161 AND wl.cid <> 91 AND wl.cid <> 94 AND wl.cid <> 98 AND wl.cid <> 100 AND wl.cid <> 102 AND wl.cid <> 103 AND wl.cid <> 106 AND wl.cid <> 107 AND wl.cid <> 108 AND wl.cid <> 109 AND wl.cid <> 110 AND wl.cid <> 111 AND wl.cid <> 112 AND wl.cid <> 113 AND wl.cid <> 114 AND wl.cid <> 116 AND wl.cid <> 117 AND wl.cid <> 119 AND wl.cid <> 118 AND wl.cid <> 123 AND wl.cid <> 124 AND wl.cid <> 125 AND wl.cid <> 129 AND wl.cid <> 130 AND wl.cid <> 145 AND wl.cid <> 146 AND wl.cid <> 148 AND wl.cid <> 153 AND wl.cid <> 155 AND wl.cid <> 160 AND wl.cid <> 128 AND wl.cid <> 144 AND wl.cid <> 147 AND wl.cid <> 183 AND wl.cid <> 191 AND wl.cid <> 203 AND wl.cid <> 150 AND wl.cid <> 126 AND wl.cid <> 162 AND wl.cid <> 174 AND wl.cid <> 127 AND wl.cid <> 104 AND wl.cid <> 92 AND wl.cid <> 93 AND wl.cid <> 175 AND wl.cid <> 256 AND wl.cid <> 255 AND wl.cid <> 257 AND wl.cid <> 209 AND wl.cid <> 115 AND wl.cid <> 163 AND wl.cid <> 166 AND wl.cid <> 181 AND wl.cid <> 186 AND wl.cid <> 188 AND wl.cid <> 198 AND wl.cid <> 96 AND wl.cid <> 207 AND wl.cid <> 229 AND wl.cid <> 90 AND wl.cid <> 165 AND wl.cid <> 121 AND wl.cid <> 99 AND wl.cid <> 187 AND wl.cid <> 149 AND wl.cid <> 248 AND wl.cid <> 170 AND wl.cid <> 343 AND wl.cid <> 193 AND wl.cid <> 215 AND wl.cid <> 233 AND wl.cid <> 261 AND wl.cid <> 275 AND wl.cid <> 391 AND wl.cid <> 238 AND wl.cid <> 223 AND wl.cid <> 371 AND wl.cid <> 332 AND wl.cid <> 156 AND wl.cid <> 154 AND wl.cid <> 189 AND wl.cid <> 164 AND wl.cid <> 74 AND wl.cid <> 151 AND wl.cid <> 105 AND wl.cid <> 169 AND wl.cid <> 195 AND wl.cid <> 211 AND wl.cid <> 249 AND wl.cid <> 194 AND wl.cid <> 228 AND wl.cid <> 277 AND wl.cid <> 290 AND wl.cid <> 328 AND wl.cid <> 336 AND wl.cid <> 270 AND wl.cid <> 266 AND wl.cid <> 452 AND wl.cid <> 280 AND wl.cid <> 465 AND wl.cid <> 253 AND wl.cid <> 354 AND wl.cid <> 326 AND wl.cid <> 295 AND wl.cid <> 324 AND wl.cid <> 420 AND wl.cid <> 278 AND wl.cid <> 267 AND wl.cid <> 345 AND wl.cid <> 279 AND wl.cid <> 383 AND wl.cid <> 322 AND wl.cid <> 436 AND wl.cid <> 301 AND wl.cid <> 366 AND wl.cid <> 433 AND wl.cid <> 444 AND wl.cid <> 388 AND wl.cid <> 445 AND wl.cid <> 374 AND wl.cid <> 407 AND wl.cid <> 410 AND wl.cid <> 423 AND wl.cid <> 455 AND wl.cid <> 453 AND wl.cid <> 507 AND wl.cid <> 504 AND wl.cid <> 539 AND wl.cid <> 377 AND wl.cid <> 511 AND wl.cid <> 538 AND wl.cid <> 474 AND wl.cid <> 543 AND wl.cid <> 526 AND wl.cid <> 512 AND wl.cid <> 482 AND wl.cid <> 529 AND wl.cid <> 440 AND wl.cid <> 473 AND wl.cid <> 454 AND wl.cid <> 498 AND wl.cid <> 531 AND wl.cid <> 447 AND wl.cid <> 545 AND wl.cid <> 437 AND wl.cid <> 568 AND wl.cid <> 621 AND wl.cid <> 607 AND wl.cid <> 478 AND wl.cid <> 685 AND wl.cid <> 597 AND wl.cid <> 628 AND wl.cid <> 506 AND wl.cid <> 528 AND wl.cid <> 549 AND wl.cid <> 524 AND wl.cid <> 686 AND wl.cid <> 633 AND wl.cid <> 601 AND wl.cid <> 723 AND wl.cid <> 711 AND wl.cid <> 734 AND wl.cid <> 593 AND wl.cid <> 533 AND wl.cid <> 622 AND wl.cid <> 662 AND wl.cid <> 657 AND wl.cid <> 692 AND wl.cid <> 684 AND wl.cid <> 424 AND wl.cid <> 519 AND wl.cid <> 770 AND wl.cid <> 632 AND wl.cid <> 574 AND wl.cid <> 310 AND wl.cid <> 479 AND wl.cid <> 534 AND wl.cid <> 421 AND wl.cid <> 485 AND wl.cid <> 462 AND wl.cid <> 644 AND wl.cid <> 520 AND wl.cid <> 562 AND wl.cid <> 575 AND wl.cid <> 505 AND wl.cid <> 429 AND wl.cid <> 445 AND wl.cid <> 694 AND wl.cid <> 497 AND wl.cid <> 719 AND wl.cid <> 708 AND wl.cid <> 578 AND wl.cid <> 683 AND wl.cid <> 546 AND wl.cid <> 808 AND wl.cid <> 739 AND wl.cid <> 675 AND wl.cid <> 736 AND wl.cid <> 572 AND wl.cid <> 799 AND wl.cid <> 727 AND wl.cid <> 802 AND wl.cid <> 698 AND wl.cid <> 785 AND wl.cid <> 772 AND wl.cid <> 829 AND wl.cid <> 820 AND wl.cid <> 809 AND wl.cid <> 788 AND wl.cid <> 805 AND wl.cid <> 724 AND wl.cid <> 812 AND wl.cid <> 881 AND wl.cid <> 643 AND wl.cid <> 699 AND wl.cid <> 893 AND wl.cid <> 858 AND wl.cid <> 850 AND wl.cid <> 855 AND wl.cid <> 863 AND wl.cid <> 876 AND wl.cid <> 856 AND wl.cid <> 10901 AND wl.cid <> 860 AND wl.cid <> 456 AND wl.cid <> 741 AND wl.cid <> 616 AND wl.cid <> 862 AND wl.cid <> 707 AND wl.cid <> 701 AND wl.cid <> 868 AND wl.cid <> 10920
and isFree = 1
and (1=1
AND (course_list.ccategory) LIKE '%29%'
AND Webinar_list.wid NOT In (select wid_fk from webinarPackage_Webinars)
)
ORDER BY Webinar_list.webinar_dt desc |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: The multi-part identifier "wl.cid" could not be bound.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:582)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721)
at cfc.courses_cfc$cf.udfCall(/cfc/Courses.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:523)
at application_cfc$cf.udfCall(/Application.cfc:486)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 719: ORDER BY Webinar_list.webinar_dt desc<br>
720: <br>
<b>721: </CFQUERY></b><br>
722: <cfreturn qGetCourseList><br>
723: </cffunction><br>
|
| | codePrintPlain | | string | 719: ORDER BY Webinar_list.webinar_dt desc
720:
721: </CFQUERY>
722: <cfreturn qGetCourseList>
723: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | cfc.courses_cfc$cf.udfCall3(/cfc/Courses.cfc:721) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Courses.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 654: <div id="free_courses" style="display:none;"><br>
655: <!---start free---><br>
<b>656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)></b><br>
657: <!---<cfdump var="#GetCourseList#" label="D">---><br>
658: <CFOUTPUT QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 654: <div id="free_courses" style="display:none;">
655: <!---start free--->
656: <cfset Variables.GetCourseList = application.coursesObject.getCourseList3(HideListList,course_author,course_category,course_search,course_duration)>
657: <!---<cfdump var="#GetCourseList#" label="D">--->
658: <CFOUTPUT QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.continuing_education_cfm$cf.call(/ceu/continuing_education.cfm:656) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/continuing_education.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#"><br>
522: <cfelse><br>
<b>523: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
524: </cfif><br>
525: </cffunction><br>
|
| | codePrintPlain | | string | 521: <cfinclude template="#ARGUMENTS.targetPage#">
522: <cfelse>
523: <cfinclude template="#ARGUMENTS.targetPage#">
524: </cfif>
525: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:523) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 484: <br>
485: <cffunction name="onRequest"><br>
<b>486: <cfargument name="targetPage" type="String" required=true/></b><br>
487: <br>
488: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 484:
485: <cffunction name="onRequest">
486: <cfargument name="targetPage" type="String" required=true/>
487:
488: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
|
| type | |
| where | |