Duh ...nevermind <grin> > -----Original Message----- > From: Bob Imperial [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 24, 2007 8:55 AM > To: CF-Newbie > Subject: Need help with records not displaying... > > 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 > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Newbie/message.cfm/messageid:2763 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
