Re: [exim] Running a SQL Insert command

Pàgina inicial
Delete this message
Reply to this message
Autor: Michael da Silva Pereira
Data:  
A: Jeremy Harris, exim-users @ exim. org
CC: 
Assumpte: Re: [exim] Running a SQL Insert command
I tried double" and single' nothing makes a difference.

I just put junk in for now, just word because i was assuming it might be
tyhe varibles I had in there earlier.

Thanks,
Michael


----- Original Message -----
From: "Jeremy Harris" <jgh@???>
To: "exim-users @ exim. org" <exim-users@???>
Sent: Thursday, April 07, 2005 3:40 PM
Subject: Re: [exim] Running a SQL Insert command


> Michael da Silva Pereira wrote:
>> No Luck:
>>
>> Log file genreates:
>> Warning: ACL "warn" statement skipped: condition test deferred: MYSQL:
>> query failed: You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to use
>> near 'from, to, host, ctime) values ("msgid", "from", "to", "host" ,"\n
>>
>>
>> config file looks like:
>> begin acl
>> acl_check_rcpt:
>> accept hosts = :
>>
>> warn set acl_m9 = ${lookup mysql {INSERT INTO message_log \
>> (msgid, from, to, host, ctime) \
>> values \
>> ("msgid", \
>> "from", \
>> "to", \
>> "host" \
>> ,"ctime")}}
>
> OK, that's a MySQL error (not an Exim one). What does MySQL require
> for quoting of string values? I only speak PgSQL, I'm afraid,
> but that need single-quotes.
>
> Or, did you really mean to try to put those strings in those fields?
> Perhaps something more meaningful, made from Exim variables?
>
> - Jeremy
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim
> details at http://www.exim.org/
> ## Please use the Wiki with this list - http://www.exim.org/eximwiki/