[Mapbender-users] Search Rout

[Astrid Emde (WhereGroup)]

Hello Siline,

please add a text column that contains your line_ref_num and search with 
this column instead with line_ref_num.

Mapbender can only handle text. So maybe this will help.

Astrid

Am 2020-01-17 08:34, schrieb Siline:
> Hello,
> 
> I found error, but I still can't fix the error. please help.
> This is error:
> An exception occurred while executing 'SELECT t.`line_id`, 
> t.`line_ref_num`,
> t.`chainage`, t.`line_name`, ST_AsGeoJSON(ST_Transform(t.`line_wkt`,
> ?::int)) as geom FROM gis_line_t1 t WHERE (t.line_ref_num LIKE ?) AND
> (ST_Transform(ST_SetSRID(ST_MakeBox2D(ST_Point(?, ?), ST_Point(?, ?)), 
> ?),
> ST_Srid(t.`line_wkt`)) && t.`line_wkt`)' with params [32648, 
> "%0806T1001%",
> 5579.905, 1088581.723, 1029359.857, 1650396.77, 32648]:
> 
> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an 
> error in
> your SQL syntax; check the manual that corresponds to your MariaDB 
> server
> version for the right syntax to use near '::int)) as geom FROM 
> gis_line_t1 t
> WHERE (t.line_ref_num LIKE '%0806T1001%' at line 1
> 
> Best,
> Siline
> 
> 
> 
> --
> Sent from: 
> http://osgeo-org.1560.x6.nabble.com/mapbender-users-f4220788.html
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant


  -----------------------------------
  Aufwind durch Wissen!
  Qualifizierte Open-Source-Schulungen
  bei der www.foss-academy.com
  -----------------------------------

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn
   Germany

   Fon: +49(0)228 90 90 38 - 22
   Fax: +49(0)228 90 90 38 - 11

   astrid.emde at wheregroup.com
   www.wheregroup.com

   Folgen Sie der WhereGroup auf twitter:
http://twitter.com/WhereGroup_com

Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------