Error (object)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
  [string:Exception:private] => 
  [code:protected] => 42000
  [file:protected] => D:\home\site\wwwroot\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 19
          [function] => Query
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
          [line] => 41
          [function] => FullQuery
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
            )

        )

      [3] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\content.php
          [line] => 360
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\rtController.php
          [line] => 84
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\globalinclude\content.php
            )

          [function] => include
        )

    )

  [previous:Exception:private] => 
  [errorInfo] => Array
    (
      [0] => 42000
      [1] => 102
      [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
    )

)

SQL (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
Parameters (array)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95

#0 D:\home\site\wwwroot\globalinclude\classes\db.php:19
Query(
string {SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject }
array {Array()}
object {PDO Object()}
boolean {1}
)
#1 D:\home\site\wwwroot\v4\realtruth\templates\subject.php:41
FullQuery(
string {SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject }
)
#2 D:\home\site\wwwroot\globalinclude\content.php:360
require(
string {D:\home\site\wwwroot\v4\realtruth\templates\subject.php}
)
#3 D:\home\site\wwwroot\v4\realtruth\rtController.php:84
include(
string {D:\home\site\wwwroot\globalinclude\content.php}
)
Error (object)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
  [string:Exception:private] => 
  [code:protected] => 42S22
  [file:protected] => D:\home\site\wwwroot\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 19
          [function] => Query
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
          [line] => 56
          [function] => FullQuery
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
            )

        )

      [3] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\content.php
          [line] => 360
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\rtController.php
          [line] => 84
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\globalinclude\content.php
            )

          [function] => include
        )

    )

  [previous:Exception:private] => 
  [errorInfo] => Array
    (
      [0] => 42S22
      [1] => 207
      [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
    )

)

SQL (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
Parameters (array)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95

#0 D:\home\site\wwwroot\globalinclude\classes\db.php:19
Query(
string {SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject }
array {Array()}
object {PDO Object()}
boolean {1}
)
#1 D:\home\site\wwwroot\v4\realtruth\templates\subject.php:56
FullQuery(
string {SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject }
)
#2 D:\home\site\wwwroot\globalinclude\content.php:360
require(
string {D:\home\site\wwwroot\v4\realtruth\templates\subject.php}
)
#3 D:\home\site\wwwroot\v4\realtruth\rtController.php:84
include(
string {D:\home\site\wwwroot\globalinclude\content.php}
)
Subject Search

Subject Search

No results found.