Trying to BIND data from Oracle
this should simple, giving me lot of problems. returning data oracle datagrid, trying use bind attribute on cfinput tag display data. data not display, if change datasource else (ms access), works. has seen problems binding data oracle in cfinput tag? here code:
<cfform name="afscontactinfo" format="flash" width="800" height="350">
<cfformgroup type="panel" label="contacts">
<!--- grid contact names --->
<cfgrid name="contactgrid" query="getafsinfo" height="220" rowheaders="false">
<cfgridcolumn name="obg_no" header="obligor" />
<cfgridcolumn name="name" header="name" />
<cfgridcolumn name="addr_3" header="address" />
<cfgridcolumn name="city" header="city" />
<cfgridcolumn name="st" header="state" />
<cfgridcolumn name="zip" header="zip" />
</cfgrid>
<cfformgroup type="horizontal">
<cfinput type="text" name="sel_name" bind="{contactgrid.selecteditem.name}" label="sel name:" size="20">
<cfinput type="submit" name="submitbtn" value="submit"/>
</cfformgroup>
</cfformgroup>
</cfform>
<cfform name="afscontactinfo" format="flash" width="800" height="350">
<cfformgroup type="panel" label="contacts">
<!--- grid contact names --->
<cfgrid name="contactgrid" query="getafsinfo" height="220" rowheaders="false">
<cfgridcolumn name="obg_no" header="obligor" />
<cfgridcolumn name="name" header="name" />
<cfgridcolumn name="addr_3" header="address" />
<cfgridcolumn name="city" header="city" />
<cfgridcolumn name="st" header="state" />
<cfgridcolumn name="zip" header="zip" />
</cfgrid>
<cfformgroup type="horizontal">
<cfinput type="text" name="sel_name" bind="{contactgrid.selecteditem.name}" label="sel name:" size="20">
<cfinput type="submit" name="submitbtn" value="submit"/>
</cfformgroup>
</cfformgroup>
</cfform>
i figured out. trying reference oracle column
contactgrid.selecteditem.name
and should have been
contactgrid.selecteditem.name
oracle case sensitive
contactgrid.selecteditem.name
and should have been
contactgrid.selecteditem.name
oracle case sensitive
More discussions in ColdFusion and Flash Integrations
adobe
Comments
Post a Comment