I am trying to create an update page for an application for road assessments. I am using cfsliders and cfselect to display the raw numbers of an assessment for in the field editing purposes. My sliders work as they should, but I can not seem to get the selected value to work in the cfselect; it diplays the first value in the control table, not the value from the data table. I am using a query for the display and value of the select (rsAlligator) and a separate query for the actual assessment data (rsRATINGRAW).
------------------SHORT VERSIONS QUERIES----
<cfquery name="rsRATINGRAW" datasource="Pave">
SELECT RID, SEVERITY, EXTENT, TRANSVERSE
FROM dbo.EDITRATINGvw
WHERE dbo.EDITRATINGvw.RID=
<cfqueryparam value="#FORM.RID#">
</cfquery>
<cfquery name="rsALLIGATOR" datasource="Pave">
SELECT CLASS, EXTENT, SEVERITY
FROM dbo.PAVEMENTMGMTASPHALTALLIGATOR
</cfquery>
--------------------short FORM-----
<cfform action="EDITRATING.cfm" method="post" name="update" >
<table width="600" border="3" cellspacing="1" cellpadding="1">
<tr>
<td>ALLIGATOR SEVERITY</td>
<td><cfselect
name="SEVERITY"
query="rsALLIGATOR"
value="SEVERITY"
display="CLASS"
queryPosition="below"
width="250"
selected="#rsRATINGRAW.SEVERITY#"
></cfselect></td></tr>
<tr>
<td>ALLIGATOR EXTENT</td>
<td><cfselect
name="EXTENT"
query="rsALLIGATOR"
value="EXTENT"
display="CLASS"
queryPosition="below"
width="250"
selected="#rsRATINGRAW.EXTENT#" ></cfselect>
</td></tr>
<tr>
<td>TRANSVERSE</td>
<td><cfslider name="TRANSVERSE" range="0,3" bgcolor="orange" scale="1" width="300" height="40" lookandfeel="METAL" font="Arial, Helvetica, sans-serif" fontsize="16" bold="NO" align="MIDDLE" label="__ __ " value="#rsRATINGRAW.TRANSVERSE#"></td> </tr>
</table></cfform>
------------------------
I initially tried to use the radio button form that I used for the insert record page, but I do not know how I populate the value of the radio buttons on the update page. Either way, I would appreciate any knowledge or suggestions that you can offer.
Thanks - Matt
------------------SHORT VERSIONS QUERIES----
<cfquery name="rsRATINGRAW" datasource="Pave">
SELECT RID, SEVERITY, EXTENT, TRANSVERSE
FROM dbo.EDITRATINGvw
WHERE dbo.EDITRATINGvw.RID=
<cfqueryparam value="#FORM.RID#">
</cfquery>
<cfquery name="rsALLIGATOR" datasource="Pave">
SELECT CLASS, EXTENT, SEVERITY
FROM dbo.PAVEMENTMGMTASPHALTALLIGATOR
</cfquery>
--------------------short FORM-----
<cfform action="EDITRATING.cfm" method="post" name="update" >
<table width="600" border="3" cellspacing="1" cellpadding="1">
<tr>
<td>ALLIGATOR SEVERITY</td>
<td><cfselect
name="SEVERITY"
query="rsALLIGATOR"
value="SEVERITY"
display="CLASS"
queryPosition="below"
width="250"
selected="#rsRATINGRAW.SEVERITY#"
></cfselect></td></tr>
<tr>
<td>ALLIGATOR EXTENT</td>
<td><cfselect
name="EXTENT"
query="rsALLIGATOR"
value="EXTENT"
display="CLASS"
queryPosition="below"
width="250"
selected="#rsRATINGRAW.EXTENT#" ></cfselect>
</td></tr>
<tr>
<td>TRANSVERSE</td>
<td><cfslider name="TRANSVERSE" range="0,3" bgcolor="orange" scale="1" width="300" height="40" lookandfeel="METAL" font="Arial, Helvetica, sans-serif" fontsize="16" bold="NO" align="MIDDLE" label="__ __ " value="#rsRATINGRAW.TRANSVERSE#"></td> </tr>
</table></cfform>
------------------------
I initially tried to use the radio button form that I used for the insert record page, but I do not know how I populate the value of the radio buttons on the update page. Either way, I would appreciate any knowledge or suggestions that you can offer.
Thanks - Matt