I have a simple two field form from a query. The first item is a select list
that is populating fine. The text field however is not and for the life of
me I cannot figure it out. Code is below:
Here is the query:
<cfquery datasource="#Request.dsn#" name="qGetQuestionDetails">
SELECT LQuestion, LibraryID
FROM LibraryQuestions
WHERE LQuestionID = #Form.LQuestionID#
</cfquery>
There is another query here for the select list
Form here:
<form action="EditLibraryQuestions.cfm" method="post">
<tr>
<td align="left">
Library:
</td>
<td align="left">
<select name="LibraryID">
<cfoutput query="qGetLibraries">
<option value="#LibraryID#" <cfif
qGetLibraries.LibraryID IS qGetQuestionDetails.LibraryID>
Selected</cfif>>#LibraryName#</option>
</cfoutput>
</select>
</td>
</tr>
<cfoutput query="qGetQuestionDetails">
<tr>
<td align="left">
Question:
</td>
<td align="left">
<input type="text" name="LQuestion" size="70"
value="#LQuestion#" />
</td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" name="Edit Question" /> |
<input type="reset" />
<input type="hidden" name="LQuestionID"
value="#Form.LQuestionID#"</td>
<input type="hidden" name="Action"
value="EditQuestionAction" />
</td>
</tr>
</cfoutput>
</form>
The select query select he proper library. The hidden LQuestionID field is
populated wiht the correct ID, and when I take the query that shows in the
debugging in query analyzer, it works fine, so I know there is nothing wrong
with the query and the code looks fine too. I am dumfounded.
Thanks,
--
Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
