1. depending on the forum the query result (single result, multiple rows, large amount of text, etc.) would depend on whether I use an actual tool tip or use DHTML to construct a tooltip-like display.
if the result is a number/date/snippet of text i would go with a tool tip. if the result needs to be formatted, is a large amount of text, or contains multiple rows I would go with DHTML.
2. If your architecture allows for it, I would calculate these values ahead of time, off line. this keeps the UI responsive.
3. I would load the calculated values when the page loads to keep the design simple.
the other alternative is to
run the query and preform the computation while the user is waiting for the results. this would be done, either when the page loads, or through an ajax call.
if this is done with ajax I wouldn't use the tooltip at all. i would go with DHTML.
Jason Meckley
Programmer
Specialty Bakers, Inc.
faq855-7190
faq732-7259