Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-09 Thread farouk alhassan
rror 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 wrote: From: Justin Deoliveira Subject: Re: [Geoserver-users] GeoServer

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-09 Thread Justin Deoliveira
> 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. >

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-08 Thread farouk alhassan
be doing wrong? Thanks Farouk A --- On Thu, 9/9/10, farouk alhassan wrote: From: farouk alhassan Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view To: geoserver-users@lists.sourceforge.net Date: Thursday, 9 September, 2010, 4:16 Hi Justin, Thanks fo

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-08 Thread farouk alhassan
. Very much appreciated Regards Farouk A --- On Wed, 8/9/10, Justin Deoliveira wrote: From: Justin Deoliveira Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view To: geoserver-users@lists.sourceforge.net Date: Wednesday, 8 September, 2010, 23:41 Hi Farouk, It is

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-08 Thread Justin Deoliveira
Hi > I'm trying with PostGIS. > > Regards > Farouk A > > --- On *Wed, 8/9/10, Justin Deoliveira * wrote: > > > From: Justin Deoliveira > Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a > new SQL view > To: "farouk alhassan&quo

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-08 Thread Justin Deoliveira
> From: sonya.dow...@dpipwe.tas.gov.au > Subject: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new > SQL view > To: geoserver-users@lists.sourceforge.net > Date: Wednesday, 8 September, 2010, 3:16 > > > > Hi All, > > I have installed GeoServer 2.1-beta1 o

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-08 Thread Justin Deoliveira
Hi Sonya, Yes it should have been mentioned that this functionality is only available for databases that connect via regular jdbc. Currently postgis, oracle, db2, mysql, etc... Arcsde is not included in those. -Justin On Wed, Sep 8, 2010 at 4:16 AM, wrote: > > Hi All, > > I have installed GeoS

Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-07 Thread farouk alhassan
, 8/9/10, sonya.dow...@dpipwe.tas.gov.au wrote: From: sonya.dow...@dpipwe.tas.gov.au Subject: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view To: geoserver-users@lists.sourceforge.net Date: Wednesday, 8 September, 2010, 3:16 Hi All, I have installed GeoServer 2.1-

[Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL view

2010-09-07 Thread Sonya . Downie
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 whe