ok I understand now but this file would need domain check because if there
is a username called "webmaster" and if there are 100 webmaster on the POPS
table (one for each domain) the #password# will bring you many passwords.
is the #todomain# variable available on this template to bring the correct
password for this username?
At 02:30 p.m. 07/06/00 -0400, you wrote:
>I think your query should be:
>
><cfquery name="getpassword" datasource="iMS" dbtype="ODBC">
>SELECT password FROM pops WHERE user='#SMTPAUTHUSER#'>
></cfquery>
>
>
>The easiest way to verify is to make a test template like:
>
><cfset smtpauthuser="guillermo">
>
><cfquery name="getpassword" datasource="iMS" dbtype="ODBC">
>SELECT password FROM pops WHERE user='#SMTPAUTHUSER#'>
></cfquery>
>
><cfoutput query="getuser">
>#password#
></cfoutput>
>
>Regards,
>
>Howie Hamlin
>--
>inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
>www.CoolFusion.com
>============================================================
>Please vote for iMS in the Most Innovative category here:
>*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
>============================================================
>Check out inFusion Mail Server - the world's most configurable email server
>
>----- Original Message -----
>From: Guillermo Dewey <[EMAIL PROTECTED]>
>To: inFusion Support List <[EMAIL PROTECTED]>
>Sent: Wednesday, June 07, 2000 2:20 PM
>Subject: Re: [iMS] Non-RFC Compliant Messages
>
>
>I have made the upgrade for the smtp auth
>
>I have created the new template but got this error on the log
>
>06/07/2000 01:10:11 PM [001] WARNING: Application server response:
>06/07/2000 01:10:11 PM [001] WARNING: Template=f:\iMS\domains\SMTPAUTH.cfm
>06/07/2000 01:10:11 PM [001] WARNING: Content-type: text/html
>06/07/2000 01:10:11 PM [001] WARNING: Page-Completion-Status: Abnormal
>06/07/2000 01:10:11 PM [001] WARNING: <HTML><HEAD><TITLE>Error Occurred
>While Processing Request</TITLE></HEAD><BODY><HR><H3>Error Occurred While
>Processing Request</H3><P> <TABLE BORDER><TR><TD><H4>Error Diagnostic
>Information</H4><P>ODBC Error Code = 37000 (Syntax error or access
>violation)<P><P> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
>Incorrect syntax near '>'.<P><P><p>The error occurred while processing an
>element with a general identifier of (CFQUERY), occupying document position
>(1:1) to (1:45).</p><P><P>Date/Time: 06/07/00 13:10:11<BR>Browser:
><BR>Remote Address: 148.235.35.4<P></TD></TR></TABLE><P><HR>
>
>
>the code for the new file is
>
><cfquery name="getpassword" datasource="iMS" dbtype="ODBC">
>SELECT password FROM pops WHERE user="SMTPAUTHUSER">
></cfquery>
>
><cfif #getpassword.recordcount# gt 0>
><cfoutput>
>result=accept
>password=#getpassword.password#
></cfoutput>
><cfelse>
>result=reject
></cfif>
>
>I cant find any syntax error.. Is there a change need to be done on the
>data bases structure?
>
>thanks
>
>
>
>
>
>========================================================================
> 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/
>========================================================================
********************************************
* 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/
========================================================================
