can i search a database field for a specific word. for example i have a field in my user database(access database) called name and in that field i have more than one name that is separated by a comma such as john,james,mike,etc.
is it possible for a user to key in into a textbox for instance james and click search than only the name james will be shown. i just want to know is asp how the select statement will look like.
I am having trouble getting my scripting to look in more than one database field when presenting results from one form field.
I can get it to work when there is more than one form field but I am trying to get the system to look in both a description field and keyword field then present the results.
The problem area is: Code:
formFields = Array("name", "shop", "suburb", "city")
dbFields = Array("shoptitle", "shopdesc", "shopsuburb", "shopcity")
The formfields and dbfields relate to each other. What is want is 'shop' to look not only in shopdesc but also in shopkeywords I have tried commas with out quotes, semicolons etc etc Code:
I've had a site built for me but the programmer got on my tits for a variety of reasons - I know nothing about databases and need someone to help me sort out a fairly simple problem with two search fields.
(URL address blocked: See forum rules) is a site that will offer users the ability to sell and swap books online but the second and third search fields on the home page are returning no results.
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
I'm trying to create a search page with a beginning and ending date, but I can't seem to get it to work. I am using SQL Server. Here is my statement:
SELECT *
FROM dbo.REQUEST2
WHERE REQUEST_DATE BETWEEN ' " & Request.Form("txtBeginDate") & " ' AND ' " & Request.Form("txtEndDate") & " '
This statement is not returning any records when I know there are existing records that fit the criteria that I'm entering.
I have a form where I offer the user to enter a 'fromDate' and a 'toDate' whereby I had hopes that it would help return records where the date was between those two values. My SQL query ends with: Code:
AND Date < " & request("fromDate") & " AND Date > " & request("toDate") & "
and a typical date entry in the table looks like: 2/8/2005 .
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 want someone to enter an area code in a field. They would hit search, and it would pull up all records whose phone number starts with that area code entered. Code:
View Replies View RelatedHow to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other:
contact table id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
I have an access db called boards and a table in it called notes. I have 3 fields in the table ID, subject, and notes. I have code to search the db and display the results in the notes field.. This code works very well. I wanted to modify this code so that I can use a dropdown menu instead of type in the search field but i cannot get the dropdown menu code to display the search results. Code:
View Replies View RelatedI am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
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.
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
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:
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies View RelatedI want to know what's the differences between
Request.Form("Field Name") and
Request.QueryString("Field Name")
OR they function exactly the same, which is to return the value of the
field??
I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
View Replies View Relatedi have a database with 5 tables,
on my web site i have a search bar..
i wana link that search bar to my tables so..
when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
I was wondering if there was a way to search pages using ASP or ASP.NET.
I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?
how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.
View Replies View RelatedI have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
View Replies View RelatedNeed help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah
How to write my code so that even if its not End of record, it will still search my db?
In short : I want the db to be able to search under 2 circumstances : EOF and not EOF
How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.
I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
I'm make a search and I want to limt the results to 10 and have a next button.
View Replies View RelatedWith Index Server I can search web pages stored on our servers. Is there any
way to programmatically search web pages on the web ?
I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.
This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code: