35 :
36 : <CFQUERY NAME='GetPrices' DATASOURCE=#SAN.dsn# username='#SAN.dbuser#' password='#SAN.dbpwd#'>
37 : select Lot_No, currency, Realized as PRICE from WLOTS where WLOTS.SALE_NO = '#session.CURR_SALE#' and WLOTS.FIRM_ID = '#session.FIRM_ID#' and realized <> 0
38 : order by WLOTS.sLot_no
39 : </cfquery>
|