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
Never mind. I was able to craft a sql query that solved my needs. is
there any reason that ? only gets expanded once ?
On Thu, 19 Jan 2006, Joseph W. Breu wrote:
I am trying to execute the following query:
set @rid=?;
(select wb FROM
cfu_email.amavis_wblist,cfu_email.amavis_mailaddr
I am trying to execute the following query:
set @rid=?;
(select wb FROM
cfu_email.amavis_wblist,cfu_email.amavis_mailaddr WHERE ([EMAIL PROTECTED]) AND
(sid=cfu_email.amavis_mailaddr.id) AND (cfu_email.amavis_mailaddr.email IN
(%k)) ORDER BY cfu_email.amavis_mailaddr.priority DESC) UNION (se