I am working on Mssql server and get this error
<h1>PDOException</h1>
<p>SQLSTATE[IMSSP]: The active result for the query contains no fields.</p>
, when I use read() or readAll().Here is my code
$sql = " DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @dateDiff int
SELECT @StartDate = '$start_day', @EndDate = '$end_day'
SELECT @dateDiff = DATEDIFF(DAY, @StartDate, @EndDate)
DECLARE @Number TABLE
(
Number INT IDENTITY(1,1) PRIMARY KEY CLUSTERED
)
WHILE COALESCE(SCOPE_IDENTITY(), 0) <= @dateDiff
BEGIN
INSERT @Number DEFAULT VALUES
END
DECLARE @MESSAGES TABLE
(
day DATETIME
)
BEGIN
INSERT @MESSAGES
SELECT DATEADD(DAY, N.Number, @StartDate)
FROM @Number as N
WHERE N.Number <= @dateDiff
ORDER BY N.Number
END
BEGIN
SELECT
cast( DATEPART(dayofyear,(t.day)) as int) as DayOfYear,
cast( DATENAME ( month , (t.day) ) as nchar) as thisMonth,
cast ( DATENAME ( day , (t.day) ) as int) as thisDay,
cast ( COALESCE(sum(DATEDIFF(minute, d.login_time, isnull(d.logout_time, d.last_keypress) ) ),0) as int) as TotalMinutes
FROM @MESSAGES t
LEFT OUTER JOIN echo_logins d on DATEPART(dayofyear,(d.Login_Time)) = DATEPART(dayofyear,(t.day))
GROUP BY DATEPART(dayofyear,(t.day)), DATENAME( month , (t.day) ), DATENAME ( day , (t.day) )
END
";
$reader = Yii::app()->db->createCommand($sql)->query();
do
{
if ( $reader->rowCount > 1 ){
$test = $reader->readAll();
}
}while ( $reader->nextResult() ) ;