That was spot on. Thank you very much.
I now want to use aparameterized query like this
SELECT
"Regions"."gid" as rgid,
"Regions"."name" as rname,
district_borough_unitary_region.gid,
district_borough_unitary_region."name",
district_borough_unitary_region.area_code,
district_borough_unitary_region.descriptio,
district_borough_unitary_region.file_name,
district_borough_unitary_region."number",
district_borough_unitary_region.number0,
district_borough_unitary_region.unit_id,
district_borough_unitary_region.polygon_id,
district_borough_unitary_region.code,
district_borough_unitary_region.hectares,
district_borough_unitary_region.area,
district_borough_unitary_region.type_code,
district_borough_unitary_region.descript0,
district_borough_unitary_region.type_cod0,
district_borough_unitary_region.descript1,
district_borough_unitary_region.the_geom
FROM
public."Regions" INNER JOIN
public.district_borough_unitary_region
ON ST_Intersects("Regions".the_geom,district_borough_unitary_region.the_geom)
where "Regions"."gid" = %grid%
But am getting an error
Failed to create SQL view: ERROR: syntax error at or near ")"
Position: 1019
Is this how to use the parameterized view or am doing something wrong?
Regards
farouk A
--- On Thu, 9/9/10, Justin Deoliveira <[email protected]> wrote:
From: Justin Deoliveira <[email protected]>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: "farouk alhassan" <[email protected]>
Cc: [email protected]
Date: Thursday, 9 September, 2010, 10:06
Hi Farouk,
I think you just have to remove the ";" after the statement.
-Justin
On Thu, Sep 9, 2010 at 8:44 AM, farouk alhassan <[email protected]> wrote:
Hi,
I am trying to enter the following sql into the new SQL View Editor.
SELECT
"Regions"."gid" as rgid,
"Regions"."name" as rname,
district_borough_unitary_region.gid,
district_borough_unitary_region."name",
district_borough_unitary_region.area_code,
district_borough_unitary_region.descriptio,
district_borough_unitary_region.file_name,
district_borough_unitary_region."number",
district_borough_unitary_region.number0,
district_borough_unitary_region.unit_id,
district_borough_unitary_region.polygon_id,
district_borough_unitary_region.code,
district_borough_unitary_region.hectares,
district_borough_unitary_region.area,
district_borough_unitary_region.type_code,
district_borough_unitary_region.descript0,
district_borough_unitary_region.type_cod0,
district_borough_unitary_region.descript1,
district_borough_unitary_region.the_geom
FROM
public."Regions" INNER JOIN
public.district_borough_unitary_region
ON ST_Intersects("Regions".the_geom,district_borough_unitary_region.the_geom)
where "Regions"."gid" = 1;
When I run it I get this error
Failed to create SQL view: ERROR: syntax error at or near ";"
Position: 1027
but the same sql works perfectly well in pgAdmin III.
Getting rid of the where clause fixes the problem but I really need to filter
the results since the dataset is too large.
Any Ideas what I may be doing wrong?
Thanks
Farouk A
--- On Thu, 9/9/10, farouk alhassan <[email protected]> wrote:
From: farouk alhassan <[email protected]>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: [email protected]
Date: Thursday, 9 September, 2010, 4:16
Hi Justin,
Thanks for the tip. I deleted my whole tomcat installation and installed a new
version and deployed
new version of the geoserver war file and the links now appear.
May have been caused by traces of my previous geoserver war still being held on
to by tomcat.
Thanks for the help. Very much appreciated
Regards
Farouk A
--- On Wed, 8/9/10, Justin Deoliveira <[email protected]> wrote:
From: Justin Deoliveira <[email protected]>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: [email protected]
Date: Wednesday, 8 September, 2010, 23:41
Hi Farouk,
It is appreciated if you
can keep all correspondance on the public list. Thanks.
So this seems strange. If you have a postgis store setup and are not seeing the
links when you add a new layer it leads me to believe there is an issue with
the installation. Perhaps some old versions of the geoserver jars around.
Can you navigate to the WEB-INF/lib directory of the geoserver installation and
verify that only 2.1-beta jars are present. What type of setup are you running?
Windows installer? platform independent binary?
On Wed, Sep 8, 2010 at 7:55 PM, farouk alhassan <[email protected]> wrote:
Hi
I'm trying with PostGIS.
Regards
Farouk A
--- On Wed, 8/9/10, Justin Deoliveira <[email protected]> wrote:
From: Justin Deoliveira <[email protected]>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: "farouk alhassan" <[email protected]>
Cc: [email protected]
Date: Wednesday, 8 September, 2010, 9:31
Hi Farouk,
Are you trying with arcsde? Or another database?
On Wed, Sep 8, 2010 at 7:06 AM, farouk alhassan <[email protected]> wrote:
Hi
I am also trying to do the same thing but could not find any of the links
mentioned in the article.
I'm using this document as a guide
http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html
Let me know if you make any progress on it.
Regards
Farouk A
--- On Wed, 8/9/10, [email protected]
<[email protected]> wrote:
From: [email protected] <[email protected]>
Subject: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL
view
To: [email protected]
Date: Wednesday, 8 September, 2010, 3:16
Hi All,
I have installed GeoServer 2.1-beta1
onto my local PC to try out the new SQL views.
When I go to add new ArcSDE layers,
at the bottom of the page I have the option to create new feature type,
but there is nothing to allow me to configure a new SQL view.
Is there something I missed when installing,
or is this option only available to some databases?
Cheers,
Sonya
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin DeoliveiraOpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Justin DeoliveiraOpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin DeoliveiraOpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
