Ive been searching the net now for about a week for someway to extract all of the links and images out of source code. I want to make a search engine. I can get the HTML of an entered URL, but now I need to EXTRACT all of the links e.g href, src and I want to place them into an access database.
Ok, given a string up to any length, lets say 1,000 characters. I want to only display no more than 450 characters, but I want to end the string where a "." is found. In other words, have it go the 450 character, then from that point backwards, find the first "." That will be the end of what is displayed. I don't want hanging sentences in other words...
Maybe a simple question but baffling me a bit. What I am doing is spanning a form across several pages, I was going to use session variables to collect the data but there are some 23 questions which can be of various lengths in answer form so I have opted to fill in a database entry. Multiple users may be logging onto the site at any one time.
What I need to do is create just one session variable - the user_ID which is allocated once the first database entries are initially added.
The question:If I am doing an 'INSERT into tablename values 1, 2, 3, 4 (thus creating a new record) how can I automatically get the user_ID (which is an autonumber field in the database) straight back out and allocate it to a session variable?) - we are trying to avoid a 'login' procedure
HOW CAN I RECEIVE THE EXACTLY ID AND SUM IT BY A SQL QUERY??
I TRYED IN THIS WAY:
<%Server.CreateObject("ADODB.Recordset") Set Rs_sum = Conn.Execute (" SELECT SUM(quota_sc) as quota FROM supplementi WHERE id IN (" & Request("id") & "); ")
I have a search engine and i want to extract only the URLs and the descriptions from the results which come from the search, then i want to insert them into a database.How can i do that?
Trying to extract tab delimited data from several zipped .txt and .jpg archives into a database on the fly. I know there are some components out there to help with this, but this has to run on a regular web host (win2k) and I don't have the ability to install components on the server.
How do you fetch just the domain name part of a variable in a script? The variable can be http://www.domain.com/blahblah/whatever/page.htm or http://sub.domain.com/blahblah/whatever/page.htm
i want to extract out certain column from my table . can i do it using the checkbox . eg. when i got ten check box then when i select 4 of it . the selected 4 column will appear in my next page . can i do it this way ? or is there any other easier way ?
Does anyone know how (using ASP & VBScript) how to extract the description from a webpage. I mean the meta description contained in the HTML (eg <meta name="description" content="description of website">).
I was wondering if anyone could help me out with extracting/stip an HTML file. I was thinking of using RegExp object in VBScript, but I'm not sure what is the correct pattern.
I would like to stip the HTML so I only get the content inside the <BODY> tag (<BODY> </BODY>) ...
I currently have an excel flat database, it contains a computerName and it has a list of parts associated with it next to the cell value of computerName.There values that are offsetted to the right are the parts associated with the computer name. I was wondering through ASP could i have a dropdown of the computerName, when clicking submit it will find the offsetted values to the right.
how to extract a pic from ms access database.I used simple codes found online but it only gives me the binary codes not the pic itself.Wondering if anyone could help.I have already put the picture in the database.Now is extracting it.
I'm using the following method to retrieve the filname from a full server path:
<% sub getfname(strPath) Dim fName fName = Mid(strPath,InStrRev(strPath,"")+1) 'fName = strPath Response.Write( fName ) end sub %>
However this only works on Windows systems as it checks for backslash. Is there a more generic way to do this, or should I check for both backslash and slash in the path?
Is there any way to extract the form elements' value without submitting the form. I want the value of the form element be used in the script written in the same page without submitting the form.
I have several (well, several hundred) word documents. I need to extract information from each such as Author, Date Created etc... how would I go about doing this for a single document?
How would I make this take the first 100 characters (as it is now) but also take the next few letters until the next space. (so that I don't cut a word in the middle.)
I have a field in an access db which is of the data type Date/Time holding a date in the format, Short Date. Thefore it looks like 10/03/2004. The table holds a lists of events and I want to list them all by month breaking on the month as a header (and only listing for months which have events), like so:
Im currently making a photo album website which has an ASP page to look in an images folder for any available jpg images.
What I would like is to extract the jpeg data such as width, height, title, bit-depth, comments etc.
All the fields can be found in windows xp if you right-click the image and then click Properties. Select the "Summary" tab and there is where all the jpeginformation is stored and can be edited.
I have to extract data from excel data to convert it into access. the problems lies that it takes data from excel only 50 rows after that it says syntax error.not able to find whattt is the error as upto 50 records everything is working fine.