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...
Learn a little bit about the new Pastebin.com on our help page. hide message
By Yancho on the 4th of Dec 2007 02:55:18 PM Download | Raw | Embed | Report
  1. $source = "select give_source('POINT(".$sp.")',1000,200)";
  2. $target = "select give_target('POINT(".$ep.")',1000,200)" ;
  3. $sql = "
  4.  
  5.        SELECT gid, astext(the_geom) as wkt, length(the_geom) AS length
  6.        FROM shootingstar_sp
  7.        ('streets',
  8.          (
  9.          select gid from streets where
  10.          source = ( $source )
  11.          limit 1
  12.          )
  13.        ,
  14.        
  15.          (
  16.          select gid from streets where
  17.          target = ( $target )
  18.          limit 1
  19.          
  20.          )
  21.        ,
  22.        5000,
  23.        'length',
  24.        true,
  25.        true
  26.        );
  27. ";
Submit a correction or amendment below. Make A New Post
To highlight particular lines, prefix each line with @h@
Syntax highlighting:
Post expiration:
Post exposure:
Name / Title:
Email: