<SCRIPT language=VBScript>
Const adPersistXML = 1
function CreateXML()
Set Rs = CreateObject( "ADODB.Recordset" )
GetConnectionString = _
"Provider=SQLOLEDB;" & _
"Data Source=localhost;" & _
"Initial Catalog=lightbox;" & _
"User ID=sa;" & _
"Password=;"
Rs.Open "select * from 商品マスタ", GetConnectionString
Rs.Save "save.xml", adPersistXML
Rs.Close
Set Rs = Nothing
end function
</SCRIPT>
<HTML>
<HEAD>
<TITLE>XML</TITLE>
</HEAD>
<BODY>
<INPUT type=button value="実行" onClick='Call CreateXML()'>
</BODY>
</HTML>
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30'>
<s:AttributeType name='c0' rs:name='コード' rs:number='1' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='4' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='c1' rs:name='商品名' rs:number='2' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50'/>
</s:AttributeType>
<s:AttributeType name='c2' rs:name='単価' rs:number='3' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row c0='0001' c1='パソコン' c2='100600'/>
<z:row c0='0002' c1='テレビ' c2='50600'/>
</rs:data>
</xml>