var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: geocoder problem
I am new to spatial databases. I am using sql server 2008 and trying to do something like following:
DECLARE @addr nvarchar(256) = '2650 college place, Fullerton, CA, 92831';
DECLARE @addr_as_xy nvarchar(30);
DECLARE @g geography;
SET @addr_as_xy = dbo.geocoder(@addr)
SET @g = geography:: STPointFromText(@addr_as_xy, 4326)
This code basically converts a simple text address into ( X,Y) coordinates system.
Now, It gives me following error:
Msg 4121, Level 16, State 1, Line 4
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.geocoder", or the name is ambiguous.
I really don't know why I just copied and pasted the caode from the microsoft tutorial.
Can anybody help please?
Do you have a stored procedure called dbo.geocoder in your database?
dbo.geocoder will need to be defined as a function for that syntax to work.
If it is a stored procedure, you will need to use output parameters rather than variable assignment.
I meant function - slip of the keyboard