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.
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.
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.
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.
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].
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?
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:
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?
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?
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.
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.
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
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?
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?
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?
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.
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:
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?
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.
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.
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.
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.
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.
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.
