SELECT #getQueryString()# WHERE paymentRequestDetails.idPaymentRequestDetails= SELECT #getQueryString()# WHERE paymentRequestDetails.idPaymentRequest= ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)# SELECT SUM(paymentRequestDetails.amount) AS amountTotal FROM paymentRequestDetails WHERE paymentRequestDetails.idPaymentRequest= SELECT idPaymentRequestDetails FROM paymentRequestDetails WHERE paymentRequestDetails.idPaymentRequest= AND paymentRequestDetails.idProjectActivity= IS NULL AND paymentRequestDetails.idProjectTask= IS NULL AND paymentRequestDetails.idProjectParcel= IS NULL AND paymentRequestDetails.idProjectSubParcel= IS NULL AND idPaymentRequestDetails != INSERT INTO paymentRequestDetails ( idPaymentRequest, idProjectActivity, idProjectTask, idProjectParcel, idProjectSubParcel, amount ) VALUES ( , NULL, NULL, NULL, NULL, ) Details: " & cfcatch.Detail> UPDATE paymentRequestDetails SET amount=, idProjectActivity=NULL, idProjectTask=NULL, idProjectParcel=NULL, idProjectSubParcel=NULL WHERE idPaymentRequestDetails= Details: " & cfcatch.Detail> DELETE FROM paymentRequestDetails WHERE idPaymentRequestDetails= Details: " & cfcatch.Detail>