I have a cfgrid that cfloop queries it's data from msAccess. I want to update
these data via the grid and have it automatically be inputted into a form (ie:
input type) before it gets submitted into a different table. Is this possible
to do? Can anyone help me jumpstart this one?
The codes is as follows:
<!--begin section5 SPACE REQUIREMENTS table-->
<p><center><fieldset><legend><b>SPACE REQUIREMENTS</b></legend>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table cellspacing=0 cellpadding=0 border=0>
<tbody>
<tr>
<td valign=top background="img/marble4.jpg">
<div align=center>
<div align="center">
<table border="0" cellspacing="0" cellpadding="5"
align="center">
<tr>
<td align="right">
<cfif #session.group# is "PM" or #session.group# is "AD" or #session.group# is
"Director">
<cfgrid name="space"
height="340"
width="381"
insert="No"
delete="No"
sort="No"
font="Verdana"
bold="No"
italic="No"
appendkey="No"
highlighthref="No"
griddataalign="RIGHT"
gridlines="Yes"
rowheaders="No"
rowheaderalign="LEFT"
rowheaderfont="Verdana"
rowheaderitalic="No"
rowheaderbold="No"
colheaders="Yes"
colheaderalign="CENTER"
colheaderitalic="No"
colheaderbold="Yes"
bgcolor="white"
selectmode="BROWSE"
picturebar="No"
SORTASCENDINGBUTTON="A -> Z">
<cfgridcolumn name="counter"
headeralign="LEFT"
dataalign="LEFT"
bold="No"
italic="No"
select="No"
display="No"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="projectNumber"
headeralign="LEFT"
dataalign="LEFT"
bold="No"
italic="No"
select="No"
display="No"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="typeOfSpace"
header="Type of Space"
headeralign="CENTER"
dataalign="CENTER"
width="250"
font="Verdana"
bold="No"
italic="No"
select="No"
display="Yes"
headerfont="Verdana"
headerbold="Yes"
headeritalic="No">
<cfgridcolumn name="projectNASF"
header="Project NASF"
headeralign="CENTER"
dataalign="RIGHT"
width="105"
font="Verdana"
bold="No"
italic="No"
select="Yes"
display="Yes"
type="NUMERIC"
headerfont="Verdana"
headerbold="Yes"
headeritalic="No">
<cfloop query="getTypeOfSpace">
<cfgridrow data="0,0,#spaceName#,0">
</cfloop>
</cfgrid>
<cfelse>
<cfgrid name="space"
height="340"
width="381"
insert="No"
delete="No"
sort="No"
font="Verdana"
bold="No"
italic="No"
appendkey="No"
highlighthref="No"
griddataalign="RIGHT"
gridlines="Yes"
rowheaders="No"
rowheaderalign="LEFT"
rowheaderfont="Verdana"
rowheaderitalic="No"
rowheaderbold="No"
colheaders="Yes"
colheaderalign="CENTER"
colheaderitalic="No"
colheaderbold="Yes"
bgcolor="White"
selectmode="EDIT"
picturebar="No"
SORTASCENDINGBUTTON="A -> Z">
<cfgridcolumn name="counter"
headeralign="LEFT"
dataalign="LEFT"
bold="No"
italic="No"
select="No"
display="No"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="projectNumber"
headeralign="LEFT"
dataalign="LEFT"
bold="No"
italic="No"
select="No"
display="No"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="typeOfSpace"
header="Type of Space"
headeralign="CENTER"
dataalign="CENTER"
width="250"
font="Verdana"
bold="No"
italic="No"
select="No"
display="Yes"
headerfont="Verdana"
headerbold="Yes"
headeritalic="No">
<cfgridcolumn name="projectNASF"
header="Project NASF"
headeralign="CENTER"
dataalign="RIGHT"
width="105"
font="Verdana"
bold="No"
italic="No"
select="Yes"
display="Yes"
type="NUMERIC"
headerfont="Verdana"
headerbold="Yes"
headeritalic="No">
<cfloop query="getTypeOfSpace">
<cfgridrow data="0,0,#spaceName#,0">
</cfloop>
</cfgrid>
</cfif>
</td>
</tr>
</tr>
</table>
</div>
</div>
</td>
</tr>
</table>
</td>
<td>
<table cellspacing=0 cellpadding=0 border=0>
<tbody>
<tr>
<td valign=top background="img/marble4.jpg">
<div align=center>
<div align="center">
<table border="0" cellspacing="0" cellpadding="1"
align="center">
<tr>
<tr><td align="right">Instructional Subtotal</td><td> <input type="text"
name="instructionalSubtotal" size="12" maxlength="15"
onChange="window.document.projectIdent.datasave.value=msg"></td></tr>
<tr><td align="right">Instructional Supp. Subtotal</td><td> <input type="text"
name="instructionalSuppSubtotal" size="12" maxlength="15"
onChange="window.document.projectIdent.datasave.value=msg"></td></tr>
<tr><td align="right">Other Subtotal</td><td> <input type="text"
name="otherSubtotal" size="12" maxlength="15"
onChange="window.document.projectIdent.datasave.value=msg"></td></tr>
<tr><td align="right">Total Net</td><td> <input type="text" name="totalNet"
size="12" maxlength="15"
onChange="window.document.projectIdent.datasave.value=msg"></td></tr>
<tr><td align="right">Eff. Factor<p></td><td> <input type="text"
name="effFactor" size="12" maxlength="15"
onChange="window.document.projectIdent.datasave.value=msg"><p></td></tr>
</tr>
</table>
</div>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table></fieldset>
</center>
<!--end section5 SPACE REQUIREMENTS table-->
Thanks!
-RogerE
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1433
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
