<!--- include template for document header --->
<cfinclude template="dochead.cfm">

<!-- updateFrogConfirm.cfm: template to enter frog data into the 
     froggy table and display updated info. -->

<!--- Use the cfquery tag to insert the updated frog contact info into the 
      "froggy" table --->   
      <cfquery name="updFrogs" datasource="#application.DS#">
         UPDATE froggy 
                SET frogName='#form.frogName#',
                frogColor='#form.frogColor#',
                frogEyeColor='#form.frogEyeColor#',
                frogHairColor='#form.frogHairColor#',
                obnoxiousnessRating='#form.obnoxiousnessRating#',
         WHERE frogID=#form.frogID#       
</cfquery>

<!--- Query the froggy table again, using the value of frogID to retrieve
      all of the data entered for the frog just updated --->
      
<cfquery name="getFrog" datasource="caramel-i275015">
   SELECT frogID, frogName, frogColor, frogEyeColor, frogHairColor, obnoxiousnessRating
   FROM froggy
   WHERE frogID = #form.frogID#
</cfquery> 

<!-- Begin frog display table -->

<h2>Frog Data Updated:</h2>
<div id="tbl">
<table cellspacing="0">
   
<!--- Use the cfoutput tag to output the data retrieved in the getRecord query.
      Because only one record is being retrieved, the table used here will 
      output one or several related fields per row. ---> 

<cfoutput query="getFrog">
        
  <tr>
    <td class="bld">Frog ID:</td><td>#frogID#</td>
  </tr>
  <tr>
    <td class="bld">Frog Name:</td><td>#frogName#</td>
  </tr>
  <tr>
    <td class="bld">Frog Color:</td><td>#frogColor#</td>
  </tr>
  <tr>
    <td class="bld">Frog Eye Color:</td><td>#frogEyeColor#</td>
  </tr>
  <tr>
    <td class="bld">Frog Hair Color:</td><td>#frogHairColor#</td>
  </tr>
  <tr>
    <td class="bld">Frog Obnoxiousness Rating:</td><td>#obnoxiousnessRating#</td>
  </tr>
</table>

<!--- email updated contact info to frog --->
<cfmail
     to="froggy@badisp.com"
     from="acourtois@badisp.com"
     subject="Updated Frog Info"
     Here is your updated frog information:
     
     Frog Name: #frogName#
     Frog Color: #frogColor#
     Frog Eye Color: #frogEyeColor#
     Frog Hair Color: #frogHairColor#
     Obnoxiousness Rating: #obnoxiousnessRating#
</cfmail>

<!-- Return to welcome or frog update page -->

<p><a href="updateFrog.cfm">Update more info</a>?</p>
</cfoutput>

</div>

<!--- include template for document header --->
<cfinclude template="docend.cfm">

Necessary disclaimer: I doubt there are any people in my class who know where my blahg is. If there are, I haven’t tested this code. It isn’t part of the project. It probably doesn’t work. Well, it *definitely* doesn’t work! ’cause it isn’t real and there is no “froggy” table and there’re prob’ly about a million billion typos in my code. And your project is prob’ly better than mine! Good luck and seeya Monday. I’m struggling as much as you are. 🙂

grok grok. Whaddya mean, “Obnoxiousness rating?” Frgok grok.

This entry was posted on Thursday, December 14th, 2006 at 7:42 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.