Not sure if this is a bug or just me but I am getting funny results on a page I made. I have a filtered select that does not populate and has a text input box next to the select. Some more squirley behavior is also on the same form I have a text area and if I change it to HTMLArea the page will not load and IE hangs. In Firefox it is fine but I assume that is because it bypasses HTMLArea since Firefox is not supported. Here is the code to the page.
<cfscript>
// Select data
selectClause = "*";
fromClause = "SVR_SUP_MANUFACTURER, SVR_SUP_MODEL";
whereClause = "SVR_SUP_MANUFACTURER.MAN_ID = SVR_SUP_MODEL.MAN_ID";
qry_manmodel =
Application.DatabaseBlocks.SelectRecords(selectClause:selectClause,
fromClause:fromClause,
whereClause:whereClause);
</cfscript>
<cfmodule template="#Request.layout#/Header.cfm" pageType="svr">
<cf_DisplayAddForm table="SVR_HARDWARE" label="Add a SVR HARDWARE"
action="#Application.absoluteUrlRoot#/svr/SVR_HARDWAREAddAction.cfm"
displayALinkToThisList="SVR_HARDWAREList.cfm">
<cf_DisplayFilteredSelect parentTable="SVR_GENERAL" primaryKey="SN"
primaryKeyType="varchar(100)" foreignKey="SN" displayColumn="SN"
displayColumnType="varchar(100)" label="SERIAL NUMBER" required="Yes">
<cf_DisplayFilteredSelect parentTable="SVR_SUP_SVRTYPE"
primaryKey="SVRTYPE_ID" primaryKeyType="varchar(10)"
foreignKey="TYPE_ID" displayColumn="TYPE"
displayColumnType="varchar(100)" label="TYPE" required="Yes">
<!---<cf_DisplayFilteredSelect parentTable="SVR_SUP_MANUFACTURER"
primaryKey="MAN_ID" primaryKeyType="integer" foreignKey="MAN_ID"
displayColumn="MANUFACTURER" displayColumnType="varchar(50)" label="
MANUFACTURER" required="Yes">
<cf_DisplayFilteredSelect parentTable="SVR_SUP_MODEL"
primaryKey="MOD_ID" primaryKeyType="integer" foreignKey="MOD_ID"
displayColumn="MODEL" displayColumnType="varchar(50)" label="MODEL"
required="Yes">--->
<cf_DisplayExtraFormContent>
<tr>
<td><B>MANUFACTURER/MODEL </B></td>
<td>
<CF_TwoSelectsRelated
Name1="Manufacturer"
Name2="Model"
Query="qry_manmodel"
Value1="MAN_ID"
Value2="MOD_ID"
Display1="MANUFACTURER"
Display2="MODEL"
EmptyText1="(Choose One:)"
EmptyText2="(Choose One:)">
</td>
</tr>
</cf_DisplayExtraFormContent>
<cf_DisplayFilteredSelect parentTable="SVR_SUP_PROCESSOR"
primaryKey="PROC_ID" primaryKeyType="integer" foreignKey="PROC_ID"
displayColumn="PROCESSOR" displayColumnType="varchar(100)"
label="PROCESSOR TYPE" required="No">
<cf_DisplayTextInput column="PROCESSOR_AMT" label="PROCESSOR AMT"
type="varchar(10)" required="No" size="10">
<cf_DisplayTextInput column="MEMORY" label="MEMORY"
type="varchar(10)" required="No" size="10">
<cf_DisplayHTMLArea column="NOTES" label="NOTES" required="No">
<cf_DisplaySubmitButton buttonText="Save">
</cf_DisplayAddForm>
<cfmodule template="#Request.layout#/Footer.cfm">
I also attached a pic of the form.
--
Tim Blankenship
[EMAIL PROTECTED]
filtererror.bmp
Description: Windows bitmap
