my xml torture continues. i need to squirt an sql where clause wrapped in xml at a server, something like:
WHERE a >= 40 AND b < 42 if i push this sql onto the node's xml attributes, cf8's only escaping the last "<", spatialQuery=xmlElemNew(axl,"SPATIALQUERY"); spatialQuery.xmlAttributes["where"]="a >= 40 AND b < 42"; //thanks brianfor the following arrayAppend(axl["arcxml"].xmlChildren[1].xmlChildren[1].xmlChildren,spatialQuery); produces the where clause below which the server chokes on: where="a >= 40 AND b < 42" if i follow "good practices" & xmlFormat() the where clause before i stuff it into the xml attributes, the "&" part of "<" gets double escaped and the server chokes on it: where="a &gt;= 40 AND b &lt; 42" not sure if i'm just my usual xml blind or if this is a bug in cf8. any ideas? thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
