Business description: Users choose from a dyanmic drop-down
menu, the fields and values of which are set by the database. The
non-selected options provide data for a session variable that is
compared to values in the database and information is presented
accordingly. This works as planned. However, if users leave the
initally-selected option chosen, which is ok, I get this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been
deleted. Requested operation requires a current record.
It happens that the same information displayed when one of
the dynamic options is chosen is also appropriate when the default
option is chosen. I have set the value of the default option to be
the same value as one of the dynamic drop-downs (that value is $20
adults/$10 kids), and used this IF statement:
<% if (rs_recordset.Fields.Item("Column").value == "$20
adults/$10 kids") { %>
Text here
<% } %>
How do I present specific information on the resulting page
if the user leaves the initially-selected option chosen in the
drop-down? Thanks.