Thanks All!<br><br>Now it works!<br><br><div><span class="gmail_quote">2007/4/13, Mark Cave-Ayland <<a href="mailto:mark.cave-ayland@ilande.co.uk">mark.cave-ayland@ilande.co.uk</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Fri, 2007-04-13 at 14:55 +0200, Gerald Baumgartner wrote:<br>> I have renamed the tablename, but now there are other errors:<br>><br>> Warning: pg_query() [function.pg-query]: Query failed: ERROR: column<br>> "date_start_fahrt" is of type date but expression is of type integer
<br>> at character 36 HINT: You will need to rewrite or cast the expression.<br>> in C:\ms4w\Apache\htdocs\GpsDaten\GPS_Daten_einlesen.php on line 103<br>><br>> Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid
<br>> input syntax for type numeric: "" in C:\ms4w\Apache\htdocs\GpsDaten<br>> \GPS_Daten_einlesen.php on line 112<br>><br>><br>> php Code:<br>><br>> $timestamp=time();<br>> $datum=date("d/m/y",$timestamp);
<br>><br>> if($z_eintraege==2)<br>> {<br>> $sql_befehl="INSERT INTO<br>> fahrtenbuchtabelle(fid,date_start_fahrt,date_insert,strecke) VALUES<br>> ($z_eintraege,$datum,$datum,GeometryFromText('LINESTRING($breitengrad1
<br>> $laengengrad1, $breitengrad $laengengrad)',4326))";<br>> $res=pg_query($connection,$sql_befehl);<br>> $sql_befehl_select="SELECT max(FID) as fid from<br>> fahrtenbuchtabelle";
<br>> $res_fid=pg_query($connection,$sql_befehl_select);<br>> $fahrtnummer=pg_result($res_fid,"fid");<br>><br>> }<br>> if($z_eintraege>2)<br>> {<br>> $sql_befehl_append="UPDATE fahrtenbuchtabelle SET
<br>> strecke=AddPoint(strecke,GeomFromText('POINT($breitengrad<br>> $laengengrad)',4326)) where fid='$fahrtnummer'";<br>> $result=pg_query($connection,$sql_befehl_append);<br>> }
<br>><br>> Gerald<br><br><br>Hi Gerald,<br><br>As Regina points out, you need to quote the date field with apostrophes<br>in the VALUES clause since the date needs to be passed in as a string.<br><br>Also a word of warning: you should look very carefully at your code; by
<br>creating strings using "s and including variables as $var, it is<br>extremely likely that your code is vulnerable to an SQL injection attack<br>if register_globals is enabled and your variables are being passed in as
<br>CGI parameters to your PHP page.<br><br><br>Kind regards,<br><br>Mark.<br><br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br>