Can you store the clause as CDATA, or is that going to make using it later on too difficult?
On 9/12/07, Paul Hastings <[EMAIL PROTECTED]> wrote: > 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. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
