[ic] [interchange] * Add ability to have a NO_UPDATE field in SQL tables, which field will
Peter
peter at pajamian.dhs.org
Mon May 23 20:30:24 UTC 2016
On 24/05/16 01:03, Mike Heins wrote:
> + my $extra = '';
> + if( my $f = $s->[$CONFIG]{TIMESTAMP_FIELD} and exists $s->[$CONFIG]{NO_UPDATE}{$column} ) {
> + $extra = "$f = $f, ";
> + }
> +
> my @args;
> if(!$q) {
> - $q = qq{update $s->[$QTABLE] SET $column = ? where $s->[$QKEY] = ?};
> + $q = qq{update $s->[$QTABLE] SET $extra$column = ? where $s->[$QKEY] = ?};
$f should be quoted if QUOTE_IDENTIFIERS is set.
Peter
More information about the interchange-users
mailing list