Microsoft.XMLDOM problem with VBScript

Hi all,

I have this XML:

<?xml version="1.0" encoding="utf-8" ?>
<response xmlns="http://schemas.persony.com/wc2/rest/1.0">
	<member>
		<member_id>[MEMBER_ID]</member_id>
		<login>[LOGIN]</login>
		<password>[PASSWORD]</password>
		<first_name>[FIRST_NAME]</first_name>
		<last_name>[LAST_NAME]</last_name>
		<email>[EMAIL]</email>
		<permission>[PERMISSION]</permission>
		<create_date>[CREATE_DATE]</create_date>
		<audio_conference>
			<number>[CONF_NUM]</number>
			<moderator_code>[CONF_MCODE]</moderator_code>
			<attendee_code>[CONF_PCODE]</attendee_code>
		</audio_conference>
		<group_id>[GROUP_ID]</group_id>
		<active>[ACTIVE]</active>
		<license_code>[LICENSE_CODE]</license_code>
	</member>
</response>

Code (markup):

I am trying to retrieve the password with this code:

    set objXML = Server.CreateObject("Microsoft.XMLDOM") 
    set objLst = Server.CreateObject("Microsoft.XMLDOM") 
    objXML.async = false 
    
    xml = HTTPGet(url, "") 'XML is returned from the server
    
    objXML.LoadXML(xml)
    
    set objLst = objXML.SelectNodes("//member") ' I have also tried "//member/password" but no change.
    for i = 0 to (objLst.length - 1) 
        if objLst.item(i).nodeName = "password" then
            getMemberPassword = objLst.item(0).text
        end if
    next 
      
    set objXML = nothing 
    set objLst = nothing 

Code (markup):

Can anyone help me, I am getting errors and everything. the server has MSXML 6 installed and the rest of the site is in classic ASP, so I cannot write it in .NET as I would like to.

Thanks in advance,

Lee

 

Remove this
<?xml version="1.0" encoding="utf-8" ?>
and this
xmlns="http://schemas.persony.com/wc2/rest/1.0"
from your XML and this should then work fine for you.

Also, if you still get errors after this, let me know the error messages you are getting.

 

hi Urstop,

thanks for the reply, unfortunately I cannot remove the information from the XML as it is passed in from the XMLHTTP object.

I cannot remember how to manipulate the string in ASP to remove the information you said to remove.

Have you any other suggestions?

Thanks,

Lee