Having an issue where I'm using PHP 5.5.3 Crashing on IIS 8.5 Windows 2008
R2 using the php_pdo_sqlsrv_55_nts.dll and cakePHP v2.4.3
This problem does not occur outside of CakePHP
Driving me crazy and can't figure out whats going on. There is no specific
error generated fro this. Someone mentioned to place int he SP SET NOCOUNT
ON but it already has that setting.
{
"code": 500,
"url": "\/test\/process",
"name": "SQLSTATE[IMSSP]: The active result for the query contains no
fields.",
"error": {
"errorInfo": [
"IMSSP",
-15,
"The active result for the query contains no fields."
]
}
}
Below is an example of what causes the 500
DECLARE @RC int
DECLARE @CustomerID varchar(15)
DECLARE @FirstName varchar(50)
DECLARE @LastName varchar(50)
DECLARE @PlaceOfWork varchar(100)
DECLARE @Active bit
DECLARE @NoActivityStatement bit
DECLARE @CustomerClassID varchar(15)
DECLARE @CustomerType tinyint
DECLARE @PenaltyType varchar(15)
DECLARE @CollectionExempt bit
DECLARE @ZoneID varchar(15)
DECLARE @Source tinyint
EXECUTE @RC = [dbo].[test_spCreate]
@CustomerID = '{$nextCustomerID}'
,@FirstName = '{$this->request->data['first_name']}'
,@LastName = '{$this->request->data['last_name']}'
,@PlaceOfWork = '{$this->request->data['company']}'
,@Active = '1'
,@NoActivityStatement = '0'
,@CustomerClassID = 'COMMERCIAL'
,@CustomerType = '2'
,@PenaltyType = ''
,@CollectionExempt = '0'
,@ZoneID = ''
,@Source = ''
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
