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/