Hello, I am new to the CFGRID and Flash forms.
I have created a grid that the following columns from a table...
mfg, itemid, onhand, avgcost, category, loc, entry(primary key)
The loc and entry column should be hidden.
Update and delete functions work fine.
When adding the loc (location) field needs to automatically prefill with a
predefined variable such as AZ.
Basically when you add the new row the loc should have AZ as the default
value.
Is this possible.
This is what I am using
<cfgrid name="ItemList" query="FOO" height="420" rowheaders="false"
selectmode="edit">
<cfgridcolumn name="category" header="CATEGORY" headeralign="CENTER"
dataalign="CENTER" select="Yes" display="Yes" headerbold="Yes">
<cfgridcolumn name="mfg" header="MFG" headeralign="CENTER"
dataalign="CENTER" select="Yes" display="Yes" headerbold="Yes">
<cfgridcolumn name="itemid" header="ITEM" headeralign="CENTER"
dataalign="CENTER" select="yes" display="Yes" headerbold="Yes">
<cfgridcolumn name="avgcost" header="COST" headeralign="CENTER"
dataalign="CENTER" select="Yes" display="Yes" headerbold="Yes">
<cfgridcolumn name="onhand" header="QTY" headeralign="CENTER"
dataalign="CENTER" select="Yes" display="Yes" type="NUMERIC"
headerbold="Yes">
<cfgridcolumn name="loc" display="No"><!-- needs a default value of AZ -->
<cfgridcolumn name="entry" display="no">
</cfgrid>
Any help would be appreciated.
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281223
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
