<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><br>
I found the cause of my last problem:<br>
<br>
pg_fetch_result(): Bad column offset specified in line 72<br>
<br>
<br>
<br>
$sql = "SELECT id, the_geom, <br>
distance(the_geom,
GeometryFromText('POINT(".$lonlat[0]." ".$lonlat[1].")', 27492))
AS dist <br>
FROM vertices_tmp <br>
ORDER BY dist LIMIT 1";<br>
<br>
$query = pg_query($con,$sql); <br>
<br>
$edge['id'] = pg_fetch_result($query, 0, 0); <br>
$edge['source'] = pg_fetch_result($query, 0, 1); <br>
$edge['target'] = pg_fetch_result($query, 0, 2); <br>
$edge['the_geom'] = pg_fetch_result($query, 0, 3);
--------------------->here<br>
<br>
<br>
Maybe because i'm trying to work with points of table
vertices_tmp.<br>
Do you know want i have wrong?<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Em 11-07-2012 11:14, Daniel Kastl escreveu:<br>
</div>
<blockquote
cite="mid:CABXBSH--ys-eiFP+qOtYGD+EXSo=2zqw8sgwKs9tvwGxiweEnw@mail.gmail.com"
type="cite">Hi Pedro,
<div><br>
</div>
<div>When comparing your line with the workshop source on GitHub
[1], I see that you added "password" to the connection string.</div>
<div>I think you're missing a "." before "Password" and are you
sure the syntax is correct and it needs to be a capital "P"?</div>
<div><br>
</div>
<div>Daniel</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>[1] <a moz-do-not-send="true"
href="https://github.com/pgRouting/workshop/blob/master/web/php/pgrouting.php">https://github.com/pgRouting/workshop/blob/master/web/php/pgrouting.php</a><br>
<br>
<div class="gmail_quote">On Wed, Jul 11, 2012 at 10:47 AM, Pedro
Costa <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><br>
Hi Daniel<br>
<br>
<br>
In apache log i found this error:<br>
<br>
[error] an unknown filter was not added: PHP <br>
[error] [client my client] PHP Parse error: syntax
error, unexpected T_CONSTANT_ENCAPSED_STRING in 'my
domain'/routing/php/pgrouting.php on line 42, referer: <br>
<br>
<br>
Line 42 is my db data:<br>
<br>
<br>
// Connect to database<br>
$con = pg_connect("dbname=".PG_DB." host=".PG_HOST."
user=".PG_USER "Password=".PG_PASS);<br>
<br>
<br>
<br>
do you know what is the problem?<br>
<br>
<br>
Thanks
<div class="im"><br>
<br>
<br>
<br>
<br>
<br>
Em 10-07-2012 17:12, Daniel Kastl escreveu:<br>
</div>
</div>
<blockquote type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><br>
server: <a moz-do-not-send="true"
href="http://pastebin.com/tdWDgj54"
target="_blank">http://pastebin.com/tdWDgj54</a><br>
<br>
</div>
</div>
</blockquote>
<div>
<div class="h5">
<div><br>
</div>
<div>You're missing quotation in line 11 ...
that's when the code highlighting becomes weird.</div>
<div><br>
</div>
<div>Otherwise, try to output the SQL queries to
the server log and then run the query in the
terminal.</div>
<div>Like this you can see if your query is OK or
not.</div>
<div><br>
</div>
<div>Daniel</div>
<div> </div>
</div>
</div>
</div>
<div>
<div class="h5"> <br>
<br clear="all">
<div><br>
</div>
-- <br>
<span
style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic
UG & Georepublic Japan<br>
eMail: <a moz-do-not-send="true"
href="mailto:daniel.kastl@georepublic.de"
style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a moz-do-not-send="true"
href="http://georepublic.de/"
style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span><br>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<div class="im">
<pre>_______________________________________________
Pgrouting-users mailing list
<a moz-do-not-send="true" href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</div>
</blockquote>
<br>
<br>
</div>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span
style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic
UG & Georepublic Japan<br>
eMail: <a moz-do-not-send="true"
href="mailto:daniel.kastl@georepublic.de"
style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a moz-do-not-send="true" href="http://georepublic.de/"
style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pgrouting-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</blockquote>
<br>
<br>
</body>
</html>