home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / order2.cfm < prev    next >
Text File  |  1997-09-22  |  2KB  |  70 lines
  1. <!------------------------└╔ªWíGOrder2.cfm--------------------------------->
  2. <!---        │o¼O¡q│f╣L╡{ññ¬║▓─ñG¡╙└╔«╫íC                --->
  3. <!---        ¡q│f¬║╣L╡{Ñ]¼AíG┐∩╛▄║╪├■⌐╬├÷┴Σªr╖j┤MíA╡M½ß▒Nñj¡P▓┼ªX    --->
  4. <!---        ¬║▓ú½~ªCÑX¿╙íAÑ╬ñߪAªb¿║¡╙▓ú½~ªC¬φññ┐∩╛▄⌐╥╗▌¡n¬║íC    --->
  5. <!------------------------------------------------------------------------->
  6.  
  7. <cfquery name="TypeList" datasource = "dynamic database">
  8.     select * from prodtype
  9. </cfquery>
  10. <form action="order2.cfm" method="post">
  11.  
  12.  
  13. <HTML>
  14. <HEAD>
  15. <TITLE>¡q│f┴`Ñ╪┐²</TITLE>
  16. </HEAD>
  17. <BODY>
  18. <H2>▓ú½~║╪├■ªC¬φ<br>
  19.  
  20. <cfif #search_type# is "type">
  21.     <CFQUERY NAME="query_type" DATASOURCE="Dynamic Database">
  22.            SELECT * FROM prodtype
  23.     </CFQUERY>
  24.  
  25. <cfoutput>
  26. #url.type_total#
  27. </cfoutput>
  28.     <cfif #url.type_total# greater than 0>    
  29.         <cfloop index="idx" from="1" to="#url.type_total">
  30.             <cfif #chkbox[idx]#=checked>
  31.                 <CFLOOP QUERY="query_type" STARTROW="#idx#" ENDROW="#idx#">
  32.                     <cfoutput>
  33.  
  34.                         <cfset get_type=get_type & " and " & 
  35.                             #query_type.type_name#>
  36.                     </cfoutput>
  37.                 </CFLOOP>
  38.             </cfif>
  39.         </cfloop>
  40.     </cfif>        
  41. </cfif>
  42.  
  43.     <cfquery name = "get_product" datasource="dynamic database">
  44.         select * from product
  45.         where type = "get_type"
  46.     </cfquery>
  47.  
  48. <TABLE BORDER="0" ALIGN="DEFAULT" WIDTH="100%">
  49. <!---▓─ñ@ªµ--->
  50. <form>
  51. <table>
  52. <TR>
  53. <TD align="center">▓ú½~ªC¬φ</TD>
  54. <TD align="center">ªpªX╜╨ñ─</TD>
  55. </TR>
  56.  
  57. <!---▓─ñGªµ╢}⌐l--->
  58. <cfset #n#=0>
  59.     <cfoutput query="get_product">
  60.     <TR>
  61.         <TD align="left">#product_name#</TD>
  62. <!---        <TD align="left"><INPUT TYPE="checkbox" NAME="chkbox[#n#]"></TD>
  63. --->
  64.     </TR>
  65.     <cfset #n#=#n#+1>
  66.     </cfoutput>
  67. </TABLE>
  68. </form>
  69. </body>
  70. </html>