Building a message box for database query output

Use an sql query to try and match the words so

SELECT *
FROM table
WHERE actor LIKE '%#searchPhrase#%'

and then just output the results:

#actor#

Here is the code that is on the main page for looking up info.

Enter name of the Actor that you are interested in seeing.

Does your example code go on the mainactors.cfm page?

Here is the code for the mainactors.cfm page for the output information as it currently is.

Select *
From DVDS
WHERE mainactors LIKE '%#FORM.mainactors#%'
Order by MovieTitle

Here is the code that will display the results of the query on the mainactors.cfm page.

#movieTitle#

#genre#

#parentalRating#

#mainActors#

I want a pop up message box to show that the query does not result in any matches either because it is not present or it is misspelled. Am I making sense? Thanks.

Cori

Thats pretty stright forward to do. Just change your code as follows:

First you need to do a quick count of how many results were obtained.

If none do the pop up. If more than 0 then show them...

<script language="javascript">
alert("Your search has resulted in no matches. Please try again");
history.go(-1);
</script>

#movieTitle#

#genre#

#parentalRating#

#mainActors#

To be honest you are better off not using the popup because it would look smoother just to write the text "no matches" or whatever rather than stick it in a pop-up...

Thank you very much. This works!! Now I can go on to the next step, which is using a data entry form online to add more movies. I am having some difficulties with this one as well. I will play with it some more and if I need help I will definitely come back here for some pointers. Again thank you!!

Cori

OK no problem