What I Broke – Programming and Web Development

Month: August 2012

  • Heroku Timezones – Ruby on Rails

    Hey everyone, Just a quick post on how to adjust the timezone on Heroku, comes in handy when using the log files. #Console $ heroku config:add TZ=Australia/Brisbane There is a fairly detailed StackOverflow post at the following link if anyone is interested in more info: http://stackoverflow.com/questions/2719330/why-does-heroku-log-using-the-server-time-rather-than-the-rails-time-zone The language options can also be found on the…

  • Oracle – Number of Weekdays Between Two Dates

    Hey everyone, Just a quick post on how to select the number of weekdays between two dates: SELECT temp_tbl.days –SELECT COUNT(temp_tbl.days) FROM ( SELECT (TRUNC(TO_DATE (’01/08/2012′, ‘DD/MM/YYYY’), ‘dd’) + LEVEL – 1) days FROM DUAL CONNECT BY LEVEL = 2 AND TO_CHAR(temp_tbl.days, ‘D’) <= 6

  • Rails Casts #142 Paypal Notifications

    Hey all, I ran into a bit of an issue in Rails Cast #142. I received the following error while testing the IPN: WARNING: Can’t verify CSRF token authenticity Completed 500 Internal Server Error in 2ms app/controllers/payment_notifications_controller.rb:11:in `process_ipn_payment’ Simply replace the following line with the alternative below it: #Payment_Notifications_Controller.rb protect_from_forgery :except => [:create] #Payment_Notifications_Controller.rb skip_before_filter…

  • Sending Email – PL/SQL

    A quick post on how to send an email with PL/SQL. There’s a LOT of documentation available at the following link: http://www.orafaq.com/wiki/Send_mail_from_PL/SQL PROCEDURE EMAIL_ERROR_REPORT IS /* Create vars */ v_From VARCHAR2 (80) := ‘test@test.com’; v_Recipient VARCHAR2 (80) := ‘me@me.com’;–REPORT_RECEIVER; v_Subject VARCHAR2 (80) := ‘test subject’; v_Mail_Host VARCHAR2 (30) := ‘smtp.test.com’; v_Mail_Conn UTL_SMTP.Connection; crlf VARCHAR2 (2)…

  • Cannot Generate Tempfile – Ruby on Rails

    Ran into the following problem, still not too sure what caused it but this seems to have fixed it: Error cannot generate tempfile `/home/chris/cartsite/tmp/cache/assets/sprockets%2Fd585a06e2ee6203ccb04c8b84150d14d20120804-8682-7q77nb-9′ Just run the following: $ rake tmp:clear Let me know if you come across the cause, I’d be interested to know.

  • Paypal Platform Ruby SDK – Adaptive Payments

    Hey everyone, This is the SDK for PayPal adaptive payments. I’ve just uploaded it to *hopefully* make it a little easier to find. Please note that it has not been updated recently and that there are a few changes to be made. The StackOverflow post below provides a few examples: StackOverflow Post: Adaptive Payments with…

Create a website or blog at WordPress.com