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 would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
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 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'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 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.
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 need to create an asp page to parse a slightly unusual data stream which is in CSV format with new records identified by carriage returns. how to start? Really I want to just tabulate some of the data and ignore other fields. It's a travel industry data feed - sample record:
1,JNY,1,050718,1943,S,AHL,051217,LGW,ALC,0645,1235 ,051224,LGW,7,R,154,154,0,-1,0,8888,8888,,,WAL2,0,0,0,0,0,0,
I'm trying to get the date from a request-query post that contains a year (request("season") and a week number from that year (cint(request("gameweek"))+35) I added 35 to the week number because pro football usually starts on the 36th week of the year (if it doesn't, i'll figure that out later).
The DatePart builtin function looks like it would be the best tool to use, but it doesnt parse what I want. I just want to do a simple display with something that resembles:
response.write
cdate(datepart(m,d((cint(request("gameweek"))+35)))request("season"))
what steps am I missing?
what is the easiest way to pull in an html file with asp and parse text out of it?
View Replies View RelatedI have a text file that I want to read and parse lines into seperate strings. For example...read in the text file below:
ARN0480633020025000
ARN0480680020388240
ARN0480686020030000
ARN0480770020030000
ARN0480792020050300
then parse the first 12 characters into strAccountNumber field then parse the remaining 7 characters in to strBalance.Ultimately, I want a user to enter an account# and it will lookup the account balance.
I can parse my querystring just fine. But one thing that I can't seem to get working is displaying some of the data in a select box. Example:
?id=1&type=yy&equip_id0=t1&mac_addr=123&mac_addr1=456
&equip_id1=t2&mac_addr3=789....
I can populate the id and type values in my form fields just fine but equip_id and mac_addr will never be consistent. Certain case will have only one equip_id and one mac_addr value and in other case I will have equip_id0 thru equip_id20 and same with mac_addr. I simply want to parse whatever response I get and display those equip_id and mac_addr values dynamically in a select box. Is that possible?
if its possible to change the IIS configuration for a site to treat both .htm and .asp files as .asp files and if so, how do you do it? (Ie. I would like to configure the server to parse .htm files in the same way as .asp files.)
View Replies View RelatedMy project has been running for 4 years in ASP/IIS (originally on NT4, then on Win2003 as of 1 year ago), using the following code to parse the request object using the XML DOM:
Set oASPRequest = GetObjectContext.Item("Request")
Set oRequestDOM = CreateObject("MSXML.DOMDocument")
If Not oRequestDOM.Load(oASPRequest) Then Err.Raise 64000, , "ASP
Request object could not be parsed."
and suddenly on 12/23 it started producing an error on the third line of code above. I'm not at work right now, so I can't get at the error information available from the DOM, so I will reply to this post with that information. I'm wondering if anyone knows what might be causing this to suddenly fail. I will be looking into what, if any, security hot-fixes were applied to the server recently.
i need the code for parsing urls from text and changing them to <a> tags, for a forum .
View Replies View Relatedwhere can i find a detailed example of the xml dom object/parser in use?
I am using the Microsoft.XMLDOM Com Object
since it is not possible to hold custom classes in the session object, i want to serialize all my classes into xml text, then extract the text, parse it, and restore the class.
I can't find any good examples online for how to parse multi-nested xml files/strings through the above Control. Code:
I need some help with parsing a string and returning all the urls in the string.
I posted a thread online a little while ago but the solution didn't work. Does anyone have any ideas? I have a string called "HTML" and i need a script to parse it for links. I'm fairly new to asp so any comments in the script you could give me.
/content/test.html/
/content/fred/test.html
/test.html/
I want to check the string for the last and second last / and I want the information between the two. in all of the above examples I want to end up with test.html, the string lengths will vary, could even be african lions on the prowl.html
Hey so I ran into a pretty big problem here and hoping someone could lend some advice.
Scenario:
- User uploads CSV file to server through ASP form (Check)
- ASP then reads that file parses it throws in a HTML table for user to preview (Check)
- Throw headers and body columns into 2 seperate array to store for database saving capability (Check)
- If user has a "," in the header name or a field entry things go crazy! (Check)
That's the process and all is great except if there is a comma in one of the field entries or in the header names. Code: