Access Search Function
I have a neat database running and im trying to place a search engine thro it. I have quite a few tables, BUT i can only get the query in one table. ie Code:
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Search Function
i am wondering how I would go about making a search page on my site??? Basically, i want a field in my SQL dbase called keywords so i can put general words in i.e. Apple, Bannana, Kiwi etc. However, I want the page to be able to do 2 thngs: 1. If someone types "APPLE" the page will display all the records where the keyword is entered in the field 2. If someone types "Apples" and "Bannanas", the page will display all the records where the keywords is is entered in the field.
Search Function
i have a site that shows my dvd collection i have this call from the database and i want to add a search function in the same page (not the datbase) so when someone wants to search for say "Shrek" it will bring up the search results on the main page and should show "shrek 1 and shrek 2" , Also in the same light if someone searches by Actor all the films that actor has been in will appear on the main page I have created the Form Form in Dreamweaver Code: <form name="form1" method="post" action=""SELECT * FROM movies WHERE title = " & request("q") & ";""> <input type="text" name="textfield"> Search </form>
Search Function
Does anyone know of a tutorial or other source that addresses the following problem: I have a textbox (txtSearch) and a drop down box.I want to enter text in the textbox, and then select the table column to search using the drop down box i.e. Search for: Johnson (txtbox) Search by: Surname (ddbox)
Search Function
I have a page where I enter a keyword and I search for that keyword in my database. I want to highlight the word that is/was searched for in the results. My results consists of values out of varchar and text fields.
Search Function
i have numerous tables to search through for a 'site search'. some of the searchble fields have html embeded within so after some quick referencing, saw I can use the regExp function to strip out all the HTML leaving only the raw text. what is the best method to remove alot of words such as "a", "and", "I", "so", "that", "this" ...etc ... from the search string leaving only keywords essentially per page/field that will be searched within for the occurance of the users' input text through a input field. The idea being to only return the suitable records without alot of rubbish.
Asp Search Function
I have a asp/mysql real estate site that someone else created and I don't know much about asp. If you view all the homes listed on the site you get all the listings which is now 4 pages and growing http://arizonarenttoown.com/homes.asp There is no sort or search capabilities so the list is too long and needs to searched by city. I have some real estate websites that I created with a open source script, open -realty.org. They are php & mysql and have search pages so I can easily create a link for each city. When the link is clicked a search page displays only listings for that particular city. Code:
Search Function W/out A Database?
I would like my ASP-based site to have a search box to bring up a list of relevant pages according to user-defined search criteria. Q: Do I need to have a d/b like SQL Server 7 at the back end to process and match the search string? Or can I do w/out a d/b somehow and run a search, and somehow still bring up the same results? If a d/b isn't necc, pls. advise on webpages where I can find such ASP-search codes.... TQ!!
Search Engine Function
i want to do a search function for my project, my project is allow user to upload file into my server and sharing among each other,i need to do a search engine function to allow user to search for the file that they want, can i know there a function can search through the server's file implemented in asp?or may i know there any open source search engine function coding for me to refer?
Database Search Function
I have a page that uses the data from the previous pages form to search the data in the database and dispaly any matching results. On doing so i get this error: Error Type: Microsoft VBScript compilation (0x800A03F9) Expected 'Then' /IT/searchresults.asp, line 20, column 15 If Request.Form"(Typesearch") = "computer_name" Then My statement has a then in the statement already.
Recursive File Search Function Bug
I've recently made a recursive sub in asp to search all folder and subfolders of the map "file" for a certain filename. It will list all results and show a link. Now there's still a bug. I can't place files in the root because this script won't find 'em. The root i mean files. If i replace the empty dir with Server.MapPath("") it will show the files in the root but it will show 'em twice. Code:
Advance Search Text Function
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?
ASP: Code Search Function For Chinese Site
Got a chinese website (has both chinese character and english), got to code search function for it, search for keywords in the webpages (htm/asp) search in english it works, no problem search in chinese it doesn't - it always return "nothing found" you guys any idea?
Access 2K Search
I have two ASP pages. One to make a booking and the other one to search for bookings in Access 2K db. The booking number is text+numbers: BLAH1234. Here is the problem. The search does not work, no errors - it returns an empty page, with BLAH1234 (field is Text) but works with just 1234 (field is Number). I need help to figure out how to be able to search for BLAH1234 . In other words how do I convert BLAH1234 into Test string or Number string? I am an amature so any critisism and pointers are welcome.
ASP Search (Access DB)
my entire website is driven by an Access database. I've successfully setup a search function - which works beautifully until I include an Access table where at least one of the searched fields is empty. I have manually created a SQL query using UNION in my database: "searchSQL". I assume I adjust my SQL statement on my ASP page to ignore blanks? Eg: "WHERE title<>"" and LIKE..." but I'm obvsiouly using incorrect syntax. How do I say - "only if FIELD is NOT BLANK check if LIKE"; or should I be doing this within the Access SQL statement? Code:
Calling Access Vba Function From Asp?
I have an asp module connecting to a MS-access database. I have a vb function MKDate(date, time) in a vba module of this database. I would like to query : SELECT MKDATE(col1, col2) FROM TABLE1 (real query is complex, using unions, etc, but I need one column in resultset) But I get an error opening the recordset "Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in expression. /selfmail/dossier.asp, line 729" I also tried to copy the code of the function MKDate(date, time) inside ..asp module, no change. Is it possible to call a vba function inside an asp sql statement?
ASP Function To Return Value From Access DB
i am trying to write a function which will add an entry to to a table in my DB and then return me one of the values of the newly added entry. For e.g. I use the function to add a new Order Entry into the DB, but i would also like the function to return me the value of the OrderID field for the new entry. Code:
Access Database Search With ASP
I have built a small cms driven website using asp and access database. There is nothing special about it, it has about 5 tables each containing unique data. I want to add a search field on all pages which will search the entire database and present the results. I have been searching for hours now and cant find a script that suits my needs. Can anyone point me in the right direction or reccomend a script?
Date Search In Asp And Access Db
i am trying to do a search on a database within a date range but the query pulls in details from before the time submitted. For example : records : 01/05/2006 Test 06/06/2006 Test 2 06/06/2006 Test 2 If i do a search between 06/06/2006 and 06/06/2006 i will get the 01/05/2006 record as well as the 06/06/2006 records, my code is as follows. Code:
Search All Tables In An Access Db
how do you search all the tables in an access db with different field names? i would like to place a textfield and a dropdown of the different tables of the db. i cant figure it out. im using asp and dreamweaver.
ASP Search W/ Access Database
I would like to get asp code for searching database.I have data in Ms Access. I want to search by catagories. A dropdown list to choose to narrowdown search. If keyword found, create a hyperlink of the location so that easy to view.
ASP Search Using Query In Access Database
I have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias. NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in... Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
Asp Search Returns No Results From Access Query
here's what i want to do. from an asp page, perform a search on a table in access. i have used sql code in the asp page itself, but i'd rather execute a query in access. i have success in running any query (basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for some reason, when i execute the query below from the asp page, i get no results. the search.asp page just has a text box in a form that submits the srchBOX field to the results.asp page. here's the asp code from the results.asp page: Code:
Need To Convert Google Search Ref To Find What The User Search
i get the ref url that come to my site and i want to convert it to find out what was the query in (google or other searcher sites) foe example : if someone goes to google and search some text and my site was in his resaults and he click on it , in my site i see his link ref like http://www.google.co.il/search?hl=i...91-Google&meta= i want to know (in asp and save it to DB) what was the word or words that the user write in search engine.
Function Inside A Function
Can I define a function inside a function. e.g; function abc() function xyz() ....some code..... End Function End Function I googled this but can't find any related topic.
Function In The InStr Function
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example: I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
Search Within Search Results
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results. The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
ASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB. The error is similar to: The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data. I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me. Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
Access A MS Access Database Using ASP But On A Linux Box
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux. <code>Dim MM_connPang_STRING 'MM_connPang_STRING = "dsn=pangDSN" MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
MS Access - Table Access Problem
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table". If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's. How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
Access Remote Access Database From ASP
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ". The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
How Many People Can Access The Same Access Database
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time... If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
Write Access To MS-Access
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
Asp Function
I am trying to call a function in asp to check to see if a varibale has a value stored in it if there is nothing wite the value NA into it. My code is <% Function NullValues(userField) if userField = "" then userField = "NA" end function AccountNo = "" Name = "sam clowes" email = "" AccountNo = (NullValues(AccountNo)) Name = (NullValues(Name)) email = (NullValues(email)) response.Write AccountNo & "<br>" response.Write Name & "<br>" response.Write email & "<br>" %> When I run this code ALL the variables are blank and nothing is output
XML/XSL & ASP Function
the function <% Dim objXML, objXSL Function ShowXML(strXML,strStyleSheet) Set objXML = CreateObject("MSXML.DOMDocument") Set objXSL = CreateObject("MSXML.DOMDocument") objXML.load(Server.MapPath(strXML)) objXSL.load(Server.MapPath(strStyleSheet)) Response.Write objXML.transformNode(objXSL) Set objXML = Nothing Set objXSL = Nothing End Function %> calling the function in an asp file <%Call ShowXML("http://msn.foxsports.com/feedout/syndicatedContent?categoryId=142","nhl/xsl/news/teamNews.xsl")%> the errors 1. the http:// part 2. and the ? mark the error message says that the path has been typed wrong.
Function
the user can key in variable A and B then C is auto generated by C = A / B so how and where should i write the C function??
XML Value Into ASP Function
Possibly a very simple question but how do I get a value out of an XML document so I can play with it in ASP E.G: <Name>Tom</Name How do I pull the work tom into asp
Mid Function
6408373-SALE-11/1/2007 From string, i want to extract "SALE" How to do it using mid and Instr ? Also, 6408373-DECLINE-11/1/2007 From string, i want to extract "DECLINE". How to do it using mid and Instr ?
Now() Function
I am using the now() function to be displayed on an email after a form submission has been sent. The problem is that the server is not in the same timezone as I am for the result. How do I adjust the hours on the now() to allow for this please ?
Sub Or Function
I know the basic difference between a subroutine and a function is a subroutine performs a task and a function performs a task and returns a value. The Call keyword is required when using parens with subs with more than 1 parameters. Parens around values passed are ByVal vs ByRef and is a waste of processing if passed ByRef for no reason. I am told there is no reason to ever use a subroutine as a function can be used even if it doesn't return a value. While this appears to be true, is there any reason why it's ever a bad idea to use a function, instead of a subroutine, that doesn't return a value? Are there memory, performance, etc. issues?
ASP Function
I am trying to locate information on how to call a sub within VBScript on an ASP page but I can't locate generic information. What I want to do is generate a page that will stay up but the information on it will change based on a series of drop down boxes. I need the first drop down box to call a second dropped down box based on the state that is chosen then city and so on.
Asp Function
I have a column in the table which contains 2 full names seperated by "&" (e.g: Joe Smith & Jeff Scott) I want to display only the first names of the whole record in an asp page. Is there an asp function using which i can do this?
Mod Function
im using the mod function to create a calendar for me, which everything works perfectly, all is totally well with that! but...when i use the mod function it churns out this loooooooooong string which is the whole table... if there is some way that i can insert hard breaks IN THE CODE ITSELF.
NaN Function
I used to be quite an experienced ASP programmer but I haven't used it for a while I’m trying to do something that I remember as very simple I'm trying to check that the value of a form text box is numerical using the isNaN function. The code I am using is: <% quantity = Request.Form("number1") if isNaN(quantity) = true then Response.Write "Your input was not a number" else Response.Write "Your input was a number" end if %> All I get is a NaN type mismatch error.
Contains Function
Is there a function to check to see if a string contains a space Thanks
Mid Function
I was just wondering when using the mid function how does the assigment work when the length is longer then string itself? For example test = mid(12345, 1, 10) What would be the end result of test?Would it be 0000012345 or 1234500000 or 12345?
|
TRACKER
