results display

N

Nicole

In frontpage I have a database results page. Someone can
enter certain criteria, if it is matched then it will
display that criteria.If not a message appears. I would
like for there to appear an animated character or text,
whne the criteria is matched. Does anyone know how I can
do that... Thanx
 
J

Jim Buyens

-----Original Message-----
In frontpage I have a database results page. Someone can
enter certain criteria, if it is matched then it will
display that criteria.If not a message appears. I would
like for there to appear an animated character or text,
whne the criteria is matched. Does anyone know how I can
do that... Thanx

Do you mean that you want the results to consist *Solely"
of the animated character or text, or that you want the
normal, tabular results *plus* the animated character or
text?

Also, would the animated character or text come from the
database, or would it be a constant?

Basically, I'm thinking along the lines of a DRW with the
same criteria that you have now, but with no heading, no
forward and back buttons, and with a single output field
not taken from the database. The query would look
something like:

SELECT "<P>The message<img src=animatedchar.gif></P>"
AS myresults
FROM mytable
WHERE (mycriteriafield = '::myformfieldvalue::')

and then, in the Column Value Properties for myresults,
selecting the Column Value Contains HTML checkbox.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
N

Nicole

I want both the text and the animation. I'm not sure about where it should come from-which would be easier. My databse has hundreds of thousands of entries.
 
Top