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

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
Jan
6
comment How to update a MYSQL column if the value's exist in another table?
Ah yes, the id field is not the FK. Missed that the first time. Answer adjusted accordingly.
Jan
6
answered How to update a MYSQL column if the value's exist in another table?
Dec
5
awarded Yearling
Dec
4
awarded Autobiographer
Nov
25
answered Informix. "Load from file" and indexes
Nov
20
comment Escape Single Quotes in Template Toolkit
The OP doesn't say this is the underlying issue, but it could be an X-Y problem, of course. You're reinventing the wheel here though, there's already a mature plugin for TT called Template::Plugin::JSON
Nov
11
comment How to insert return value from last EXECUTE PROCEDURE in INFORMIX
Answer updated with alternate suggestion.
Nov
11
revised How to insert return value from last EXECUTE PROCEDURE in INFORMIX
update following answer comments
Nov
11
comment How to insert return value from last EXECUTE PROCEDURE in INFORMIX
If you were using some embedded language like ESQL/C or Perl DBI, it's trivial to store the result of the SPL in a variable and then save that with an INSERT in a procedural fashion.
Nov
11
comment How to insert return value from last EXECUTE PROCEDURE in INFORMIX
That would explain it. You'll need to go about it differently.
Nov
11
comment How to insert return value from last EXECUTE PROCEDURE in INFORMIX
That suggests that the function is itself performing some DML? That might not be permitted.
Nov
10
answered How to insert return value from last EXECUTE PROCEDURE in INFORMIX
Nov
6
comment How to get top 1 from each group
The question states at the very top: "This is specific for IBM Informix". Your answer is for SQL Server, and will not help the OP.
1 2 3 4 5