[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amavis-user
Subject:    Re: [AMaViS-user] sql_select_white_black_list question...
From:       Mark Martinec <Mark.Martinec+amavis () ijs ! si>
Date:       2006-01-23 19:17:32
Message-ID: 200601232017.32755.Mark.Martinec+amavis () ijs ! si
[Download RAW message or body]

Joseph,

> > ...Unfortunately, I can't
> > get the id passed to the query twice (in this
> > case, id=40).
> > Is there a simpler way to accomplish this
> > other than rebuilding the apps to store
> > everything in a single table?

> Never mind.  I was able to craft a sql query that solved my needs.

Good.

> is there any reason that ? only gets expanded once ?

Yes: which '?' is to be replicated for how many times,
when there are several paratemeters to a SQL clause.

Consider:
  INSERT INTO quarantine (mail_id, chunk_ind, time_num, mail_text)
    VALUES (?,?,?,?)

Mark


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
[prev in list] [next in list] [prev in thread] [next in thread]