Yii, SQL Server query error

Question

Work with SQL Server, using pdo_sqlsrv driver (PHP 5.4)

In my DB I have column with varbinary type and size of 7584.

When I try to get value from this column I get this error

Invalid sql_display_size in G:\..\..\..\framework\yiilite.php on line 8836

Here is the query:

DECLARE @item varbinary(1728); SET @item = (SELECT Inventory FROM Character WHERE Name='CharName'); print @item;

In this case I get exactly that size that I need. It work in normal php query (not PDO) and in SQL Server Management Studio.

When I run this code in Yii:

$query = "DECLARE @item varbinary(1728); SET @item = (SELECT Inventory FROM Character WHERE Name='CharName'); print @item";
$command=Yii::app()->db->createCommand($query)->query();
$command->read();

I get this:

SQLSTATE[IMSSP]: The active result for the query contains no fields.

I think that I built a wrong query.

My question is, How to run a query like this in Yii ?

What if you just put this in your query : DECLARE @item varbinary(1728);SELECT Inventory FROM Character WHERE Name='CharName'; — jazzytomato
– jazzytomato, Commented Dec 3, 2012 at 16:46
I tried this and it picks me everything in the column. Error "Fatal error: Invalid sql_display_size in C:\..\framework\yiilite.php on line 8836" — smokeelow
– smokeelow, Commented Dec 3, 2012 at 17:07

icc97 · Accepted Answer · 2016-11-28 15:00:13Z

1

I resolved this issue. The PDO_SQLSRV driver works perfectly with MS SQL Server on Windows.

The problem was that I was trying to execute the wrong query:

$query = "DECLARE @item varbinary(1728); SET @item = (SELECT Inventory FROM Character WHERE Name='CharName'); print @item";
$command=Yii::app()->db->createCommand($query)->query();

Working query:

$query = "DECLARE @items varbinary(max);SET @items = (SELECT Inventory FROM Character WHERE Name='$id');Select @items";
            $getI = Yii::app()->db->createCommand($query)->queryScalar();

That's all.

edited Nov 28, 2016 at 15:00

icc97

13.1k9 gold badges84 silver badges99 bronze badges

answered Feb 3, 2013 at 15:33

smokeelow

1151 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DarkMukke · Accepted Answer · 2012-12-21 09:20:26Z

0

Your question was already answered on the Yii Forums :

Edit: A quick search on google provides you with tons of valid answers: The most valid answer is that the mssql PDO driver is full of bugs, you could use the ODBC driver which works less buggy.

edited Dec 21, 2012 at 9:20

answered Dec 21, 2012 at 8:54

DarkMukke

2,4891 gold badge24 silver badges32 bronze badges

2 Comments

Artemix Over a year ago

Lone link is considered a poor answer since it is meaningless by itself and target resource is not guaranteed to be alive in the future. Please try to include at least summary of information you are linking to.

DarkMukke Over a year ago

yep it was poor, but if you would have checked the link i provided it is even worse that the guy answered his own question but didn't post it in here, so yeh poor answer for a poor question..

Collectives™ on Stack Overflow

Yii, SQL Server query error

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related