|
Hello, my name is Paul Wilson. ([EMAIL PROTECTED]).
I currently run http://wiredon.net
(temporarily offline as we are moving to a dedicated server) and http://desksql.com (temporarily inaccessible as it
is in development - it is to be the home of Desk SQL, a helpdesk script written
in perl using an SQL backend).
My preferred username(s) would be: PAUL, PAULW or WIREDON
I'd like to contribute a template parser which supports special template
tags such as <%foo%>. It also supports <%if foo%> bar
<%endif%> and also <%else%> tags and operators within tags. For
example:
<%if var == var2%>
Oh var equals var2
<%else%>
Darn, var doesn't equal var2 :(
<%endif%>
My next contribution would be an SQL module which would be an interface to
DBI as DBI is an interface to sql. The module takes several arguments and
contructs the sql query and executes it. For example:
$obj->insert( $table, \@cols, \@vals );
.....which would result in an INSERT query being fully prepared and
executed within the module. The statement handle is returned for select queries
allowing something like:
my $sth = $DB->select( ... );
or....
my $rec = $DB->select( ... )->fetchrow;
....this reduces the need for long queries within the code as they are
built dynamically.
Thanks!
Paul Wilson.
|
