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

Apr
5
comment Bad Dates: SQL Server Offers ISDATE(), But Informix Does Not. Is There an Equal Workaround?
NULL might be considered valid for a date field (eg a delete_date or close_date), so personally I would be loath to include that in such a function. You can always write (ISDATE(...) = 0 OR str IS NULL). However if that's what SQL Server does and you're trying to emulate it, then go right ahead.
Apr
5
comment Bad Dates: SQL Server Offers ISDATE(), But Informix Does Not. Is There an Equal Workaround?
That completely changes the question! All those values can be interpreted as dates, they just don't fall within a reasonable domain. You could write something much simpler to return 0 if input is null, lower than a reasonable bound or greater than a reasonable upper bound, else 1. The reference to the Lindbergh Baby suggested the data held random text.
Apr
5
answered Bad Dates: SQL Server Offers ISDATE(), But Informix Does Not. Is There an Equal Workaround?
Apr
4
comment Bad Dates: SQL Server Offers ISDATE(), But Informix Does Not. Is There an Equal Workaround?
Presumably the field containing the date is not defined as type DATE for you to find 'goofy' dates stored in it?
Mar
8
comment Can I find out if variable is an array using Template Toolkit?
That's true, but it's also easily resolved if your multitext is an array of scalars where the first element could be blank/zero by using the defined method, e.g.: [%- SET items = multitext.0.defined ? multitext : [ multitext ];
Feb
15
comment How to return datetime in Excel when SQL table has only time?
Is creating a VIEW to abstract the cast an option?
Feb
15
comment How to return datetime in Excel when SQL table has only time?
Excel doesn't understand time without date particularly well. It's not clear in your question exactly what you want, though: if the send_date and send_time fields were merged into a single DATETIME YEAR TO SECOND, would that help?
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?
1 2 3 4 5