I have an Excel file with one column of data. This excel file, I have saved it as an XML file. Now using the XMLDOM, I am trying to display the contents into a Textarea.
I'm parsing an XML document using the XMLDOM object in ASP. I am running into a problem with a section formatted like this:
<MasterElement> TitleOfElement <Abbreviation> TOE </Abbreviation> </MasterElement>
If I use node.text, I get TitleOfElement TOE. I need to seperate the two but cannot find any reference that addresses this. Of course I can manually parse using standard functions like InStr, but it seems like there should be a more proper way to extract the data. Anyone run into this?
I want to load some HTML which is in a ASP variable into an XMLDOM object but am having no success. All the examples I see point to loading documents from the filesystem using the .Load or .LoadXML methods.
I'm in the process of 'trying' to write a very small CMS which will allow me update an existing XML script I have.
Unfortunately I just cannot get the script to work, my script falls over with an objRoot error when I try to set the objField using selectsinglenode. XML looks like this:
xslProc.input = xmlDoc ' The xml to transform xslProc.transform()
I now want to use the resulting xml output (the xsl transforms to a different grammer) to do some stuff before the whole lot (xml and stuff) is passed back to the page that called it (AJAX). How do i feed the transformed xml into xmldom, domdocument or what every is required for me to navaigate using xpath and so my stuff?
I've had an ASP project dumped on me written in VBScript. I'm actually a C#/ASP.NET developer and am struggling trying to find a way to sort the result of a XPath query executed using SelectNodes? Code:
I have the following code which I try to load an xml file, but in browser, I only get text value for each node, not whole xml string. I expect to see something like:
<name firstName="betty" lastName="Smith">I am at home</name> But I only see text "I am at home" did I do something wrong? Set xmlDom=CreateObject("Microsoft.XMLDOM")
I've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
I am trying to peform a multiple deletion of records from a single table "Stockist"
I i keep getting the following Error and can't see where i am going wrong. Can anyone help?
Microsoft OLE DB Provider for ODBC Driverserror '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. /RetailerStockProductRemove.asp, line 22
I am urgently finding a set of codes to write data into a form and the data will go to my database. However i have tried a lot of form but couldn't successfully process. Below is one of my problem...
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9a8 Thread 0xa08 DBC 0x3041e1c Jet'.
I have this insert statement where instruction field in the DB is a memo field.
SQL="INSERT INTO int ([instruction]) VALUES " & _ "('"&Request.Form("myTextarea")&"')"
objConn.Execute(SQL)
Its giving me error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
i want to ask is there any way that i could get the value from field (the value will be used in SQL statement) without submit the form coz if i use Request.form("name"), it need to submit the form to get the value
I'm interested in creating an asp function that enables the general parsing of xml. The function needs to take into account the structure of the xml document, as the document(s) can be quite complex.
The use of getElementsByTagName() is not appropriate in this case as I'm trying to avoid picking up the wrong data. The function also needs to be able to test if a node has any attributes and what the attributes are. Here's an example of the document I'm trying to parse: Code:
I do a regular HTML form POST to a third party server. The server processes the request and displays result in XML format. However, I need to parse this xml and display in HTML. The problem is how can I get the control from the form POST.right now, the form posts and the result is displayed but I need the control back.
I need to use forum code for my site, and making things bold, etc, is very easy however, I cannot work out how to use the tags [*url]http://site.com[/*url], the asterix will avoid it being parsed to create links.
I want to be able to get the text between the two URL tags, and build a link, so <a href=""" & textinbetween & """>" & textinbetween & "</a>".
is there any way that i could get the value from field (the value will be used in SQL statement) without submit the form coz if i use Request.form("name"), it need to submit the form to get the value.
Set ResponsibilitytNodes = DomDoc.SelectNodes("CLASS/Work_Experience/job[@employer='" & node.attributes(0).text & "']/Responsibility/") For Each node in ResponsibilitytNodes Response.Write ResponsibilitytNodes.text Next
I have a script that Technicweb helped me make. However it is just short of what I need. The players data still has the html code around it. I want to extract the name only with the statistics. I cant seem to get my head around it - all I have learned from picking apart Technicweb's script seem not to work for me. Here is the latest of what I have come up with, it gives me an error:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'MID'
I think this has been asked before but I can't find the reply. I'm using the XML parser to post data to a server and receiving a reply. The reply is in XML and I want to find elements of the retrieved data. Eg. I receive a string with: Code:
I am looking for something similar to "preg_match" and "preg_match_all" in PHP.
I have searched the forum with no luck. I hope you are able to give me some pointers
Basically I want to match some text from a form and loaded it into new variables making use of regular expressions. the text comes form a textarea input type. Code:
I have to display time in HH:MM AM/PM format. My date/time values are being pulled from a MS SQL database that is in smalldatetime field format.
I need to take a date such as "5/5/2006 7:35:00 AM" and display it as "7:35 AM". I can't seem to find how to parse this or display only the hours, minutes, and AM/PM designator.