A PHP Error was encountered

Severity: 8192

Message: Function create_function() is deprecated

Filename: geshi/geshi.php

Line Number: 4698

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4698
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4621
Function: _optimize_regexp_list_tokens_to_string

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 1655
Function: optimize_regexp_list

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2029
Function: optimize_keyword_group

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2168
Function: build_parse_cache

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/Process.php
Line: 45
Function: parse_code

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/models/Pastes.php
Line: 517
Function: syntax

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 693
Function: getPaste

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

Re: Untitled - Stikked
Stikked

Re: Untitled

From Teeest, 9 Years ago, written in SQL.
This paste is a reply to

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: view/view.php

Line Number: 25

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/themes/geocities/views/view/view.php
Line: 25
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 173
Function: include

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 43
Function: _ci_load

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 700
Function: view

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

">

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: view/view.php

Line Number: 25

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/themes/geocities/views/view/view.php
Line: 25
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 173
Function: include

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 43
Function: _ci_load

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 700
Function: view

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

from

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: view/view.php

Line Number: 25

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/themes/geocities/views/view/view.php
Line: 25
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 173
Function: include

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 43
Function: _ci_load

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 700
Function: view

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

- view diff
URL http://geopaste.scratchbook.ch/view/cef1a402
Embed
Download Paste or View Raw
  1. BEGIN tran
  2.  
  3. DECLARE @customers TABLE (pkGUID uniqueidentifier, sCustomerID VARCHAR(MAX), sCustomerName VARCHAR(MAX))
  4. INSERT INTO @customers SELECT
  5. pkGUID, sCustomerID, sCustomerName FROM tblOMCustomer
  6. WHERE isnumeric(sCustomerID) = 1
  7.  
  8. SELECT
  9.             c.sCustomerID AS Customer,
  10.                         c.sCustomerID + '-' + RIGHT('00'+ CONVERT(VARCHAR,l.nLocationID),3) AS LocationID,
  11.                         l.sLocationName AS Location,
  12.                         a.sAddress1 AS Adress,
  13.                         a.sAddress2 AS Adress2,
  14.                         a.sZip4 AS Zip,
  15.                         a.sCity AS City,
  16.                         a.sCountry AS Country,
  17.                         av.sAddress1 AS VisitAdress,
  18.                         av.sAddress2 AS VisitAdress2,
  19.                         av.sZip AS VisitZip,
  20.                         av.sCity AS VisitCity,
  21.                         av.sCountry AS VisitCountry
  22.                        
  23. FROM tblOMLocation l
  24. JOIN tblOMAddress a ON l.fkPostalAddress = a.pkGUID
  25. LEFT OUTER JOIN tblOMAddress av ON l.fkVisitAddress = av.pkGUID
  26. JOIN @customers c ON l.fkCustomer = c.pkGUID
  27.  
  28. WHERE CAST(c.sCustomerID AS INT) = '300840'
  29. AND l.nModelState NOT IN (4,11)
  30. AND l.nLocationType != '2'
  31.  
  32. ORDER BY c.sCustomerID, LocationID
  33.  
  34. ROLLBACK tran

Reply to "Re: Untitled"