[mapguide-users] No input variables have been defined in SQL statement

[kyedinak]

Hello,

I'd like to add more detail to this issue.

I created a simple view called GIS_PROJECT_COVERAGE in MSSQL 2005 that
contained an id column, a text field, and a Geometry column.
Using MapGuide Maestro, I created a data connection using the sl-king FDO
for MSSQL.
I created a layer that uses the GIS_PROJECT_COVERAGE view feature class from
the MsSqlSpatial created with the KingFDO.
I selected each of the fields from the view as properties to display when
the object is selected.
Also, I used the text field from the view as the tooltip.

What I found out is this.  If I preview the layer and roll over an object
(or select an object), I get this error in the error log:

Error: An exception occurred in FDO component.
        No input variables have been defined in SQL statement

Have I configured something wrong?  I've watched the videos on sl-king.com a
dozen times and I don't think I've missed anything.

With this issue, I'm unable to select any of the SQL data or use the
tooltip.

Regards,
Kirk


kyedinak wrote:
> 
> 
> Hello,
> 
> Here are the basics:
> SQL 2005, MapGuide Open Source (latest version), King FDO for MSSQL
> 
> I've set up database connection using the King FDO.  I created a layer to
> display my points and polygons from the database.  That part works fine. 
> However, when I attempt to select a feature from the layer that uses the
> King FDO, my error log indicates the following:
> 
> Error: An exception occurred in FDO component.
>         No input variables have been defined in SQL statement
>  StackTrace:
>   - MgRenderingServiceHandler.ProcessOperation line 83 file
> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp
>   - MgOpQueryFeatures.Execute line 125 file
> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp
>   - MgServerRenderingService.QueryFeatures line 652 file
> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp
>   - MgServerRenderingService.RenderForSelection line 1326 file
> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp
>   - MgServerSelectFeatures.SelectFeatures line 249 file
> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp
> An exception occurred in FDO component.
> No input variables have been defined in SQL statement
> 
> Any help would be appreciated.
> Kirk
> 
> -- 
> View this message in context:
> http://n2.nabble.com/No-input-variables-have-been-defined-in-SQL-statement-tp1590404p1590404.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/No-input-variables-have-been-defined-in-SQL-statement-tp20740157p20833993.html
Sent from the MapGuide Users mailing list archive at Nabble.com.