- or download this
my $stmt = new SQL::Fragment("SELECT *, PRICE+? FROM ITEMS", $fees);
...
}
my ($sql, @params) = $stmt->sql_and_params;
- or download this
sub append - append another SQL Fragment to $self
sub append_join - append a join-ed list of SQL Fragments to $self
...
join( $sep, map { "($_)" } @list )
For instance, this is useful to ensure each condition is in it's own s
+et of parens.
- or download this
sub append_join_parens {
my $self = shift;
...
});
$self;
}