Searching Text Files
I have developed a search engine to search through an Access database.It uses three fields to say if the number of people is less than 300 then display these fields.
I have searched for an engine to do the same thing using a text file as oppossed to Access.I have only found examples saying you can search through text files to find character similar to the search term.Does anyone know if it is possible to pull a character form a text file and use ASP to say if its less or more than.
View Replies
ADVERTISEMENT
Does anyone know of an ASP script which I can use to search through .txt files, this is because i have a mailing list stored in a txt file and i want to be able to search to see if the e-mail addresses are repeated.
View Replies
View Related
Ok my site is made up of both Database(access) and about 200 or so html files.
Currently I have a script running just to search the database. How do I search all of the HTML files for speific text?
View Replies
View Related
Is it possible to develop an ASP page to search within an intranet environment. The file properties searched out and then post the properties info to an access dataset ?
I had searched for commercial shareware and other searched out items only to find applications where I can get file name, created dates file sizes. Nothing more nor expandable for additional information. And then put into a spread sheet. One did work but only on minimal property info. I need to expand to more information from the properties of specific files.
Example I used was morespace, Located all files in a specific drive, folder or etc then listed a few items into a table. I need the same ability but the capability to add and change how much information I can record from the file properties.
View Replies
View Related
I have created a page which receives a query string from an SMS text message. The query string 'Body' could look something like this:
123456703061977C123456789sub901sub123sell901buy903 budget
what i need to do is split it up. I know the first 7 numbers are needed, in this case '1234567'
Second i need the following 8 digits:
03061977
WIth the rest of the text i need to scan and see if certain keywords are in there. This case i need to see if C is in there, and if it is then i need to identify the 9 digits after that letter. If sub is in there, then i need to find out the following 3 numbers, and if sell is in there i need to grab the following 3 numbers, plus what 3 numbers follow the corresponding sell.
View Replies
View Related
I'm making a new database that is to store details about word/pdf documents. I need to have a search function that can search through the content of the file. Is this possible? [I'm using Access].
View Replies
View Related
I have a table that contains a column with datatype text. I would like to search through every row in the table and find a string of characters in the text column and replace it. Unfortunately, the SQL Server I am working with does not have full-text indexing installed (nor can it be installed). Can anyone show me how to best accomplish this?
View Replies
View Related
The user can search the database when they put in a date, that works fine, but when i put in another text box to search the database for a certain date range Code:
View Replies
View Related
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
View Replies
View Related
I have an ASP (not ASP .NET) application that I have to modify. I am now using Visual studio .net as the editor. I would like to be able to work on the files together with a colleague and have versioning included in the ASP text files each time they are modified.
In addition, any comments that I make about the files as a whole in the editor should be automatically inserted in the ASP file as comments. Anyone knows an editor that can help me with this?
View Replies
View Related
I haven't started programming with databases yet, but instead have been saving data in asp files. The files would look something like this.... Code:
View Replies
View Related
I'm writing a script lately to write some records into a text file for backup purpose. But may i know do asp allow update for the text file? Cause i dun want it to overwrite my previous records.
View Replies
View Related
i have a text file (tsv) with products in, but i want to run queries on certain fields, e.g. description, i ahve tried linking the txt file to a databse but the recordset does not work,
does anybody have a sample script that will query a tsv, csv file.. e.g.
SELECT FROM prices.tsv
WHERE products = cisco
View Replies
View Related
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example:
Dim line1, line2, line3, line4, line5
line1 = Line 1 of the text file
line2 = Line 2 of the text file
line3 = Line 3 of the text file
line4 = Line 4 of the text file
line5 = Line 5 of the text file
How do I have to do this? .....
View Replies
View Related
I want to be able to compare 2 text files and display the diffeneces.on a webpage.
View Replies
View Related
I was under the impression if I had a page with several database queries to 3 different databases, it would be faster if I just had the queries cached to text files since the query result won't change that often and I build the cache manually when needed.
So my question is would it be faster to just include text files instead of doing multiple Access and SQL queries on a web page?
View Replies
View Related
i want to upload text files present on my comp (running IIS) to a ftp site which is password protected (I have the "write" access to the site) how do i go about doing it?
View Replies
View Related
Can I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies
View Related
I have several text files on my server and I would like to combine them into one text file by just appending each file to the end of the combo file. I know this should be possible, I just don't know how to approach it. Some combination of OpenTextFile and CreateTextFile?
View Replies
View Related
I'm trying to remotely get a pdf file - http://remoteServer/file.pdf - in order to store it into another server, maybe with Scripting.FileSystemObject
However the following code doesn't work properly:
------------
url = "http://remoteServer/file.pdf"
set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.open "GET", url, false
xmlhttp.send ""
------------
as xmlhttp.responseText does not contain the whole file textStream, but only a part of it.
View Replies
View Related
I need to know how to write a text file to a local machine. Here is my code:
Set myFSO = Server.CreateObject("Scripting.FileSystemObject")
Set WriteText = MyDrive.CreateTextFile("C: est.txt", True, False)
Right now it writes the file to the C: drive on the server.
View Replies
View Related
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
View Replies
View Related
I have made a asp page that will read a db table and select certain fields concerning the current day's activities to be written to a text file. After the information about the current day's activities has been compiled, it is stored in a variable and written to a text file.
What I would like to do is create a text file for each day instead of over-writing the same one. Is there another Server.CreateObject method that will allow the 'creation' of a text file rather than just over-writing a text file that already exists? I would use "month(date)", "day(date)","year(date)" to append to a text file name to keep it unique.
Below is what I currently use to create a text file. But any new information will only overwrite what is already contained in the text file. Code:
View Replies
View Related
im wondering if there is a method/command which can be used so that when an asp page is called, it can 'explode' content from a text file (.txt) onto a web page, thus enabling a n00b to alter the text within the file, rather than the web page itself?
Further more, if I wanted to incorporate the text which is exploded into a CSS to give it some style flava, how would I do this? Is it possible?
View Replies
View Related
I have some variables that consist of small paragraphs and or short sentences. How can I to see if a specific word is used in the text of that var.
View Replies
View Related
i want to perform search operations using ASP.
this is a word search i.e. every word entered as search keyword
should be searched in the database...
since it is a word search, i tried to split the string entered as search keyword,
and then search for each splitted word in the database.
It worked for only a few records present in the database. some 1034 records were searched out of 1914 i tried the same procedure in PHP and that worked.
View Replies
View Related
I'm having some problems using like to find items in my database for some reason its not finding anything if it has a space in it. Here is my SQL query:
SELECT * FROM Employees WHERE FirstName LIKE '%Dennis Smith%' OR LastName LIKE '%Dennis Smith%'
In this query i'm searching two fields for any occurance of Dennis Smith whom i know is in the database however no results are returned. Also if i just search one field and the search string has a space in it, no results are returned.
View Replies
View Related
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
View Replies
View Related
currenlty we are changing our user email ids- about 2000.I have an excel file with thier new and old email ids.
Is it possible to make a .asp form file and put in an IIS server.
where user enter their current id- and the asp returns the new email id.
View Replies
View Related
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html.
I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
View Replies
View Related
I have a single column that outputs a comma seperated list of values (black, white, red)
I created an arrary to output the values
Dim colorTypes, arrTypes
arrTypes = split(objRS("types"), " ")
riceTypes = REPLACE(objRS("Types"), ", ", "<Li>")
response.Write "<Li>" & colorTypes
This works fine. Now, I need to compare a queryString to arrTypes and bold the match before outputting it.
View Replies
View Related
Just wondering the best way of doing this? are there any dictionary databases laying around somewhere?
I want to change my search so that it corrects typo's and maybe suggests better words to search with... like googles but with more alternative words to make the search more useful - slightly limited so it doesn't become pages and pages of search terms.
What I don't want to do is sit down in front of my computer and type all of this in, going through related words and possible other searches / best searches from the given input.
View Replies
View Related
I need help in retreiving data from database. my form consists of some checkboxes,
for eg:- in my form for location three check boxes are there and for the type of house four checkboxes.(houses,apartments,offices etc).Below is my form,
London (north of river)
(checkbox here)Central London
(checkbox here) Docklands
(checkbox here)Ealing, Chiswick & Acton
Number of Bedrooms(text box here)
(checkbox here)Houses
(checkbox here)Apartments
(checkbox here)Developments & Land
(checkbox here)Commercial
My databse consists of all this information. If the user want 2 bedroom flat or apartment in central london he will check central london, 2 bedrooms, house and apartment. for this i need an sql query to retrieve from database the appropriate property they are finding.
View Replies
View Related