Re: [exim] SQL problems quoting -- second ' eaten up

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Rory Campbell-Lange
CC: Exim Users
Subject: Re: [exim] SQL problems quoting -- second ' eaten up
On Wed, 28 Jun 2006, Rory Campbell-Lange wrote:

> what is happening to the second ' for some variables?
>
> >      warn log_message = ('$message_id', \
> >                          'MSPATH',  \
> >                          '$h_date',  \
> >                          '$h_subject',  \
> >                          '$recipients',  \
> >                          '$h_from',  \
> >                          '$h_to',  \
> >                          '$h_cc',  \
> >                          '$message_size')

> >
> > Which led to the following log line:
> > Warning: ('1FvNYX-0007mk-Ig', '2006-06-28/1FvNYX-0007mk-Ig', ' ' 'x@???', ' ' ' '38')
> >
>
> I'm flummoxed.


Try $h_date: etc (i.e. insert the required terminating colon). The names
of headers are terminated only by colon or white space. As it stands,
Exim will look for headers whose names are

date',
subject',

etc. These are perfectly legal header names, according to RFC 2822,
believe it or not.

-- 
Philip Hazel            University of Cambridge Computing Service
Get the Exim 4 book:    http://www.uit.co.uk/exim-book