[mapserver-users] SQL in mapserver calls via ArcSDE?

[Russell McOrmond]

   I'm aware that it is possible to be more specific with the SQL 
statements made directly to Oracle Spacial or PostGIS, and I'm wondering 
if something similar is possible when requesting data through ArcSDE.

   This is ArcSDE managing an Oracle database.  I want to do something like

   SELECT *,TO_CHAR(thenumber) AS thenumstring FROM ...

   The idea is to be able to use Oracle functions to manipulate data that 
is being requested and returned from a getFeatureInfo request.

   I believe with PostGIS and Oracle this is done within the DATA parameter 
to a layer, but the descriptions of an SDE don't suggest this is possible. 
Looking at the source it isn't clear how to manipulate the SQL statement 
that is being sent.

-- 
  Russell McOrmond, Internet Consultant: <http://www.flora.ca/>
  Please help us tell the Canadian Parliament to protect our property
  rights as owners of Information Technology. Sign the petition!
  http://digital-copyright.ca/petition/ict/     http://KillBillC61.ca

  "The government, lobbied by legacy copyright holders and hardware
   manufacturers, can pry control over my camcorder, computer,
   home theatre, or portable media player from my cold dead hands!"