Share Pastebin
Guest
Public paste!

Yancho

By: a guest | Dec 4th, 2007 | Syntax: PHP | Size: 0.60 KB | Hits: 131 | Expires: Never
Copy text to clipboard
  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. ";