<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16705" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>care to give us an example please ?</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=chastagnol.claire@wanadoo.fr
href="mailto:chastagnol.claire@wanadoo.fr">Claire Chastagnol</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> Friday, September 26, 2008 3:24
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cartoweb-users] problems with
complexe sql query</DIV>
<DIV><BR></DIV>
<P
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"
align=left>Hi,<BR><BR>I have some problems with my mapscript and the sql
queries.<BR>Each time I make a query with 2 tables joined, I have this
error:<BR><PRE style="BORDER-RIGHT: 0pt; BORDER-TOP: 0pt; BORDER-LEFT: 0pt; BORDER-BOTTOM: 0pt"><FONT color=#ff0000>Postgresql reports the error as 'ERREUR: find_srid() - couldnt find the corresponding SRID <BR>- is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch?</FONT><BR><BR>It's weird because the queries work fine in postgres and I have no srid problems with the layer when I make a simple query...<BR><BR>Someone know about this problem?<BR>Thanks.<BR>Claire<BR></PRE><BR><BR>
<P></P>
<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>