Search More Than 1 Database Table At Once

Im looking for a means to allow the search criteria provided by a user to be checked against fields in more than one recordset table in a ms access database.

Is there a means within asp to check multiple tables at the same time using one set of criteria? So far the only solutions i've seen to this includes the usage of a list box which dictates which recordset is opened. I would like to avoid this.

View Replies


ADVERTISEMENT

How To Transfer Records From One Table Of A Database To Another Table In Another Data

I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?

<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2

Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open

startdate=request("tarikh1")
enddate=request("tarikh2")

MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....

View Replies View Related

Search Within Table

i have a table in a database that saves search activity, it has the following 3 columns:

search_ID (autonumber)
State (text)
Language (text)

what i want to be able to do is create a page that will display the number of searches/filters based on a language. here's what the output would look like:

Count Language
-----------------------
25 English
18 Spanish
14 Russian

so if only those languages were searched there would be only 3 rows, however if more languages would be searched more rows would show up.how would the sql look like?

View Replies View Related

Search Table Only

I have a search engine script that searches my entire site. The problem with it though is it also picks up words in my navigation bars, which is creating results that aren't relavant.

if there is a way of still search the entire site, but just checking a table within the page. This table would then hold the text content for the page, which is all that needs to be searched. Unless there is a better way to do it.

View Replies View Related

Multiple Table Search

I want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:

strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"

the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.

View Replies View Related

ASP Database Table

I want to make an asp table for my database. I have two tables, one with peoples details and the other with their orders. I have done a one to many relationship between these.

What i would like to be able to do is a heading with the customer details, and under that all of what that person has ordered. Then another heading with a different customer and so on..

View Replies View Related

Table In Database

How can i check if my table is already exist in the database?

View Replies View Related

Database Table

Is there an

If no results found in database table
print results in table (made table and such)
Else
repsonse.write("No Results Found")
EndIf

View Replies View Related

Query Database Table

I have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:

View Replies View Related

How To Tell If A Database Table Exists?

You'd think this would be the most basic sql query in the world but noooooo!
I've tried this:

on error resume next
strsql = "SELECT * FROM " & session("TablePrefix") & CurrentTable
SET rs = conn.execute(strsql)

tableExists = 0

if (Err.number = 0) then
tableExists = 1
end if

But it doesn't return an error if the table doesn't exist. I'm searching on
the internet and hitting these long complicatred solutions involving the
database "shema". Surely there is a simple way of telling with one line of
sql if a table exists or not?

View Replies View Related

Backup A Database Table

I need to be able to add a button on my site that will backup an SQL table (not the whole database) - does anyone know how to do that?

View Replies View Related

Database Search;

I have been thinking about this wee problem for a while now, and usually I figure out what I need to do, but in this case I'm drawing a blank And the most annoying thing is that I don't think it should be that hard! I use this code to search a database: Code:

View Replies View Related

Using ASP To Search A Database

My setup is going to be like this:

I have one page that has a few categories on it. When the person clicks on one of the categories it sends the querystring to the next page. That page takes the query string, searches the database and only replies with found results. Thats what I'm trying to setup, I think I'm very close.

I know the request.querystring is being sent properly and receieved properly, because I also have it's name displayed on the next page and that works fine. I know my connection to the database is okay, becasue if I just set it to display the entire database that will display fine.

It's when I try to use the Request.QueryString that was sent to search the database - it returns like it can never find anything. The page displays, no asp or coding errors - just no information.

The database Column I'm trying to have it search is called "Classification". I think that's all the info.. if I'm missing something you need to know let me know. Code:

View Replies View Related

Database Search

Does any one know of any good asp database search scripts. What I'm looking for it to search the database on different criteria or phrases. Eg Kane 400 Boiler.

The user could put in kane 400 and it would pick it up, basically something that you don't have to put in the search how it appears in the database, I have worked on this and works fine if you put the exact phrase in, or one work but if i put in kane 400 it does not work. Also if I put % it lists the whole database, this database will hold 10000 > products so want it not to be to heavy etc.

View Replies View Related

To Search A Database

I'm trying to use information that a user enters into an HTML form to search a database. For example, if a user clicks on a check box stating their interests are 'holidays' then this information needs to be used to search the database for entries that match, ie the entry has a category that states it is about holidays.

