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

        )

      [1] => Array
        (
          [file] => F:\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) = 'weather & environment')
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => F:\rcg.org\site\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) = 'weather & environment')
            )

        )

      [3] => Array
        (
          [file] => F:\globalinclude\content.php
          [line] => 352
          [args] => Array
            (
              [0] => F:\rcg.org\site\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => F:\rcg.org\site\v4\realtruth\rtController.php
          [line] => 83
          [args] => Array
            (
              [0] => F:\globalinclude\content.php
            )

          [function] => include
        )

    )

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

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ')'. in F:\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0017372752{main}(  )...\rtController.php:0
20.15234199072include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.24284386080require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.24294386392db::FullQuery(  )...\subject.php:41
50.24294386440db::Query(  )...\db.php:19
60.24314388024execute
(  )...\db.php:71

)

SQL (string)
F:\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) = 'weather & environment')
Parameters (array)
F:\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
F:\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in F:\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0017372752{main}( )...\rtController.php:0
20.15234199072include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.24284386080require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.24294386392db::FullQuery( )...\subject.php:41
50.24294386440db::Query( )...\db.php:19
60.24454404264getDebugBacktrace( )...\db.php:95
70.24454420696xdebug_print_function_stack ( )...\debug.php:278
Error (object)
F:\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
  [string:Exception:private] => 
  [code:protected] => 42S22
  [file:protected] => F:\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => F:\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => F:\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) = 'weather & environment')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => F:\rcg.org\site\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) = 'weather & environment')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
            )

        )

      [3] => Array
        (
          [file] => F:\globalinclude\content.php
          [line] => 352
          [args] => Array
            (
              [0] => F:\rcg.org\site\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => F:\rcg.org\site\v4\realtruth\rtController.php
          [line] => 83
          [args] => Array
            (
              [0] => F:\globalinclude\content.php
            )

          [function] => include
        )

    )

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

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'. in F:\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0017372752{main}(  )...\rtController.php:0
20.15234199072include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.24284386080require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.24474394648db::FullQuery(  )...\subject.php:56
50.24474394696db::Query(  )...\db.php:19
60.24484396408execute
(  )...\db.php:71

)

SQL (string)
F:\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) = 'weather & environment')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
Parameters (array)
F:\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
F:\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in F:\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0017372752{main}( )...\rtController.php:0
20.15234199072include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.24284386080require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.24474394648db::FullQuery( )...\subject.php:56
50.24474394696db::Query( )...\db.php:19
60.24694412648getDebugBacktrace( )...\db.php:95
70.24694429080xdebug_print_function_stack ( )...\debug.php:278
Subject Search

Tools
Text Size
+
-
Print
RSS
Help
Share

The Real Truth - Subject Search

Weather & Environment

No results found.