home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cool Page Magazine 16
/
CoolPage_16.iso
/
dynadb
/
codes
/
updod2.cfm
< prev
next >
Wrap
Text File
|
1998-02-10
|
3KB
|
110 lines
<!----------------------------------------------------------------------------------------->
<!--- └╔ªWíGupdod2.cfm --->
<!--- │o¡╙└╔«╫╖|«┌╛┌Ñ╤ updateod.cfm ⌐╥ѵ¿╙¬║ order_idíA --->
<!--- ╖j»┴╝╞╛┌«wíAºΣÑX░O┐²íA╡M½ß┼²Ñ╬ñß¡╫º∩ --->
<!--- ╡M½ßªAѵ╡╣ updod3.cfm │B▓z --->
<!----------------------------------------------------------------------------------------->
<!------------------------------------------------------------------
<FORM ACTION="updod3.cfm" method="post">
--------------------------------------------------------------------->
<HTML>
<BODY background="paper12l.jpg">
<CFQuery Name="GetRecord" datasource="Dynamic Database">
select * from orderproduct
where order_id='#url.order_id#'
</CFQuery>
<CFQuery Name="GetCust" datasource="Dynamic Database">
select * from customer
where cust_id=
(select cust_id from orderproduct
where order_id='#url.order_id#')
</CFQuery>
<cfoutput query ="GetRecord">
<cfset orig_orderyear=#year(order_date)#>
<cfset orig_ordermonth=#month(order_date)#>
<cfset orig_orderday=#day(order_date)#>
<cfset orig_orderdate=#orig_ordermonth# & "/" & #orig_orderday# & "/" & #orig_orderyear#>
<cfset orig_dueyear=#year(due_date)#>
<cfset orig_duemonth=#month(due_date)#>
<cfset orig_dueday=#day(due_date)#>
<cfset orig_duedate=#orig_duemonth# & "/" & #orig_dueday# & "/" & #orig_dueyear#>
<cfset orig_payby=#pay_by#>
</cfoutput>
<CFFORM NAME="UpdateForm" ACTION="updod3.cfm">
¡q│µ╜s╕╣íG <cfoutput>#GetRecord.order_id#
<input type="hidden" name="orig_order_id" value=#GetRecord.order_id#>
</cfoutput>
<br>
┼U½╚╜s╕╣íG <CFSELECT NAME="updated_cust_id"
REQUIRED="Yes"
SIZE="1"
MULTIPLE="no"
QUERY="GetCust"
VALUE="cust_id"
DISPLAY="cust_id">
</CFSELECT>
<br>
¡q│µñΘ┤┴íG <CFINPUT TYPE="text"
NAME="updated_order_date"
query="GetRecord"
value=#orig_orderdate#
REQUIRED="Yes"
VALIDATE="date"
MESSAGE="¡q│µñΘ┤┴«µªíñúÑ┐╜TíA└│¼░mm/dd/yyyy"
SIZE="10"
MAXLENGTH="10">(mm/dd/yyyy)
<br>
¿∞┤┴ñΘ┤┴íG <CFINPUT TYPE="text"
NAME="updated_due_date"
query="GetRecord"
VALUE=#orig_duedate#
REQUIRED="Yes"
VALIDATE="date"
MESSAGE="¿∞┤┴ñΘ┤┴«µªíñúÑ┐╜TíA└│¼░mm/dd/yyyy"
SIZE="10"
MAXLENGTH="10">(mm/dd/yyyy)
<br>
ÑI┤┌ñΦªííG <CFSELECT NAME="updated_pay_by"
REQUIRED="Yes"
query="GetRecord"
Value="pay_by"
SIZE="1"
MULTIPLE="no"
SELECTED="pay_by">
<cfif #orig_payby# is not "Visa">
<OPTION VALUE="Visa">Visa
</cfif>
<cfif #orig_payby# is not "Cash">
<OPTION VALUE="cash">Cash
</cfif>
<cfif #orig_payby# is not "Cheque">
<OPTION VALUE="cheque">Cheque
</cfif>
</CFSELECT>
<br>
<INPUT TYPE="Submit" VALUE="└xªs">
<INPUT type="hidden" NAME="updated_order_date_required" VALUE="ºA┴┘¿S┐ΘñJ¡q│µñΘ┤┴">
<INPUT type="hidden" NAME="updated_due_date_required" VALUE="ºA┴┘¿S┐ΘñJ¿∞┤┴ñΘ┤┴">
<input type="hidden" name="updated_order_date_date" value="¡q│µñΘ┤┴«µªí┐∙╗~">
<input type="hidden" name="updated_due_date_date" value="¿∞┤┴ñΘ┤┴«µªí┐∙╗~">
</CFFORM>
<P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
</BODY>
</HTML>