since I posted to CF-Talk.
I haven't coded in CF in awhile but I needed to build a web application. I
started to try to do it in PHP and ASP before I got so frustrated that I'm
doing it in CF.
<cfquery name="getIncompleteOrders" datasource="#request.dsn#">
select * from view_incomplete_orders
</cfquery>
<cfquery name="getDestinations" datasource="#request.dsn#">
select destinationID, destination from destinations
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>List Incomplete Orders</title>
</head>
<body>
<table border="1">
<cfform action="" method="post">
<tr>
<th>Date</th>
<th>shares</th>
<th>ticker</th>
<th>price</th>
<th>limit</th>
<th>destination</th>
</tr>
<cfoutput query="getIncompleteOrders">
<tr>
<td>#DateFormat(orderDate, "mm/dd/yy")#</td>
<td>#shares#</td>
<td>#security#</td>
<td>$#price#</td>
<td>$<cfinput name="limit_#orderID#"
value="#limit#"></td>
<td><cfselect name="destinationID_#orderID#"
query="getDestinations" value="destinationID" display="destination"
selected="#getIncompleteOrders.destinationID#"></cfselect></td>
</tr>
</cfoutput>
<tr>
<td colspan="6" align="center"><input type="submit"
value="Update"></td>
</tr>
</cfform>
</table>
</body>
</html>
----
That is the form page. Except I think I'm doing something wrong. The
action page I want it to update the limit and destinationID based on the
values inputted. So basically I'm letting them edit as many of the entries
as they want to on one page. How is the best way to handle this. I
remember doing this so many times except been awhile.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
