Spatial AdobeColdFusion, Flex, AIR and spatial applications (maps and more)...Testing SyntaxHighlighter (Code colouring)- November 1, 2007 CF test Set component variables variables.appConfig = 0; variables.modelGlueConfig = 0; variables.rolePermissions = structnew(); variables.userIDWithAdminRights = ""; cfset test (XML close) cfset test (non-XML close)http://www.mariposa.com.au/arcims/2007/11/mtcblock_test.cfm Spatial SQL Simple Feature Access SQL functions- November 1, 2007 ESRI's new ST_GEOMETRY data type for Oracle offers a total of 88 functions. For SQL select statements, their are basically two groups of functions: ones that you can use in a select clause; and others you can use in a where clause. These functions are in additional to being able to use all the standard SQL functions (sum,count etc) so you can mix spatial criteria with traditional SQL (ESRI's webhelp published a full list of ST_GEOMETRY functions). An example of the select clause functions...http://www.mariposa.com.au/arcims/2007/11/gis_sql_simple_feature_access.cfm |