I'm trying to figure out why my query data isn't displaying like I think it
should ;)I have a form that I'm reusing in a couple of different pages, I have
a query that grabs records for display in my form for editing purposes. The
following is what I'm running, please take a look and let me know what it is I
am missing, or not understanding about these variables. If I set the form
values to getpersonnel.First_Name it displays fine, but if the form value is
set to #First_Name# I get nothing.
<cfif IsDefined(fuseaction) AND fuseaction EQ "admin.editadminpersonnel">
<cfset First_Name = getpersonnel.First_Name />
<cfset Last_Name = getpersonnel.Last_Name />
<cfset MI = getpersonnel.MI />
<cfset Degree = getpersonnel.Degree />
<cfset Title = getpersonnel.Title />
<cfset Email = getpersonnel.Email />
<cfset Phone = getpersonnel.Phone />
<cfset Fax = getpersonnel.Fax />
<cfelse>
<cfset First_Name = "" />
<cfset Last_Name = "" />
<cfset MI = "" />
<cfset Degree = "" />
<cfset Title = "" />
<cfset Email = "" />
<cfset Phone = "" />
<cfset Fax = "" />
</cfif>
Here's the form --
<form action="#self#?fuseaction=#XFA.submitForm#" name="#ThisFormName#"
method="post">
<input type="text" name="First_Name" size="30" maxlength="75"
value="#First_Name#" />
<input type="text" name="Last_Name" size="30" maxlength="75"
value="#Last_Name#" />
<input type="text" name="MI" size="1" maxlength="5" value="#MI#" />
<input type="hidden" name="division" value="" />
<input type="text" name="Degree" size="30" maxlength="50" value="#Degree#" />
<input type="text" name="Title" size="30" maxlength="75" value="#Title#" />
<input type="text" name="Email" size="30" maxlength="75" value="#Email#" />
<input type="text" name="Phone" size="30" maxlength="75" value="#Phone#" />
<input type="text" name="Fax" size="30" maxlength="75" value="#Fax#" />
<input type="submit" name="submit_admin_personnel" value="#ButtonText#" />
</form>
TIA Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2762
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
