Re: [AMaViS-user] sql_select_white_black_list question...

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=...486&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/