Announcement

#2 · 04-14-05, 01:12 PM

MvSMTP error 5.5.2 Syntax error in parameters scanning "TO"

Have you checked what the ouput really is of the l.toemail field?

<MvWHILE EXPR = "{ NOT USMCMAIL.d.EOF }">
<MvASSIGN NAME = "l.toemail" VALUE = "{ l.toemail $
USMCMAIL.d.EMAIL $ ',' }">

<MvEval expr="{ l.toemail }">

<MvSKIP NAME = "USMCMAIL" ROWS = 1>
</MvWHILE>

=============================
Bill Gilligan
Gilligan On-Line
www.gilliganonline.com
850-233-8775

> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Ralph Gauer
> Sent: Thursday, April 14, 2005 4:04 PM
> To: [email protected]
> Subject: [meu] MvSMTP error 5.5.2 Syntax error in parameters
> scanning "TO"
>
> Hello,
>
> A script uses this code to build an email address from a
> database of entries:
>
> <MvWHILE EXPR = "{ NOT USMCMAIL.d.EOF }">
> <MvASSIGN NAME = "l.toemail" VALUE = "{ l.toemail $
> USMCMAIL.d.EMAIL $ ',' }">
> <MvSKIP NAME = "USMCMAIL" ROWS = 1>
> </MvWHILE>
>
> <MvSMTP
> TO="{ l.toemail }"
> FROM="[email protected]"
> MAILHOST="localhost"
> SUBJECT="Comments from the USMC technical
> illustration management
> page">
> <MvEVAL EXPR="{asciichar(13) $ asciichar(10)}">
> ...etc
> ...etc
>
>
> It generates this error
>
> >Runtime error in USMC/update.mvc @ [00000000:000005fa]:
> update.mv: Line
> >58: MvSMTP: 5.5.2 Syntax error in parameters scanning "TO"
>
>
> Worse, it works just fine on one server but not the intended host.
>
> Any thoughts? Am I doing something marginal that one server
> is gagging on?
>
> All input welcome.
>
> Thanks
> rg
>
>
>
>
>
>
>
> Ralph Gauer
> [email protected]
> www.ralphgauer.com
> 505-534-4184
> Silver City, New Mexico
>
>
>

#3 · 04-14-05, 01:33 PM

MvSMTP error 5.5.2 Syntax error in parameters

Bill,

The trailing coma seems to have been the offending issue... although one
server allows it, the new one does not. Making the last entry of l.toemail
without a following coma fixes it, at any rate.

Thanks
rg

At 04:12 PM 4/14/2005 -0500, Bill Gilligan wrote:
>Have you checked what the ouput really is of the l.toemail field?
>
><MvWHILE EXPR = "{ NOT USMCMAIL.d.EOF }">
> <MvASSIGN NAME = "l.toemail" VALUE = "{ l.toemail $
> USMCMAIL.d.EMAIL $ ',' }">
>
><MvEval expr="{ l.toemail }">

>
> <MvSKIP NAME = "USMCMAIL" ROWS = 1>
> </MvWHILE>
>
>
>=============================
>Bill Gilligan
>Gilligan On-Line
>www.gilliganonline.com
>850-233-8775
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of Ralph Gauer
> > Sent: Thursday, April 14, 2005 4:04 PM
> > To: [email protected]
> > Subject: [meu] MvSMTP error 5.5.2 Syntax error in parameters
> > scanning "TO"
> >
> > Hello,
> >
> > A script uses this code to build an email address from a
> > database of entries:
> >
> > <MvWHILE EXPR = "{ NOT USMCMAIL.d.EOF }">
> > <MvASSIGN NAME = "l.toemail" VALUE = "{ l.toemail $
> > USMCMAIL.d.EMAIL $ ',' }">
> > <MvSKIP NAME = "USMCMAIL" ROWS = 1>
> > </MvWHILE>
> >
> > <MvSMTP
> > TO="{ l.toemail }"
> > FROM="[email protected]"
> > MAILHOST="localhost"
> > SUBJECT="Comments from the USMC technical
> > illustration management
> > page">
> > <MvEVAL EXPR="{asciichar(13) $ asciichar(10)}">
> > ...etc
> > ...etc
> >
> >
> > It generates this error
> >
> > >Runtime error in USMC/update.mvc @ [00000000:000005fa]:
> > update.mv: Line
> > >58: MvSMTP: 5.5.2 Syntax error in parameters scanning "TO"
> >
> >
> > Worse, it works just fine on one server but not the intended host.
> >
> > Any thoughts? Am I doing something marginal that one server
> > is gagging on?
> >
> > All input welcome.
> >
> > Thanks
> > rg
> >
> >
> >
> >
> >
> >
> >
> > Ralph Gauer
> > [email protected]
> > www.ralphgauer.com
> > 505-534-4184
> > Silver City, New Mexico
> >
> >
> >

#4 · 04-14-05, 01:36 PM

MvSMTP error 5.5.2 Syntax error in parameters scanning

I bet it's because there's always going to be a trailing comma at the
end of your l.toemail string. Don't know for sure, but sometimes
servers get picky about that kind of thing. Otherwise it looks fine.

I would do something like this at the end to get rid of the comma:

substring(l.toemail,1,(len(l.toemail) - 1))

The other thing I would do is put an MvIF in there to make sure that
USMCMAIL.d.EMAIL has a value. There might be a blank record and then
you'd have a ,, entry into your l.toemail string which m ight break the
smtp server as well.

Scot

Ralph Gauer wrote:
> Hello,
>
> A script uses this code to build an email address from a database of
> entries:
>
> <MvWHILE EXPR = "{ NOT USMCMAIL.d.EOF }"> <MvASSIGN NAME =
> "l.toemail" VALUE = "{ l.toemail $ USMCMAIL.d.EMAIL $ ',' }"> <MvSKIP
> NAME = "USMCMAIL" ROWS = 1> </MvWHILE>
>
> <MvSMTP TO="{ l.toemail }" FROM="[email protected]"
> MAILHOST="localhost" SUBJECT="Comments from the USMC technical
> illustration management page"> <MvEVAL EXPR="{asciichar(13) $
> asciichar(10)}"> ...etc ...etc
>
>
> It generates this error
>
>> Runtime error in USMC/update.mvc @ [00000000:000005fa]: update.mv:
>> Line 58: MvSMTP: 5.5.2 Syntax error in parameters scanning "TO"
>
>
>
> Worse, it works just fine on one server but not the intended host.
>
> Any thoughts? Am I doing something marginal that one server is
> gagging on?
>
> All input welcome.
>
> Thanks rg
>
>
>
>
>
>
>
> Ralph Gauer [email protected] www.ralphgauer.com 505-534-4184
> Silver City, New Mexico
>
>
>