How would I read a component of a date value in a field written in the format: "1/20/2006 1:45:37 PM".
For example, say I want to extract only the year component during a record read. "SELECT * where "the year in the submit_date field is '2006'"?
I have an XML file that contains nodes and I'm having no problem extracting the information using ASP. However I can't seem to get the ID number from the deliverrequest node from the example below.
<!DOCTYPE xiamSMS SYSTEM "Message.dtd">
<xiam>
<deliverRequest id="10234690"> ''' Need to retrieve this number using
ASP
<to>test</to>
<from>number</from>
<content type="text">Test 2</content>
</deliverRequest>
</xiam>
Is there an ASP way of extracting the height and width of a swf file so that
I can specify these dims when adding the whole OBJECT code to the web page?
What string function(s) would I use to extract just the filename from an URL?
For example, if I have http://www.yourdomain.com/some_directory/some_file.asp, how do I extract just the "some_file.asp"?
Is it possible to extract the first paragraph in a mysql text field? my code line to display all text:
<%=replace(Recordset.Fields.Item("article").Value, vbcrlf, "<p>")%>
I want to separate the 1st paragraph (article lead) from the others (article), without having one table for 1st paragraph and a second one for the rest of the text.
I need a help in extracting files, thru ASP. Is that possible to extract files from .tar, .gzip and zip files thru ASP.
View Replies View Relatedi want to extract the number 38 from the URL below, using ASP what is the solution?
then store it as a variable.
http://pcol-webtest/default.asp?nc=4098&id=38
is asp code able to do the extraction of text from PDF File without using a third party software?
View Replies View Relatedwe have a site, that has a link to a online PC cart that we are registered with. Trouble is, when the user goes to the other site, we obviously no longer have our interface wrapped around the page.
We can do this with an iframe, but it wont vertically stretch the content (a scroll bar appears). Is there any way in ASP, to call a url, and say, insert that url into a <td></td> on our page?
Not a problem with my code, but something I would like to add, (ASP
VBScript) at the moment I have a form where a user uploads their details
including a document (Doc, PDF, TXT, Docx) The document is uploaded to a
folder on the server with the address being stored in the database and I'm
tracking the user id through sessions.
What I would like to do after the upload is redirect to a blank page, where
some script extracts the data from the document and inserts it into another
field on the database associated with the user id, I think this may be called
parsing, but I'm at a complete loss, I don't suppose you guys have any ideas
on this do you.
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
Is there a way of processing an ASP page and placing the resulting HTML
source code into a TEXTAREA on another page?
I have a page that will be generated dynamically from database content.
However, I want a form on another page to have access to the compiled source
code for use in an electronic newsletter.
Manually I would load the dynamic page, view the source and copy it out. I
would then paste it into my form field on the relevant page.
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
in my project, i want a label which shows the current value of all shares in the market whenever the user login to the application.how can i do that.how could i dynamically extract data from the shares website.
View Replies View RelatedBasically I want to be able to take the tempreature, pressure and wind and be able to use them as variables in calculating performance automatically for an aircraft. I've tried using the pull string method but can't work out how to seperate the variables.
View Replies View RelatedI have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates.
I'd like to do the above, ideally in javascript but i'm aware of the security restrictions with accessing the DOM of a file not hosted on the same server - however i'm not looking to manipluate anything on the remote site, or handle any events (such as keylogging!). All i want is to have a piece of text on the remote site dupicated on my own site.
I'm happy to receive the html as a whole and split it up to get what i want, but i'm beginning to think the way forward is doing it server-side with asp.
Anyone know the best way to do this?
OR am i just being silly and there is a way to copy the contents of a remote page into my own page in javascript, split it up and only display what i need.
(btw im quite happy with the splitting up bit, no help needed there - i just need the blasted text in the first place!)
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually?
Perhaps its possible to do it with Stored Procedure? or some other means?
I am trying to add a feature to our inventory that will pass the current URL to a second site so that I can return to the original site later through a redirect. Basically, it is intended to work like this - you do a search, and are taken to a page where you can view the records.
You click on a record to view it and/or update it, and then you are returned to the original search results. I am having some trouble, and am hoping that someone can help me out.
I am placing the values that I want to keep (original URL, search terms, sort order, page number) into a string, and then using Server.URLEncode to encode it: Code:
I have a bunch of html stored in a session variable. It's just a long string of html. I want to parse it to extract certain things out of it. I'm assuming I would use the Left, Mid and Right functions. But don't know exactly how to do it. Plus I need to find the information in the session variable too.
View Replies View RelatedI have an access database and am currenlty using classic asp for most of my coding and am trying to extract sentences from the memo field that contain specific strings, in this case "<b>"
The memo fields contain a lot of data so filtering becomes an issue, so i just want to be able to only display the sentences within the memo field i.e. between "." and "." OR beginning of record and "." OR "." and end of record that contain the string "<b>"
I am working on getting through the book Teach Yourselve Active Server Pages in 24 Hours.
Now, I am not learning ASP.Net, but ASP. Why, because, I am getting a lot of calls for asp, but not many for .Net. And I just don't know enough as I'd lilke.
At any rate. I have gotten to the section on Working with components. for example the MSWC.NextLink
I don't have it. I am running IIS 5.1 because I am on a Windows XP machine. And I am told I need a SDK download, but which one? Everywhere I look, its IIS 6, but that doesn't work on my machine. So, how do I get these components so I can run them.
After working for so many yrs in ASP and COM I still feel novice. I have asp
page nd a COM component (.exe) which is written in VB. For some fixure, I
have to remove my IIS and reinstall it. My ASP page is not instantiating my
component. Whereas, components which are dlls working frin in ASP pages....I
checked permissions on DCOMCNFG, file directory, folder, file.
Any clues what is missing.
Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.
/testcomponent.asp, line 2
line2 is just a createObject for my .exe com component.
I am new to using components in ASP, whilst I can see the huge benefit of using them, the big problem that I am coming up against is that my host won't let me register them on the server.
My question is simply this: is the only way around this problem to setup your own server (which is probably beyond my technical ability) or are there lenient hosting companies out there that will let you install components freely (obviously subject to their approval)?
I dont know if there exists a directory of components somewhere which have been approved by hosting companies as safe to use on servers? Im a little confused as to how I can take advantage of components if I can't physically install them. Is it possible to use a component removely without having to install it on the server?
Sorry, I know I have asked a lot of questions but I am really in the dark here and not quite sure what my options are.
I need to convert a dynamic (ASP) page on my site to a PDF, so I am looking for a PDF component which can open the page from a URL. Failing that it would need to open an HTML file from disk and convert.
I've been searching and there are hundreds with rather random pricing and different feature sets.
Can anyone recommend a component for this job which doesn't cost a fortune?
How can I make components to my asp code in VB or other VS 6. Nedd to know all the steps, because never make any activeX component. Nedd also to know how to call the dll file as well to receive and pass arguments to it.
View Replies View RelatedI am trying to use a component to execute a file but I'm not exactly sure how to
could some one please provide a little bit of sample code showing me how to
use a simple component?
I've just been reviewing a COM component (VB6) that I wrote a while ago to
record when and where 404 errors occur; each error is logged in a DB along
with supporting information.
Looking at it now, I'm wondering why I chose a COM component rather than
just an ASP page. There is not that much code involved, so I could easily
have expanded the ASP page that calls the DLL to do the whole job....
COM Component:
Generally perform faster than an ASP page, but there is an overhead
associated with creating a new object in the calling ASP page, so more
suited to more intense apps that dont require user-interaction. Also keeps
code private of course.
ASP:
Keeping you code in an ASP page is often more efficient for smaller jobs,
where the cost of creating a COM object outweighs the potential performance
gain. Also prefered for tasks that require frequent user interaction. Code
remains public (to those who have access to server).
This is what prompted my question: At what point, does it become worthwhile
to go for a COM component as opposed to an ASP page? Is there that much
difference in it?
Are perceptions of the issues fairly accurate?
I've updated the DLL in question - it was a bit of a ball ache: modify code
& compile, reset IIS, then copy DLL to server and re-register. I know my DLL
in this example doesnt do much, and I'm certain that modifying and copying
ASP pages would be simple & efficient, but at what point does it pay to use
a DLL?
I have a server runnign iis with no email componetns. Where do I get cdonts or similar components from?
View Replies View Relatedanyone have any experiencing using serverobject's components guid maker and aspmail? i'm wanting to change my cdonts scripts to the aspmail com and was wondering how good it worked. the guid maker is also installed on my host and was thinking of using it.
View Replies View Relatedwhich ActiveX Component allows IIS to provide e-mail services
View Replies View RelatedI migrated an application from NT4 (IIS4) to 2003 (IIS6).
The application only works when the components are registered with regsvr32.
One of the webpages doesn't work-- when I fill the form out and hit submit I
get "compx error '800af10a' Insufficient memory to perform operation.
/submit.asp, line 283"
I've tried going through and changing permissions but haven't had any luck.
I also tried setting the Web Site to use an Application Pool that I created
to run as System Mode but that didn't make any difference.
Everything works when I select "IIS5 Isolation Mode".
Knowing that it works under IIS5 Isolation mode how can I determine what is
causing the message so I can run it under IIS6?
How can i view the third party components installed in my PC?
View Replies View Related