results wizard using drop down box

[Andrew Murray]

I'm using the results wizard and the dropdown form componet to display a single
field of data, which is used as part of a search form If I have no data in a
particular database/field is there a way to populate the form field with "No
Data" like with the "no results found" message.

See here http://www.aym.perth.anglican.org/main.asp

Under the section "Resource Centre". (no data at all but I want a "No Data"
message in the drop down box instead of just a blank box.

I'm only using the limited functionality of Frontpage's results wizard, it
doesn't seem to have this built in.

If the fp generated asp code it still has a variable as follows:

fp_sNoRecords="No available Log Entries to Display."

which is what I want to display within the drop down box, if there is no data to
display.

thanks

--
Andrew Murray
Remove NOSPAM or SPAM BUSTER to reply
to reply

Outgoing message has been scanned with Norton Antivirus..

 

[Kathleen Anderson [MVP - FP]]

I would add a placeholder record to the database with a value of "No data"
in the resource title field.

That being said, what do you expect will happen if someone selects it and
hits the Go button? Wouldn't you be better off just leaving it off your page
until you have the data?