Subdomain Posts
Progress | 3 days ago
None | 7 days ago
Java | 11 days ago
REBOL | 12 days ago
Perl | 13 days ago
MySQL | 697 days ago
MySQL | 706 days ago
SQL | 737 days ago
SQL | 737 days ago
SQL | 737 days ago
Recent Posts
None | 15 sec ago
None | 22 sec ago
None | 58 sec ago
None | 1 min ago
None | 1 min ago
None | 1 min ago
C++ | 1 min ago
mIRC | 1 min ago
None | 1 min ago
Java 5 | 1 min ago
Sitereport
Find cool info about any domain on the internet?
visit sitereport
Free Subdomains
Want a pastebin.com sub-domain for your community?
learn more...
What is pastebin?
Pastebin is a website that hosts all your text & code on dedicated servers for easy sharing.
learn more...
By Yancho on the 4th of Dec 2007 02:55:18 PM
Download |
Raw |
Embed |
Report
$source = "select give_source('POINT(".$sp.")',1000,200)";
$target = "select give_target('POINT(".$ep.")',1000,200)" ;
$sql = "
SELECT gid, astext(the_geom) as wkt, length(the_geom) AS length
FROM shootingstar_sp
('streets',
(
select gid from streets where
source = ( $source )
limit 1
)
,
(
select gid from streets where
target = ( $target )
limit 1
)
,
5000,
'length',
true,
true
);
";
Submit a correction or amendment below.
Make A New Post