joojinho / brig Goto Github PK

What steps will reproduce the problem?
1. Create an MSSQL Server 2008 table with a varchar column (mine is varchar(20) 
in addition to a geometry column
2. Attempt to query based on the varchar column (I'm also doing a bounding box)

What is the expected output? What do you see instead?

I expect the query to be made, instead I get the following exception thrown:
[Microsoft][SQL Server Native Client 11.0][SQL Server]The data types varchar 
and ntext are incompatible in the equal to operator. [Microsoft][SQL Server 
Native Client 11.0][SQL Server]Statement(s)

What version of the product are you using? On what operating system?
Windows 7 SP1
MSSQLServer 2008 Spatial
Brig 1306


Please provide any additional information below.

Apologies if you can do this, I was unable to find it in the documentation.

What steps will reproduce the problem?
1. Create some data which is for multiple years, say 2013 and 2014
2. Try and query based on this

What is the expected output? What do you see instead?

To match data which is in both 2013 and 2014.  Instead I can only get data for 
one year.

What version of the product are you using? On what operating system?
brig 1306

Please provide any additional information below.

  tbl.query_columns.push_back("Year");
  tbl["Year"]->query_value = 2013;
  tbl["Year"]->query_value = 2014;

This just overwrites the query_value with the last one.  You almost want to 
have query_value as a vector which you push back into, with them all been ORs.