home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / upddtl.cfm < prev    next >
Text File  |  1998-02-10  |  1KB  |  45 lines
  1. <!------------------------------└╔ªWíGUpddtl.cfm------------------------------------------->
  2. <!----------------------------------------------------------------------------------------->
  3. <html>
  4. <BODY background="paper12l.jpg">
  5.  
  6.  
  7.     <CFQuery Name="GetRecord" datasource="Dynamic database"> 
  8.         select * from detail, product
  9.         where detail.prod_id=product.prod_id
  10.     </CFQuery>
  11.  
  12. <cfif #GetRecord.recordcount# is 0>
  13.     ╝╞╛┌«wñññw╕g¿Sª│Ñ⌠ª≤░O┐²ñFíC
  14. <cfelse>
  15.  
  16.     <cfset k=0>
  17.     <cfset DetailRecord=ArrayNew(2)>
  18.     <cfoutput query="GetRecord">
  19.         <cfset k=k+1>
  20.         <cfset DetailRecord[1][k]="Order= " & #order_id# & ", product=" & #product_name#>
  21.         <cfset DetailRecord[2][k]=#order_id# & chr(142) & #prod_id#>
  22.     </cfoutput>
  23.     
  24.  
  25.     <CFFORM NAME="UpdateForm" ACTION="upddtl2.cfm">
  26.        ¡q│µ╜s╕╣:     <cfSELECT NAME="selected_order_id"
  27.                 size="1">
  28.             <cfloop index="j" from="1" to=#k#>
  29.                 <cfoutput>
  30.                 <option value="#DetailRecord[2][j]#">#DetailRecord[1][j]#
  31.                 </cfoutput>
  32.             </cfloop>
  33.  
  34.             </cfselect>
  35.             <br>    
  36.     <input type=submit value=╜T⌐w>
  37.     </PRE>
  38.     </cfFORM>
  39. </cfif>
  40. <hr>
  41. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  42. </BODY>
  43. </HTML>
  44.  
  45.