NTISP: [NTISP] IDC ERROR ON LINE ONE

------=_NextPart_000_0016_01BE1F09.0D98D880
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Trying to set up a file for netscape users to subscribe for service =
using an IDC. The problem is an error when checking a conditional =
if...else statement. Here is the statement and any help would be =
appreciated.

Datasource: Radius
Username: sam
Password: IAm
Template: signup.htx
SQLStatement:
+if exists (select * from dbo.SubAccounts
+ where Login=3D'%Login%' and Password=3D'%Password%')
+ select result=3D'duplicate'
+else
+insert into =
dbo.masteraccounts(FirstName,LastName,Company,Address1,City,State,Zip,Pho=
neHome,PhoneWork,PhoneFax,Active)=20
+VALUES('%FirstName%','%LastName%','%Company%','%Address1%','%City%','%St=
ate%','%Zip%','%PhoneHome%','%PhoneWork%','%PhoneFax%',%Active%)
SQLStatement:
+select * from dbo.Masteraccounts where =
(masteraccounts.firstname=3D'%firstname%' and =
masteraccounts.lastname=3D'%lastname%')
+insert into =
dbo.Subaccounts(CustomerID,Login,FirstName,LastName,PhoneHome,PhoneWork,A=
ccountType,Password,saExpireDate,Extension,Active,LoginLimit)=20
+VALUES(%CustomerID%,'%Login%','%FirstName%','%LastName%','%PhoneHome%','=
%PhoneWork%','Unlimited','%Password%',GetDate(),5,1,1)=20
+end if

------=_NextPart_000_0016_01BE1F09.0D98D880
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Trying to set up a file for netscape =users to=20subscribe for service using an IDC. The problem is an error when =checking=20a conditional if...else statement. Here is the statement and any =help=20would be appreciated.

Datasource: =Radius
Username:=20sam
Password: IAm
Template: signup.htx
SQLStatement:
+if =exists=20(select * from dbo.SubAccounts
+ where Login=3D'%Login%' =and=20Password=3D'%Password%')
+ select=20result=3D'duplicate'
+else
+insert into=20dbo.masteraccounts(FirstName,LastName,Company,Address1,City,State,Zip,Pho=neHome,PhoneWork,PhoneFax,Active)=20
+VALUES('%FirstName%','%LastName%','%Company%','%Address1%','%City%',='%State%','%Zip%','%PhoneHome%','%PhoneWork%','%PhoneFax%',%Active%)
S=QLStatement:
+select=20* from dbo.Masteraccounts where =(masteraccounts.firstname=3D'%firstname%' and=20masteraccounts.lastname=3D'%lastname%')
+insert into=20dbo.Subaccounts(CustomerID,Login,FirstName,LastName,PhoneHome,PhoneWork,A=ccountType,Password,saExpireDate,Extension,Active,LoginLimit)=20
+VALUES(%CustomerID%,'%Login%','%FirstName%','%LastName%','%PhoneHome=%','%PhoneWork%','Unlimited','%Password%',GetDate(),5,1,1)=20
+end if