help with search feature

[dosima]

hi
i am using dreamweaver mx and asp and trying to create a multiple search
feature
i have a database about movies created in access
the tables are movies, actors, directors, movie actors and movie directors
(please suggest another idea i you feel this is wrong)

on the search page i want to search by users entering text in the provided
textboxes
they can enter a movie title, an actor name, a dirctors name or by year

this is how the earch page has been created, but i cannot create the results
page.
so far i have tried creating recordsets and entering the sql where clause on
the advanced recordset, but whenever i type a criteria in the search field, it
is either returning all the fiels in the database or showing an error message.

please can someone help me understand how to create the recordset and what the
sql statement should be
or can someone please guide me on how to create the search feature

thanks in advance

[Nathon Jones]

Dosima,

Are you trying to retrieve results, on your results page, that shows data
from multiple tables?

I'm pretty new to this myself, but maybe something like this...

SELECT *
FROM dbo.movies, dbo.actors, dbo.directors etc
WHERE dbo.movies.moviename LIKE "%formvariable%" OR dbo.actors.actorname
LIKE "%formvariable%"

I know you can create one recordset (for your results) that takes data from
multiple tables, so the above code may not be exactly correct....you'd need
to play around with it a little. At the bottom of the Advanced window,
you'll see options for SELECT, FROM and WHERE. Use this to select multiple
tables (simply click the table you would like and then click the SELECT
button, then the same for fields etc.

I hope this helps. Maybe if you provide more information though, such as
the error message you receive.

Nath.

"dosima" <webforumsuser@macromedia.com> wrote in message
news:d32sao$5bm$1@forums.macromedia.com...

> hi
> i am using dreamweaver mx and asp and trying to create a multiple search
> feature
> i have a database about movies created in access
> the tables are movies, actors, directors, movie actors and movie directors
> (please suggest another idea i you feel this is wrong)
>
> on the search page i want to search by users entering text in the provided
> textboxes
> they can enter a movie title, an actor name, a dirctors name or by year
>
> this is how the earch page has been created, but i cannot create the
> results
> page.
> so far i have tried creating recordsets and entering the sql where clause
> on
> the advanced recordset, but whenever i type a criteria in the search
> field, it
> is either returning all the fiels in the database or showing an error
> message.
>
> please can someone help me understand how to create the recordset and what
> the
> sql statement should be
> or can someone please guide me on how to create the search feature
>
> thanks in advance
>