Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

Category Archives: Mason

Minor bug with Sybase’s Workspace 1.7 regarding directories starting with a ‘.’

by Jason L Froebe on April 17, 2007, no comments

I’ve been using Sybase’s Workspace 1.7 for developing and maintaining a myriad of maintenance scripts, web pages, and other interesting things.  I ran into an interesting issue that is worthwhile to take note: In most of the 3rd party plugins, the .components directory properly shows up in their perspectives.  For example, the EPIC plugin shows [...]

Share Button

An easy way to view maintenance logs using a browser using Perl & Mason

by Jason L Froebe on February 7, 2007, no comments

stats/index.html: < %method title> DBServices: Update Statistics Logs <center> <h1>Update Statistics Logs</h1> < & ‘../.components/ase/maint_logs.comp’, path => "/dbms/sybase/dba/out", file_part => "update_stats" &> </center> stats/dhandler: < %perl> my $self = shift; $self->{once_header} = ”; $self->{header} = ”; $self->{body} = ”; $self->{footer} = ”; $self->{current_block} = ”; my $log_path = ‘/dbms/sybase/dba/out/’; my $file = $m->dhandler_arg; $file =~ [...]

Share Button

disappearing alert override table SOLVED!

by Jason L Froebe on November 27, 2006, no comments

At work, I created a web page that would raise alerts depending on various criteria and could be overridden by an entry in a db table. Server Name Override Start Override End Authorized By Comments my_server Nov 20 2006 3:24PM CST Dec 4 2006 12:00PM CST RG add space Well, I solved it!  When you [...]

Share Button

Perl Problem with filtered Mason code & db connection

by Jason L Froebe on November 6, 2006, no comments

Hi, In chapter 5 (Advanced Features pgs 82,83) of Embedding Perl in HTML with Mason from O’Reilly, the"a simple SQL select expressed in something like a taglib style" example appears to be straight forward.  It is but it doesn’t seem to work too well. The premise is that the ".components/sql/select" will filter the chunk of [...]

Share Button

Using Perl, Mason, mod_perl and DBI: Result sets

by Jason L Froebe on August 13, 2006, one comment

I’m new to Mason and am having trouble printing a simple html table pulling data from a table on a database.  I know this has to do with scope but there has to be an easier way other than putting the entire dbms call (including printing the table) within a perl code section. One thing [...]

Share Button
Facebook login by WP-FB-AutoConnect