11 Jun
2013
11 Jun
'13
11:37 a.m.
On Tue, 2013-06-11 at 16:22 +0100, Matthew Newton wrote:
On Tue, Jun 11, 2013 at 05:02:33PM +0200, Stelian Ionescu wrote:
then the SQL fragment
«COALESCE(NULLIF('%{Event-Timestamp}', ''), '%S')::timestamp with time zone,'%{SQL-User-Name}'»
gets translated into
«COALESCE(NULLIF('Jun 7 2013 18:02:09 CEST=27=2C =27=27=29=2C =271970-01-01 01:00:00=27=29::timestamp with time zone=2C=27test'»
Notice how the apostrophes and commas are getting hex-encoded, thereby making the resulting query invalid.
Check out 'safe-characters' in sql/*/dialup.conf
I've never had to change safe-characters before, and queries worked(until recently). -- Stelian Ionescu a.k.a. fe[nl]ix Quidquid latine dictum sit, altum videtur. http://common-lisp.net/project/iolib