ColdFusio to Oracle Procedure
$30-5000 USD
Płatność przy odbiorze
I have some coldfusion code that I want to extract to an Oracle Stored procedure...
<cfquery datasource="#Application.datasource#" name="rscustomer">
? ? select PJ.job_id,special_close_time as spec,create_Date from Print_Jobs PJ where PJ.awarded_to = 'OPEN'
</cfquery>
<cfloop? query="rscustomer">
? <cfif len([url removed, login to view]) GT 0 and [url removed, login to view] gt 0>? ?
? ? <cfset thedate=#DateAdd("H",[url removed, login to view],rscustomer.create_Date)#>?
? <cfelse>? ?
? ? <cfif? rscustomer.create_Date neq "">
? ? ? <cfset thedate=#DateAdd("d",2,rscustomer.create_Date)#>
? ? </cfif>? ?
? </cfif>
? <cfif Dayofweek(thedate) eq 1>
? ? <cfset thedate=#DateAdd("d",2,thedate)#>
? <cfelseif Dayofweek(thedate) eq 7>
? ? <cfset thedate=#DateAdd("d",2,thedate)#>
? </cfif>
Numer ID Projektu: #3721835