Even though I can't use SQL Server Stored Procedure in SQL view, I figured out
how to use table-valued functions which worked great! Also,I can pass
multi-value parameters to a function.
Thanks!
Meichun
From: Meichun Li <pcloudy2...@yahoo.com>
To: "geoserver-users@lists.sourceforge.net"
<geoserver-users@lists.sourceforge.net>
Sent: Wednesday, January 30, 2013 4:18 PM
Subject: Passing multiple values to parameters / SQL Server Stored Procedure
Hi,
I need to do a query for a map layer, and pass mulitple values to parameters.
For example,
Select * from VIEW where LocationID in (1, 3, 4, 5, 11)
The values of locationID is dynamic, it mabye one ID, two IDs or many IDs.
Is it doable to set up parameters like this?
Also, is it doable to use a SQL server stored Procedure in GeoServer SQL view?
I tried something like "EXEC StoredProcedure_Name" but I got errors.
Thanks,
Meichun
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
