home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cool Page Magazine 16
/
CoolPage_16.iso
/
dynadb
/
codes
/
upddtl2.cfm
< prev
next >
Wrap
Text File
|
1998-01-22
|
2KB
|
54 lines
<HTML>
<HEAD>
<TITLE>¡╫º∩╕Ω«╞</TITLE>
</HEAD>
<!--------------------------------------------------->
<!------- 1234567890a -------------------------->
<!------- 2222@555555 -------------------------->
<!--------------------------------------------------->
<cfset seperator=#find(chr(142), selected_order_id)#>
<cfset ordered_id=#left(selected_order_id, seperator-1)#>
<cfset product_id=#right(selected_order_id, len(selected_order_id)-seperator)#>
<CFQUERY NAME="GetRecord" DATASOURCE="Dynamic Database">
select detail.order_id, detail.quantity, product.product_name
from detail, product
WHERE detail.order_id = '#ordered_id#'
and detail.prod_id='#product_id#'
and product.prod_id=detail.prod_id
</CFQUERY>
<cfoutput query="GetRecord">
<cfset out_order_id=#order_id#>
<cfset out_product_name=#product_name#>
<cfset out_qty=#quantity#>
</cfoutput>
<BODY background="paper12l.jpg">
<CFFORM NAME="UpdateForm" ACTION="upddtl3.cfm">
<cfoutput>
¡q│µ╜s╕╣íG #out_order_id#<br>
│f¬½ªW║┘íG #out_product_name#<br>
</cfoutput>
╝╞╢qíG <CFINPUT TYPE="text"
NAME="qty"
VALUE=#out_qty#
REQUIRED="Yes"
VALIDATE="integer"
MESSAGE="ºA┴┘¿S┐ΘñJ╝╞╢q"
SIZE="10"
MAXLENGTH="10">
<br>
<INPUT TYPE="Submit" VALUE=" └xªs">
<cfoutput>
<input type="hidden" name="upd_order_id" value=#ordered_id#>
<input type="hidden" name="upd_prod_id" value=#product_id#>
</cfoutput>
</CFFORM>
<P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
</BODY>
</HTML>