[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