cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Nintex and SQL Spatial query

Jump to solution

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:Smiley FrustratedTGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SET @h = geometry:Smiley FrustratedTGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SELECT @g.STUnion(@h).ToString();

this query is not run against any table.

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

testError variable gives me following result.

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

can you please tell me whats going on?

Regards

java guru

0 Kudos
Reply
2 Replies
Workflow Hero

Re: Nintex and SQL Spatial query

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: Nintex and SQL Spatial query

Jump to solution

LOOKS LIKE CONNECTION STRING PROBLEM.... 

0 Kudos
Reply