As a follow-up we have a solution. I don't know if it is the best one
or not, but we are going to pass in each significant white space
character as " "
In this SQL example below, it appears to work:
DECLARE @xml_data xml
SET @xml_data = '
<accounting_batch_layout>
<accounting_batch_layout_column
static_content="       asdf">
</accounting_batch_layout_column>
</accounting_batch_layout>
'
DECLARE @idoc AS int
DECLARE @temp_layout_column TABLE
( static_content varchar(255) )
SET @xml_data = CONVERT(xml,@xml_data,1)
EXEC sp_xml_preparedocument @idoc OUTPUT, @xml_data
INSERT INTO @temp_layout_column
( static_content)
SELECT * FROM OPENXML
(@idoc,'/accounting_batch_layout/accounting_batch_layout_column') WITH
( static_content varchar(255))
EXEC sp_xml_removedocument @idoc
SELECT '*' + static_content FROM @temp_layout_column
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:286991
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
