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/
========================================================================
