<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>mmm, it seems it doesnt like you
station."ident_station"</FONT></DIV>
<DIV><FONT size=2>did you try without the " " ?</FONT></DIV>
<DIV><FONT size=2>otherwise do as Fabio D'Ovidio suggested</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ajala.nadia@gmail.com href="mailto:ajala.nadia@gmail.com">nadia
ajala</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 21, 2008 9:49
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cartoweb-users] [cartoweb]Query
in mapfile</DIV>
<DIV><BR></DIV>Hello,<BR>I'm trying, from mapfile, view the result
of query that interrogates two tables of a database postgresql one of which is
spatial (station).<BR><BR>Here is the code:<BR><BR><PRE class=alt2 style="BORDER-RIGHT: 1px inset; PADDING-RIGHT: 6px; BORDER-TOP: 1px inset; PADDING-LEFT: 6px; PADDING-BOTTOM: 6px; MARGIN: 0px; OVERFLOW: auto; BORDER-LEFT: 1px inset; WIDTH: 663px; PADDING-TOP: 6px; BORDER-BOTTOM: 1px inset; HEIGHT: 61px">DATA "the_geom from (SELECT station.* FROM station, plj_datalog WHERE station."ident_station"=Plj_datalog."IDENT_station" AND station."type"='HP' AND plj_datalog."DATE_MES"='2004-04-19')foo using unique ident_station using srid=-1"</PRE><BR>This
query returns a result under pgAdminIII while under cartoweb I have the
following error:<BR><BR><PRE class=alt2 style="BORDER-RIGHT: 1px inset; PADDING-RIGHT: 6px; BORDER-TOP: 1px inset; PADDING-LEFT: 6px; PADDING-BOTTOM: 6px; MARGIN: 0px; OVERFLOW: auto; BORDER-LEFT: 1px inset; WIDTH: 687px; PADDING-TOP: 6px; BORDER-BOTTOM: 1px inset; HEIGHT: 79px"><DIV dir=ltr style="TEXT-ALIGN: left"> </DIV><DIV dir=ltr style="TEXT-ALIGN: left">Mapserver error: Error in getString(): Parsing error near (the_geom from (SELECT station.* FROM station, plj_datalog WHERE station.):(line 279)</DIV></PRE><BR>Thanks
for your help.<BR>
<P>
<HR>
<P></P>_______________________________________________<BR>Cartoweb-users
mailing
list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR></BLOCKQUOTE></BODY></HTML>