Skip to main content
Nintex Community Menu Bar

Nintex and SQL Spatial query

  • May 22, 2018
  • 2 replies
  • 15 views

Forum|alt.badge.img+2

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

2 replies

Forum|alt.badge.img+2
  • Author
  • May 22, 2018

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


Forum|alt.badge.img+2
  • Author
  • May 22, 2018

LOOKS LIKE CONNECTION STRING PROBLEM....