Dave, THank you. That is what I was looking for. I think I can figure it out from here. I need to learn xslt and all that, but I was stuck trying to figure out how to get that info in there using the CFXML tag. Easy as inserting it in my root element as per your example.
Thanks again, off to play with this some more. On 8/24/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > In excel, you get a prompt: the specified xml source does not > > refer to a schema. Excel will create a schema based on the > > xml source data. > > > > Can I somewho provide that schema automatically? > > Sure: > > <permitinfo xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance" > xsi:noNamespaceSchemaLocation="http://urlpath/to/yourexcelschema.xsd"> > .... > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:287097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4