I trying to search a text file using a boolean AND search. What i want to happen is when a user types in type values to search e.g. Name Department (Taylor marketing) i want it to only read out the lines which contain both values.
At present it reads out all lines with Taylor in and all lines with marketing. The code i have so far is: Code:
I'm trying to add a search facility to a page that looks for matches in one,
other or both memo fields of a database. The code below works fine if the
visitor types in one word, or the term just happens to exist in one of the
queried fields.
What I'd really like is for a visitor to type in an expression, or query in
the same format as you would use in a search engine and it would find
appropriate matches. Any ideas how I can modify the code below to do this?
I have one TEXT file that I use to log download information from website.
The file will have unique Login ID for the downloads. When the user will
come for next time for download the LOG entry should go under the same
section (same ID number) so for this I need to search the text file for the
ID and if the ID is found the program should append the NEW LOG entry to the
end of Section. (section mark can be a line of ***** ) (mean just before the
***** line)
I have to make a site search function for my website. User types a keyword, and the search function searches through all the static pages for the keyword. The result of the search has to display the URL relating to the keyword, which the user can click to read the contents.
I had no idea how to go about doing it, finally I thought of using a textfile containing the word, and its related URL in the format: Code:
I've written some code that creates an sql statement in a string to update a boolean value in an access database, however, I dont know what value to give the field to update the boolean value in the access database.
I'll paste some of the code so it makes more sense.....
(note: the 'Booked' Field is the Boolean)
strSql = strSql & " UPDATE HolliesBookTbl SET Booked = '-1' WHERE "
'loop through the checkboxes which were ticked
for i = 0 to ubound(arrVals)
if i = 0 then
strSql = strSql & " DateID = '"& arrVals(i) &"'"
else
'only add the " AND " if this is not the first value
strSql = strSql & " AND DateID = '"& arrVals(i) &"'"
end if
I've been pullinhg my hair out over this
I have a boolean field in an access database. I want to write an SQL statement which pulls out all records from the table MemberInfo where the field Online = true.
This is my code
sql = "Select * From MemberInfo Where online=true"
This doesn't work, do I need quotes around true?
I use ASP to display links to Word documents on an intranet. Is there a way in ASP to do text searches on the documents' contents? I want the results to have the link to the Word document plus two or three lines from the document that include the search terms.
View Replies View Relatedif a declare a variale say
Dim Flag
and assing it to true a boolean value
Flag = True
and if i try to concatinate it with another string like
mystr="<my-str>" & Flag & "</my-str>"
and if the machine is non english the mystr will contain something like
<my-str>that language characters</my-str>
what should i do to get True in mystr what ever the Language of windows is.
how to highlight the search text on the asp page when its displayed after being fetched from database[using LIKE]
any vbscript technique?
im working on a script which will search the specified keyword within files, for this im using FileSystemObject which is working file with html/text/asp files but is there any way to search the text within .doc/.pdf files too?
View Replies View Relatedif there is a way to do a text search through pdf documents?
If there is, can someone show me how, or at least point me in the direction of a good tutorial?
I have developed a website with ASP.NET Jscript. Im fairly new to development so i used DreamweaverMX and Webmatrix which was very useful. Now I want to enhance it further by adding a search facility into my website and thus providing users to actually find contents within my webpages and display the same.
View Replies View RelatedDoes anyone use a funtion to highlight search terms (if they have a search facility on their site). Basically, I would be sending the search terms from a form field into a results page.
If there are results I would like the search terms to be highlighted. One problem that I could think while using "replace" is that capitalisation would not be maintained.
I want to search text field and highlight the text. This is the code,
Code:
strText = cstr(Request.form("strText"))
strText = uCase(strText)
strTextWhere = ""
strTextWhere = " and (Specialisation
like '%"&strText&"%') "
I have a lot of data in different cases. I can do the search, let say i want to search by keyword project, it will display all the "project", "Project" and "PROJECT". But now i can only hightlight the "PROJECT" only. I think this is because of ucase(strText). Is there any way for me to highlight all (either lower, upper and mixed cases)?
I have a simple JS function that I want to return a true or false value based on the parameter passed in. At this point of time I receive the error "'True' is undefined". Here is my code:
View Replies View RelatedI have some code that checks security permissions in a DB, and before my conditional statement that checks these permissions, I am writing out both values to see what the statement looks likebefore it is evaluated.
The problem is, it seems to disregard the condition and always returns True, even if the condition should be false...any ideas? I also did some testing to assure that the length of the two values I am comparing is 1, just in case they were possibly holding spaces, and I verified they are numeric as well. I am just stumped here...
Let me also preface this code snippet by saying, I am using this asp script to generate javascript menu choices...and I did include some commented debug statements so I can see what the javascript rendered.. Code:
I am trying to do a simple text search
The Table I am searching is called 'Items' and the Field I am searching is called 'Item Title'
My search sql string is as follows:
strSQL = "Select * From Items WHERE Item Title LIKE '%var2%'"
However I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Item Title LIKE '%var2%''. /showroom/asp/showroomSearch.asp, line 45
Is this error being caused by the fact that the field I am searching has a space in the name? If not, please can someone tell me where I am going wrong as this code seems correct to me.
For example:
The text to be searched is the following:
Text 1:
Hello world! what a nice day today. But I like to sit in front of computer and doing some web design. Now I have encountered some technical problems and would like to get some helps from the experts.
Text 2:
I like fishing.
Text 3:
Baseball season is over.
Text 4:
The winter snow storm is coming.
Search Keyword: snow.
Search result is Text 4
Search Keyword: I
Search result is Text1 and Text2
At the end, the key word should highlighted with a different color in the paragraph.
How would I do about this?
i want to know how to use the MySQL full-text search feature using ASP.
Also, how do i index my web pages using MySQL full-text search.
This question has to do with MS file search but it is happening only with
..asp pages, so I though someone programming with .asp pages has experienced
the same situation.
I'm trying to find .asp pages with a certain table name (i.e.
"renewalInfo" )
When I ran the search I get no results. I know that I have that string in a
couple of pages. My file system search engine is working fine with other
file types, like Word documents, Excel spreadsheets, etc.
I tried typing the string outside the <% %> tags and when I do the search I
get the file results, so it seems like if the search engine in my file
system was not searching inside the <%%> tags. Code:
i am developing a search engine(ASP with SQL SERVER) for my project . My objective is to search for a data and it should display the result and highlighting the search text in different color. But when i use the search text with more than one word, the result is highlighting only the last word of the search text.
Example - If i search for "Opal" , the search result highlighting all the words with "opal", But when is search "Opal Service", the search result is highlighting only the "service".
Here the "Opal" and "service" are different identities, i will search these two words with AND condition . Code:
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
View Replies View Relatedi'm converting an image file to hexa..then the hexa is saved to a text file..
can any one help me how to read the content text of a text file?...
im doing it this way because i don't want to save hexa in my database, because it makes the database slower to open up.
Does anyone know of a method of converting text files to sound files (.wav, mp3 etc) which can be accessed from ASP?
I have an ASP-based website that enables users to design choreography for equestrian dressage. The resulting design is held as a series of coded movements in a database and it can then be reproduced as text or as a series of diagrams. I would like to offer the option of an audio version.
I do create a directory to save a lot of pdf file with different folder/sub folder. I am thinking of using a asp page for user to search on a file that they are looking for. User only key in either no a part or full file name and the page will search the directoies and display the file name as link to let the user click on it.
View Replies View RelatedI need to create a vbscript that will search a specific directory for a file with the current date, and if it exists then send it as an attachment via email, and if not, send a different email. The script will run everyday and search the same directory everytime for the current date's file.
View Replies View RelatedI am trying to come up with a web tool that can do a file search that matches user input within a directory and also its sub directory. I did some research and think FOS can do the thing, but need more help on it. Any idea or it would be great if anyone can supply me a function or a subroutine?
View Replies View RelatedDoes anyone have knowledge of converting text file to .iff file. I am working on a VB ASP application. I searched for example on internet but I didn't get anything.
If you have any idea of converting text file to .iff file (VB ASP) please share with me.
I want to read an asp file as a text file. The problem is that the file that I want it to read is located on a server. For example: I want to read te content of this file: http://www.bnro.ro/Ro/Info/default.asp . I want to look after some values in that file.
View Replies View Relatedwhat im trying to do is write out certain files that our in a current folder. For example I have a folder called images and i have about 20 sub folders inside of the images folder. What i want to do is search the Images folder including all the subfolders and write the name and path of where ever the image was found inside of the images folder.
View Replies View RelatedI am trying to create a search engine to allow to do a keyword search on a file content.
The files are in Word, TXT, and PDF.How can I implement this?
I need to search ms word file with ASP, and find a couple of predefined words. such as "apple" "mac" etc.
View Replies View RelatedIs it possible to search a specific directory for the most recent file and list when it was modified.
View Replies View Related