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

At 01:41 p.m. 07/06/00 -0400, you wrote:
>Actually, the new feature is so that mail that is not terminated properly
>(with a <CRLF>.<CRLF>) can still be delivered.
>
>Regards,
>
>Howie
>
>----- Original Message -----
>From: Guillermo Dewey <[EMAIL PROTECTED]>
>To: inFusion Support List <[EMAIL PROTECTED]>
>Sent: Wednesday, June 07, 2000 1:26 PM
>Subject: [iMS] Non-RFC Compliant Messages
>
>
>Hi
>
>about the new feature (Non-RFC Compliant Messages)
>
>I made a fwd function as shown ( on data.cfm )
>
>     <cfloop query="GetUnknownRecipient">
>
>     <cfif #header_From#  IS  "">
>     <cfset header_From = "Desconocido / Unknown">
></cfif>
>
>             <cfx_iMSMail
>       smtpto="#GetUnknownRecipient.UnknownRelay#"
>            smtpfrom="#HEADER_FROM#"
>            header_Subject="#HEADER_SUBJECT#"
>            header_To="#header_To#"
>            header_From="#header_From#"
>            body="Este mensaje fue re-direccionado a esta cuenta."
>            RFC822Attachment = #emailfile#>
>
>     </cfloop>
>
>
>this will bring all the forward messages with a heather like this (lus the
>original one having 2 heathers)
>
>Received: from [148.235.35.43]
>by server1.metro.com.mx (inFusion Mail Server v1.2.5 [inFusionEngine
>1.1.3]) with ESMTP id D97B5408EE3BD4118BF80000F8061514
>for <[EMAIL PROTECTED]>; Wed, 7 Jun 2000 12:06:44 -0400
>Content-type: text/plain
>Date: Wed, 07 Jun 2000 12:06:13 -0500
>From: [EMAIL PROTECTED]
>Subject: Metro Cybercomercio Notificac�n de Pedido por FAX.
>To: [EMAIL PROTECTED]
>Message-ID: [EMAIL PROTECTED]
>
>
>so with this new feature I can make normal forwards?
>
>
>********************************************
>*   Ing. Guillermo Dewey Guerra
>*   Metro Cybercomercio Mexico
>*   [EMAIL PROTECTED]
>*   ICQ: 25876549 (GDewey)
>*
>*   http://www.metro.com.mx
>*   http://www.coldfusion.com.mx
>*   http://www.ablecommerce.com.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/
>========================
>
>
>
>========================================================================
>      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/
�����������������������==

Reply via email to