openmind — Sun, 16 May 2004 21:15:28 +0000

OK no problem

cgacfox — Sun, 16 May 2004 20:44:51 +0000

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

openmind — Sun, 16 May 2004 08:51:53 +0000

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

#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...

Re: Building a message box for database query output

cgacfox — Sat, 15 May 2004 22:53:44 +0000

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

openmind — Sat, 15 May 2004 22:38:38 +0000

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#