home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / adddetl2.cfm < prev    next >
Text File  |  1998-02-09  |  2KB  |  42 lines
  1. <!---------------------------└╔ªWíGAdddetl2.cfm ------------------->
  2.  
  3. <HEAD><TITLE>╖s╝W╕Ω«╞</TITLE></HEAD>
  4. <BODY background="paper12l.jpg">
  5. <HTML>
  6.  
  7.  
  8.  
  9.     <!--- ▒N┼▄╝╞▒╥⌐lñ╞  --->
  10.  
  11.     <cfset iserror=false>        <!--- ¿M⌐wª│¿Sª│┐∙╗~╡oÑ═¬║┼▄╝╞        --->
  12.     <cfset dupidx=false>        <!--- ¿M⌐w│f¬½╜s╕╣ª│¿Sª│¡½┬╨¬║┼▄╝╞    --->
  13.     <!--- └╦¼d│f¬½╜s╕╣ª│¿Sª│¡½╜╞ --->
  14.     <CFQUERY NAME="Checkidx" DATASOURCE="Dynamic Database">    
  15.         select * from detail where order_id = '#order_id#' and prod_id='#prod_id#'
  16.     </CFQUERY>
  17.  
  18.     <cfif #Checkidx.recordcount# greater than 0>
  19.         <!--- ªp¬G╝╞╛┌¬φñññwª│░O┐²íA½h╢╟ª^ #Checkidx.recordcount# ¼░ 1, 
  20.         ¿Sª│░O┐²½h╢╟ª^ 0íAª]¼░ñ@¡╙ order_id Ñu»αª│ñ@¡╙░O┐²           --->
  21.         ┐ΘñJñúÑ┐╜TíCºAÑ╟ñFÑHñU┐∙╗~íG<br>
  22.     <cfelse>
  23.         <!---    ªp¬G│q╣LñF⌐╥ª│¬║┤·╕╒íA┤N╖|¿╙¿∞│oñ@│íñ└    --->        
  24.         <!------------------------------------------------------------------------->
  25.         <!---    ÑHñU│oñ@¼q¼O╝╨╖╟¬║ SQL Ñy¬kíAÑ╬ÑH╖s╝Wñ@¡╙░O┐²íC            --->
  26.         <!---    Ñy¬k¼░ insert into [table name] (fieldname1, fieldname2...)    --->
  27.         <!---        values (field1_value, field2_value...)            --->
  28.         <!------------------------------------------------------------------------->
  29.         
  30.         <CfQuery name="AddRecord" datasource="dynamic database">
  31.             insert into detail(order_id, prod_id, quantity)
  32.             values ('#order_id#', '#prod_id#', #quantity#)
  33.         </cfquery>
  34.  
  35.         <!-------------------------SQL¬║Ñy¬k¿∞│o╕╠╡▓º⌠----------------------------->
  36.         <CENTER><H2>ºA¡Φñ~⌐╥┐ΘñJ¬║╕Ω«╞ñw╖s╝Wª▄╝╞╛┌«wññ</H2></CENTER>
  37.         <HR>
  38.         <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  39.     </cfif>
  40.  
  41. </BODY>
  42. </HTML>