ColdFusio to Oracle Procedure
$30-5000 USD
Posted about 16 years ago
$30-5000 USD
Paid on delivery
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([login to view URL]) GT 0 and [login to view URL] gt 0>? ?
? ? <cfset thedate=#DateAdd("H",[login to view URL],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>
Project ID: 3721835
About the project
3 proposals
Remote project
Active 16 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
3 freelancers are bidding on average $91 USD for this job
$46.75 USD in 14 days
4.9 (63 reviews) $212.50 USD in 14 days
0.0 (15 reviews)