SELECT #getQueryString()# WHERE paymentRequest.idPaymentRequest= GROUP BY paymentRequest.idPaymentRequest SELECT #getQueryString()# WHERE paymentRequest.idProject= AND paymentRequest.idPaymentRequestState= AND paymentRequest.idProvider= AND paymentRequest.idCompany= AND paymentRequest.idEmployee= AND projectActivity.idProjectActivity= AND CAST(paymentRequest.dateRegistered AS DATE) >= AND CAST(paymentRequest.dateRegistered AS DATE) <= GROUP BY paymentRequest.idPaymentRequest ORDER BY #URLDecode(arguments.orderBy)##URLDecode(module.list.orderBy)# SELECT idPaymentRequest FROM paymentRequest WHERE idProject= AND idProvider= AND billNumber= AND billConcept= AND idPaymentRequest != INSERT INTO paymentRequest ( idPaymentRequest, idPaymentRequestState, idEmployee, idProject, idProvider, idServerFile, idPaymentType, idCurrency, idCompany, dateRegistered, billNumber, billConcept, billDate, amountNoTax, amountTaxToPay, amountTaxToHold1, amountTaxToHold2, amount, paymentTypeInfo, comment ) VALUES ( , , NULL, , , NULL, NULL, NULL, NULL, , , , NULL, , , , , , , ) Details: " & cfcatch.Detail> UPDATE paymentRequest SET idPaymentRequestState=, idEmployee=NULL, idProject=, idProvider=, idServerFile=NULL, idPaymentType=NULL, idCurrency=NULL, idCompany=NULL, billNumber=, billConcept=, billDate=NULL, amountNoTax=, amountTaxToPay=, amountTaxToHold1=, amountTaxToHold2=, amount=, paymentTypeInfo=, comment= WHERE idPaymentRequest= Details: " & cfcatch.Detail> UPDATE paymentRequest SET idPaymentRequestState=, WHERE idPaymentRequest= Details: " & cfcatch.Detail> DELETE FROM paymentRequest WHERE idPaymentRequest= Details: " & cfcatch.Detail> #list.billConcept#