If you do run: <cfdump var="#Project_Info#">
right after your run your query, does all the data look correct? Rick -----Original Message----- From: Brett MacDonald [mailto:[email protected]] Sent: Friday, January 29, 2010 12:08 PM To: cf-newbie Subject: Re: error in posting form? Sorry. I thought that would be legible but the code definitely came out hard to read didn't it? I'll try it again <CFQUERY NAME="Project_Info" DATASOURCE="Projects_DB"> SELECT * FROM Gen ORDER BY McsalProjNumb DESC </CFQUERY> <html> <head> <title>Page Name</title> </head> <body> <table border="1" cellpadding="2" cellspacing="0" bordercolor="#3366CC" id="akram"> <tr bgcolor="#D6EFB5" class="bodyText"> <th nowrap="nowrap"><span>Project Number</span></th> <th nowrap="nowrap"><span>Project Name</span></th> <th nowrap="nowrap"><span>Location</span></th> <th nowrap="nowrap"><span>Category</span></th> <th nowrap="nowrap"><span>Status</span></th> <th nowrap="nowrap"><span>Owner</span></th> <th nowrap="nowrap"><span>Owner's Contact</span></th> <th nowrap="nowrap"><span>Architect</span></th> <th nowrap="nowrap"><span>Architect Contact</span></th> <th nowrap="nowrap"><span>Project Type</span></th> <th nowrap="nowrap"><span>Principal</span></th> <th nowrap="nowrap"><span>Completion Date</span></th> <th nowrap="nowrap"><span>Project <br />Details </span></th> </tr> <CFLOOP QUERY="Project_info"> <CFIF #Project_info.ProjectID# IS "7"> <CFOUTPUT> <form action="test.cfm?DBSearchFrom=DoEdit&DBSearchID=#ProjectID#" method="post"> <tr> <td nowrap="nowrap"><input type="text" name="McsalProjNumb" id="UPMcsalProjNumb" size="15" value="#McsalProjNumb#"></td> <td nowrap="nowrap"><input type="text" name="ProjName" id="ProjName" size="75" value="#ProjName#"></td> <td nowrap="nowrap"><input type="text" name="LocationCity" id="LocationCity" size="20" value="#LocationCity#">, <input type="text" name="LocationState" id="LocationState" size="2" value="#LocationState#"></td> <td nowrap="nowrap"><input type="text" name="Category" id="Category" size="10" value="#Category#"></td> <td nowrap="nowrap"><input type="text" name="Status" id="Status" size="15" value="#Status#"></td> <td nowrap="nowrap"><input type="text" name="Owner" id="Owner" size="25" value="#Owner#"></td> <td nowrap="nowrap"><input type="text" name="OwnerCont" id="OwnerCont" size="25" value="#OwnerCont#"></td> <td nowrap="nowrap"><input type="text" name="Architect" id="Architect" size="25" value="#Architect#"></td> <td nowrap="nowrap"><input type="text" name="ArchitectCont" id="ArchitectCont" size="25" value="#ArchitectCont#"></td> <td nowrap="nowrap"><input type="text" name="ProjType" id="ProjType" size="15" value="#ProjType#"></td> <td nowrap="nowrap"><input type="text" name="Principal" id="Principal" size="25" value="#Principal#"></td> <td nowrap="nowrap"><input type="text" name="ActCompletDate" id="ActCompletDate" size="10" value="#DateFormat(ActCompletDate,"mm/dd/yyyy")#"></td> <td> <input type="submit" value="Update"> </form> </td> </tr> </CFOUTPUT> <CFELSE> <!-- This is where all the data get's nicely output into the table --> <CFOUTPUT> <tr bgcolor="##E6F3FF"> <td nowrap="nowrap">#Project_info.McsalProjNumb#</td> <td nowrap="nowrap"><a href="Project_Spreadsheet_Short.cfm?Proj_Data_ID=#Project_info.ProjectID#"># Project_info.ProjName#</a></td> <td nowrap="nowrap">#Project_info.LocationCity#, #Project_info.LocationState#</td> <td nowrap="nowrap">#Project_info.Category#</td> <td nowrap="nowrap">#Project_info.Status#</td> <td nowrap="nowrap">#Project_info.Owner#</td> <td nowrap="nowrap">#Project_info.OwnerCont#</td> <td nowrap="nowrap">#Project_info.Architect#</td> <td nowrap="nowrap">#Project_info.ArchitectCont#</td> <td nowrap="nowrap"><a href="Cat_OverviewForm.cfm?Proj_DB_Cat=#Project_info.ProjType#">#Project_inf o.ProjType#</a></td> <td nowrap="nowrap">#Project_info.Principal#</td> <td nowrap="nowrap">#DateFormat(Project_info.ActCompletDate,"mm/dd/yyyy")#</td> <td></td> </tr> </CFOUTPUT> </CFIF> </CFLOOP> </table> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4961 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
