Skip to main content

Hi,

I have got my Nintex workflow which executes a spatial query in SQL Query action.

DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SET @h = geometry::STGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SELECT @g.STUnion(@h).ToString();

this query is not run against any table.

215561_pastedImage_1.png

the result i get is just variable name like following figure. it should be a polygon of coordinates. 

215562_pastedImage_3.png

testError variable gives me following result.

215564_pastedImage_5.png

the query is working fine on SQL Server Management studio instance.

can you please tell me whats going on?

Regards

java guru

My Query is inside {TextStart} & {TextEnd}.


LOOKS LIKE CONNECTION STRING PROBLEM.... 


Reply