I think I've found a limit of usefulness to cfqueryparam: it doesn't seem to work with an INSERT INTO...SELECT FROM as per below (in the "select...from" part eg: the "#ARGUMENTS.auth_code#")
can anyone confirm this? can anyone suggest why? thanx barry.b INSERT INTO poaudit( CMPY_CODE, DESC_TEXT, ENTRY_CODE, ENTRY_DATE, EXT_COST_AMT, EXT_TAX_AMT, LINE_NUM, LINE_TOTAL_AMT, NOW_AUTH_FLAG, ORDER_QTY, ORIG_AUTH_FLAG, PERIOD_NUM, POSTED_FLAG, PO_NUM, RECEIVED_QTY, SEQ_NUM, TRAN_CODE, TRAN_DATE, TRAN_NUM, UNIT_COST_AMT, UNIT_TAX_AMT, VEND_CODE, VOUCHER_QTY, YEAR_NUM ) SELECT CMPY_CODE, DESC_TEXT, "#ARGUMENTS.auth_code#", #NOW()#, unit_amt * order_qty, 0, LINE_NUM, unit_amt * order_qty, "N", order_qty, "N", #month(now())#, "N", #qNext_po_num.order_num#, 0 , 1, "AA", #now()#, 1, unit_amt, 0, "#qVendor.VEND_CODE#", 0, #year(now())# FROM reqdetl WHERE req_num = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#ARGUMENTS.req_num#"> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
