RET

Sydney, Australia

retco.com.au

Age: 47

$self->like( qw[ Perl Catalyst Informix Macs iOS 'old Holdens' ] ); # not necessarily in that order...

My background is in data warehousing (18 years or so) and more recently in building web-apps with a reporting flavour. I'm also responsible for OurCarClub, a web-based data management application for Car Clubs. It's built using perl, Catalyst, Template Toolkit, Class::DBI and MySQL, with more than a dash of jQuery.

OurCarClub.com.au

Feb
8
awarded Cleanup
Feb
4
answered Informix - Create table with function weekday
Jan
28
answered optimised query for default value in informix
Jan
14
answered template-toolkit: passing array variables into tpage from command line?
Jan
12
comment Issue calculating month end date in 4GL
Turns out Jonathan already has, see: stackoverflow.com/a/33142330/14750 . The fix was introduced in 11.70.FC5
Jan
12
comment Issue calculating month end date in 4GL
I think @JonathanLeffler can probably verify this, but I think that fix for month arithmetic in date columns is only fairly recent. It is definitely the case that MDY(1,31,2015) + 1 UNITS MONTH would error on older versions.
Jan
11
comment Issue calculating month end date in 4GL
Hi @fourjs.reuben, +1 UNITS MONTH is problematic when adding to a date on the 29/30/31st, but you can rely on every month having a 1st. :-)
Jan
7
answered Issue calculating month end date in 4GL
Dec
11
comment Login to Informix as a different user using dbaccess
You won't get far with su. The key difference between su and sudo is that the latter can be configured to execute without a password.
Dec
10
answered Login to Informix as a different user using dbaccess
Dec
9
comment Why am I getting the error 'Can't call method "submitted" without a package or object reference' when generating a form in Catalyst?
Fresh pair of eyes, that's all :-)
Dec
8
revised Why am I getting the error 'Can't call method "submitted" without a package or object reference' when generating a form in Catalyst?
slight formatting
Dec
8
answered Why am I getting the error 'Can't call method "submitted" without a package or object reference' when generating a form in Catalyst?
Nov
9
awarded Caucus
Oct
27
revised Retrieving filtered list of files using template toolkit
Spelling of title fixed
Oct
21
comment Informix Select and output result as a matrix
The syntax is OK (tested under 11.70). What version of Informix are you using? Very old versions may not support CASE. For what it's worth the query could be shortened by using SUM(DECODE(month_year,'1/2015',value_goods)) AS MY_012015 but if your server doesn't support CASE, it won't support DECODE either.
Oct
16
comment Automatically loading controllers in a different library directory in Catalyst
You could allow user controllers in a subdirectory under /Controller. Actions can be chained so that URIs fit to the existing name spaces.
Oct
14
answered Automatically loading controllers in a different library directory in Catalyst
Oct
12
revised How to explain TreeNode type restriction and self-type in Spark Catalyst?
removed catalyst tag, which relates to perl web framework of that name
Oct
12
answered How to get the data of previous weeks in the same month knowing the day as a search point
1 2 3 4 5