I want to perform a "real-time" calculation on two prices contained within two drop-down list selection in some ASP/SQL code for our intranet site.
Basically, I have two drop-list price lists (A and B), with each price list being stored in a separate SQL database (ID, Description, Price).
When both price lists have a valid selection, I want to display the price B - A within the form.
Any ideas very welcome.
The code for one of the drop-list lists is:
<% sqlstr = "SELECT ID, Description, Price FROM TxDesignPriceList WHERE Designer=" & DesignerID & " ORDER BY Description"
rs2.Open sqlstr, conn
While Not rs2.EOF %>
<option value=<%=rs2("ID")%><%If int(DesignerPriceList) = rs2("ID") Then%> SELECTED <%End If%>><%=rs2("Description")%> / £<%=rs2("Price")%></option>
Last edited by wisdomt; 09-19-2005 at 08:25 AM.
By Arjuna in forum Database
Last Post: 07-25-2007, 04:22 AM
By Cindy in forum ASP.NET
Last Post: 03-15-2002, 03:08 PM
By Paul Dionne in forum ASP.NET
Last Post: 08-08-2000, 07:20 AM
Last Post: 07-25-2000, 09:46 AM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center