Looks like this did it fine :) on the smptauth.cfm file <cfquery name="getdomain" datasource="iMS"> SELECT DomainID FROM domainaliases where domainaliases.domain='#todomain#' </cfquery> <cfquery name="getpassword" datasource="iMS" dbtype="ODBC"> SELECT Password FROM POPs WHERE Name = '#SMTPAUTHUSER#' AND Domain = '#getdomain.DomainID#' </cfquery> <cfif #getpassword.recordcount# gt 0> <cfoutput> result=accept password=#getpassword.password# </cfoutput> <cfelse> result=reject </cfif> ******************************************** * Ing. Guillermo Dewey Guerra * AbleCommerce Mexico * [EMAIL PROTECTED] * ICQ: 25876549 (GDewey) * * http://www.ablecommerce.com.mx * <http://www.metro.com.mx/>http://www.metro.com.<http://www.metro.com.mx/>mx * * Tel. (011) (52) (8) 3-90-7000 * Fax (011) (52) (8) 3-90-7001 * Cel. (011) (52) (044) (8) 3-09-24-16 * Monterrey N.L. Mexico ******************************************** ======================================================================== This list server is Powered by iMS 'The Swiss Army Knife of Mail Servers' -------------------------------------- To leave this list please complete the form at http://www.CoolFusion.com/iMS.htm List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ ========================================================================
