RET

Sydney, Australia

retco.com.au

Age: 46

$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
26
answered How to frame a single(select) query without subquery
Feb
13
comment Informix CASE and summing results
Don't do that, it looks like a headache. Try simply: DECODE(salesstat.int_num, 4, 0.2, 8, 0.2, 0.1) * SUM(salesstat.net_amt-salesstat.return_net_amt)
Feb
12
answered Informix CASE and summing results
Feb
12
answered Join query to delete a record both in child class and parent class
Feb
11
awarded Supporter
Feb
5
comment Find if a directory exists using Template Toolkit
Well yes, that's what $0 is. I've updated my answer above with more detail.
Feb
5
revised Find if a directory exists using Template Toolkit
New suggestions based on comment trail
Feb
5
comment Find if a directory exists using Template Toolkit
Yes, I know that. But what is TT rendering? Web pages? What is the source of this directory parameter?
Feb
5
comment Find if a directory exists using Template Toolkit
In Catalyst and similar frameworks, $c is the Web context. You haven't articulated what else is in your stack, so it's hard to know how to advise.
Feb
5
comment Find if a directory exists using Template Toolkit
In my testing, [% template.name %] contains only the filename without the full path.
Feb
5
answered Find if a directory exists using Template Toolkit
Feb
2
comment Display only a part of a string
Yes, there's no reason why not, it's just a derived column.
Feb
2
answered Display only a part of a string
Jan
29
answered Catalyst Development Server - not showing routes and errors
Jan
27
answered Updating a field from other rows of the same table in Informix
Jan
12
answered access template_toolkit variable from external javascript
Jan
6
comment How to update a MYSQL column if the value's exist in another table?
@Jorge Campos: I don't read it that way - the OP's example shows he is comparing col1 to col1, and col2 to col2. I'm still none the wiser what PM 77-1 thinks the issue is...
Jan
6
answered How TO Delete Large Amount Of rows in online table informix Db
Jan
6
comment How to update a MYSQL column if the value's exist in another table?
You'll have to explain it to me then, o great one. I've seen Jorge's response, but don't agree that the OP asked that A.col1 and B.col2 need to be be compared.
Jan
6
revised How to update a MYSQL column if the value's exist in another table?
minor logic adjustment
1 2 3 4 5