11 reputation
2
bio website wooltown.nl
location The Hague, The Netherlands
age 37
visits member for 1 year, 11 months
seen Jul 10 '13 at 16:09

Jun
10
comment Query should yield result but doesn't
I've just figured out that specifying each column and casting ntext columns to text results in return of data. Resulting issue is that ntexts fields are omitted. They are in the array but they're all empty. When I cast to nvarchar I get the first bit. Casting to nvarchar(max) gives me a return with no data.
Jun
6
comment Query should yield result but doesn't
Still no data array(0) { }
Jun
6
comment Query should yield result but doesn't
Yes, this is the result: array(1) { [0]=> array(1) { ["c"]=> string(6) "180783" } }
Jun
6
comment Query should yield result but doesn't
It means that it returns immediately with 0 rows without any error message. There aren't any permission differences between the two tables. I've added the php code to the original post.
Jun
6
awarded  Editor
Jun
6
revised Query should yield result but doesn't
added 548 characters in body
Jun
6
asked Query should yield result but doesn't
Jan
2
awarded  Student
Jan
2
comment Tables not shown in SQL Server Enterprise Manager
As far as I'm concerned not. They are named News, News_Reactions and Gallery.
Jan
2
asked Tables not shown in SQL Server Enterprise Manager
Jan
2
asked SQL Server 2000 export database to csv