FP: Drop-Down Populated by IDC Query Shows Code Not Data (159437)
The information in this article applies to:
- Microsoft FrontPage 97 for Windows with Bonus Pack
This article was previously published under Q159437 SYMPTOMS
When you insert a drop-down form field into the detail section of
an .htx file, FrontPage does not include a way to populate the drop-
down with data from the IDC query.
CAUSE
The HTML construction necessary to achieve this effect is character
based rather than tag based. This particular implementation, although
popular, is not defined in any of the working documents of the
Internet Engineering Task Force. When FrontPage parses this type of
construction, it is unable to fit it within a logical tree based on
HTML standards.
RESOLUTIONMicrosoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
To create a list box populated by an IDC query that returns the value
of the selected option, use the HTML Markup command on the Insert menu
in FrontPage Editor and insert code similar to the following
<SELECT name="your_list_box">
<%begindetail%>
<option><%The_field_you_want_from_your_recordset%></option>
<%enddetail%>
</SELECT>
where "your_list_box" is the name of the drop-down, and
"The_field_you_want_from_your_recordset" is a valid field in the
recordset returned by the IDC query associated with this .htx file.
| Modification Type: | Major | Last Reviewed: | 6/18/2005 |
|---|
| Keywords: | kbprb kbusage KB159437 |
|---|
|