Parsing URL And Read Xml Data
I have an url where I have xml data POSTED and I need to parse the URL to read the data - Meanwhile here is my xml data Code:
View RepliesI have an url where I have xml data POSTED and I need to parse the URL to read the data - Meanwhile here is my xml data Code:
View RepliesI've found the MS XML parser as shown in below code. I'm just attempting to display the various ListNames in the ListStruc section of an incoming XML file (generated by the SelectLists API call). On the line with the astrik though, I'm getting the error "Object required: '[object]'. Is this because I don't have this parser installed? (I'm running XP Pro w/IE 6.0.)
Also, I'm not sure about the line xmlDoc.load(request), shouldn't it be xmlDoc.load(xml.responseText)? Code:
I have a select statement that gives me the following results (for example) "test documentation/software product version document.doc" I need to parse the data to only grab everything between the "/" and ".". So, in other words, "software product version document" - I have absolutley no idea how to do this .
View Replies View RelatedI have a select statement that gives me the following results (for
example) "test documentation/software product version document.doc" I
need to parse the data to only grab everything between the "/" and
".". So, in other words, "software product version document" - I have
absolutley no idea how to do this - can anyone help?
My problem is this: This database has a field called "b_name" which contains the first, middle (if any) and last names of registered users. The table also has corrosponding other demographics pertaining to each registered user.
I've used the code below to parse the full names in "b_name" in the original table and put the names in another new table which has 3 fields, "FirstName" "MiddleName" & "LastName".
My problem is the fact that the way the names are stored in the original table and the parsed names in the new table do not correspond. Code:
I am attempting to pull data out of a sql database and then parse it so that i only send the data after the last carriage return to the actual page.example
blah bla 1 ( carriage return )
blah bla 2 ( carriage return )
blah bla 3 ( carriage return )
blah bla 4 ( carriage return )
blah bla 5 ( carriage return )
blah blah blah 6
my code should return blah blah 6
I'm looking to grab data from an XML stream...and parse the information so that I can just take what is between the tags and add the information into a DB. Code:
View Replies View RelatedI got a database with user and email in it. Now I want when a user logs into my page that it automaticly fills in the email into a email form. How can I do that in Asp.
View Replies View RelatedI want to create a Excel OWC component and read data from the Orders table of the Northwind database and write into the OWC component.
View Replies View RelatedI write the code as follows. But I cannot print the binary data as meaningful data format. any idea?
Response.Buffer = True
Const adTypeBinary = 1
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary
response.binarywrite rs("abc")
DXUpload.Form.1 Error '80020009'
Failed to read binary data.
/backoffice/album/album_save.asp, Line 29
___
If lJt = "GENERAL" OR lJt = "GOODS_DETAIL" Then
29: Set objUpload = Server.CreateObject("DXUpload.Form")
lAction = objUpload( "ACTION" )
Else
lAction = request( "ACTION" )
End If
___
here's my code... I can't see why this error occured...
any advice to sort it out?
My application requires reading data(html) from an iframe and push into a div tag. 'innerHTML' property of the div tag allows to push data into it. Can anybody tell me how to read data(html) from an iframe.
View Replies View Relatedhow to connect to a mdb database and read from it. But how can i make a simple textarea that takes inout and writes it.
all i want is a textarea with submit so i can write to my database only with a couple of words i dont have any code so fare apart from read the data and connect.
I callup the aspx file in IE and the form comes up just fine. When I select a person to update, I get the subject error. Aparently, when I select a person, it's not selecting anyone and returning this error. Here's the full error:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code:
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View RelatedI created a web page from Excel2000, using "Save as web page..."...Publish
function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side?
For example, the value of Cell(1,2), Cell(2,3)....
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
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
View Replies View RelatedI'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:
ASP
I have
value(0) = 1
value(1) = 2
value(2) = 3
value(3) = 4
etc...
I need to have as output
1,2,3,4 ...
Finnaly I must submit that to 2nd asp page, and use it inside the javascript. Any ideas?
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.
View Replies View RelatedI 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>".
How can I parse it so that I can just get:
/newthread.php?do=newthread&f=5
I can get /newthread.php with script_name, but I'm not sure how to get the whole string.
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.
View Replies View RelatedI need to do one SelectNodes loop inside another. anyone know how I can do this ? I'm trying the following code at the moment which doesnt work:
[VBS]'WORK EXPERIENCE
Set TheseNodes = DomDoc.SelectNodes("CLASS/Work_Experience/job")
For Each node in TheseNodes
Response.Write node.attributes(0).text & "<br/><b>Time Frame/b> " & node.attributes(1).text & " - " & node.attributes(2).text & "<br/><br/>"
Set ResponsibilitytNodes = DomDoc.SelectNodes("CLASS/Work_Experience/job[@employer='" & node.attributes(0).text & "']/Responsibility/")
For Each node in ResponsibilitytNodes
Response.Write ResponsibilitytNodes.text
Next
Next[/VBS]
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'
/scrapes/testparse.asp, line 33
am I way off track? Code:
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:
<food>Love it</food>
<drink>lager</drink>
I want to get the value of the <food> tag.
Lets say I have a string like "www.ssss.com/images/theimage.jpg"
I want to parse the string and just return the image: theimage.jpg
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.
I am looking for code for parsing csv files. The files I am parsing can be:
-pure csv: a,b,c
-quotes: 'a','b', 'c'
-quotes or non-quotes: 'a',,'b','c'
-with or without carriage return
Can anybody help me with this one?
I have a string problem that I would like to resolve. I am submittting multiple values to a form that is posted to query string. The string looks like this:
http://localhost/csiapp/test.asp?Submit=Submit&menu2=436%A0AbdallahFadi&menu2=430%A0AdkinsAngela&menu2=425%A0AleemAmina
So what I need to do is to take the id number of the user and put it into an array so I can later insert it into the database. So for the example above, I need an list that looks like this:
436, 430, 425
Once I have this list I can make it an array and then put it into the database.
My question is how do I make the string above look like the string below? I know that I need to use some function of asp to parse the name oout of the string, but i just don't know exactly what....
I have searched on parsing some strings but I don't know how to apply it to my string. The string I am parsing looks like: $$1,0,0,0,0,0,7,8,0,0,0,0,13,14,0$$None
What I am looking to do is get the non-zero numbers.
I will then use these for another portion of the page where checkboxes corrosponding to those numbers will appear and the zeero numbers will not. The string after the last two $$ must be used as well for text on the page. I can change the string to look however
is easiest to parse.