[mapguide-users] text layer with Capital Letter

[btenbroeck]

So, is it possible to bind a layer against a feature that has run
ExecuteSQLQuery via the API? (Did that even make sense?):confused:

I agree with Jason that a sql pass-thru would be great.


JasonBirch wrote:
> 
> Heh.  Another benefit to open source: you get to read the code comments :)
>  
> I remember a few sessions sitting with MapGuide Author on one screen and
> SQL Profiler on another trying to get the syntax right.  It always simple;
> some things (theming?, bounding boxes?) could make it pretty complex. 
> It's been a while though...
>  
> FDO has a similar concept for the database providers, and MapGuide's
> feature service supports this with ExecuteSQLQuery and ExecuteSQLNonQuery
> (or something like that).  
>  
> I wonder if there is any way that we could have an optional "Raw Query
> String" passthrough in the layer's data source definition so that power
> users could totally rock the system.  
>  
> This would allow for some really cool stuff, such as ad-hoc joins, complex
> conditions, groupings (with aggregate functions), unions, and more.  I
> know a few Map power users who would be blown away by this ability also. 
> It would make the results set uneditable, but I think that's a given with
> any kind of derived dataset.
>  
> Jason
>  
> ________________________________
> 
> From: mapguide-users-bounces at lists.osgeo.org on behalf of Andy Morsell
> Sent: Thu 2007-02-01 9:38 PM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] text layer with Capital Letter
> 
> Back on topic, I agree, it would be nice to see support for many more
> standard SQL functions in MapGuide or FDO (probably the better place to
> handle it).  That was one nice thing about MG 6.5, as long as SQL for
> whatever database flavor you were hitting supported it, it generally
> worked.
>  
> 
>  
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/text-layer-with-Capital-Letter-tp8751501s16610p14424665.html
Sent from the MapGuide Users mailing list archive at Nabble.com.