The entries in the database are linked to pictures that will then be loaded onto a website.

View Replies View Related

ASP Database Search

I'm having a problem with a simple search. I have a telephone directory where people can search by first or last name. This works great but when someone tries to search for a name with an ' in it you get an error.

Here's my code for the database connection:Code:

sql = "SELECT Staff.[first_name], Staff.preferred_name, Staff.no_location,
Staff.[last_name], Staff.[location], Staff.business_title, Staff.department,
Staff.phone, Staff.fax, Staff.[email]
FROM Staff WHERE (((Staff.[last_name])like'%"
& Request.QueryString("[search-lastname]") & "%')) "

I'm certain it's just a syntax error so hopefully someone can spot it quick. Using a - in the name search doesn't bring the error.

View Replies View Related

Search Database With ASP

I've created a search bar on my site to search a database with job information. I dont know what i am doing wrong, i just want what the user types in to display after pressing search. I thought all i would need is Code:

View Replies View Related

Inserting Data Into A Database Table

i am trying to use the 'Insert into' sql query to insert data in an asp file but having some errors...this is the eror i got from the browser..

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/AddConfirm.asp, line 46, column 36
sql="INSERT INTO tblMembers VALUES("8"," & DateJoined & "",""& Title& "",""& LastName& "",""&FirstName& "",""& DOB & "",""& AddressUnit&"""

this is the code i have in my asp file....

Code:

View Replies View Related

Fetch Random Database Table

There are 26 prizes available in a competition a client is running and he wants to be able to select these at random.

I thought the best way of doing this would be to construct a simple ASP page which displays 26 random records from the database.

The fields I wish to display are called name, email and address, and these are located in the table called Competition (this is an MS Access db).

View Replies View Related

Asp Database Pull From A Query Not A Table?

it possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?

View Replies View Related

Fill Table With Database Query

I want to retrieve a large number of rows from my database (Select SomeColumns from myDatabase)and then to fill a table with the retrieved data. What can i do?

View Replies View Related

Generate An HTML Table From A Database

I am using ASP to generate an HTML table from a database. I use FSO to output a file with an XLS extension then open it. I can set the column width and row height; I can set the font family, size, and weight. I know I can include formulas in a "cell".

What else can I do when I generate the table that will take effect when the file is opened in Excel? I'd like to do things like autofit and sorting. The client does allow Office Automation on the server so I can't write to Excel directly.

View Replies View Related

All Database Fields Search

I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.

View Replies View Related

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!!

View Replies View Related

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?

View Replies View Related

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.

View Replies View Related

ASP Access Database Search

I'm having trouble figuring out how to do a freetext search in my ms access db table. Code:

View Replies View Related

Should I Use LIKE Or InSTR For A Database Search?

Which is better practice?

Code:
Select * From groups Where groupName LIKE '%bli%' AND cusType LIKE 'CUST%'
or

Code:
Select * From groups Where InStr(groupName,'li')>0 AND InStr(cusType,'CUST')=1
Right now I'm using and Access database but plan to upsize to a MSSQL if that makes any difference. Are there any advantages or disadvantages to either technique?

View Replies View Related

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.

View Replies View Related

Keyword Database Search

I have been searching for a way to search a database based on keywords. All I can seem to find is google searches. All I want to search is my own database.The db contains inventory for a friends store. As list is long he would like to be able to search an item based on item name, supplier, or type.

View Replies View Related

Search On Database Tables

I want to do a searching on database some tables' content, is asp have so function or tool to do this?

View Replies View Related

Database Column Search

I am looking for a asp script, that will do an OR search on keywords in two differant columns in an MySQL database. for example if someone searches for joe bloggs I want to bring back all records that have either of the words joe or bloggs in column one or column two.

I have found a script that does exactly what I want but it will only search one column of a database whereas i would want it to search two columns. http://www.4guysfromrolla.com/webtech/052799-1.shtml

how to modify this code or point me in the direction of some other code that will do the same job.

View Replies View Related

Search A Word In Whole Database

I'm trying to find a Sql query to find a word in all the data of all tables of an microsoft access DataBase.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved