Re: [Emerald] ONLine Setup

talon ( (no email) )
Thu, 15 Apr 1999 16:49:11 EST

ok , i did some checking and the account type is 56K/64K
so i changed that in the asp, but i get the same error.
But, when i do select AccountType from AccountTypes I get
AccountType
---------------
33.6
56K/64K

Here is the asp code:
<b>Type of Dial Up Account.</b> <br>
<select name="accounttype" size=1 tabindex="2" value="">
<option selected> <% = accounttype %>
<option value="56K/64K"> 56K/64K
</select>
Here is the error again:
INSERT INTO MasterAccounts (active, firstname, lastname, address1,address2, city, state, zip, phonehome, phonework, phonefax, PayMethod, creditcardnumber, creditcardexpire, creditcardauth, GroupID, PayPeriod, Region, Extension, SalesPerson, LastModifyUser) VALUES(-1, 't','T','43 T','','in','in','46333','317-713-1313',' ', ' ', 'Credit Card','4444444444444444','0101','T T',1, 'Monthly','Indianapolis',10, 'Internet', 'Internet' )INSERT INTO SubAccounts (CustomerID, Login, Discount, Email, FirstName,LastName, PhoneHome, PhoneWork, AccountType, Description, Password, SystemType, ModemSpeed, NetSoftware, Operator, LastModifyUser, LoginLimit, saCurrent ) VALUES(1071,'test','test@midlink.com','t','T','317-713-1313',' ', '56K/64K','Normal Users','24mb','kBJ423','pentium II','67200','MS Explorer 3.0','Internet','Internet',2,-1)
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__SubAccoun__Accou__0A489020'. The conflict occurred in database 'Emerald', table 'AccountTypes', column 'AccountType'

/signup/signup.asp, line 1947

Dale, I would really appreciate your help with this....

Thanks,

- Tim

---------- Original Message ----------------------------------
From: "Dale E. Reed Jr." <daler@iea-software.com>
Reply-To: emerald@iea-software.com
Date: Thu, 15 Apr 1999 13:20:47 -0700

>talon wrote:
>
> Ok.. i made the changes to "Credit Card" but now I get this error:
>
> INSERT INTO MasterAccounts (active, firstname, lastname, address1,address2, city, state, zip, phonehome, phonework, phonefax, PayMethod, creditcardnumber, creditcardexpire, creditcardauth, GroupID, PayPeriod, Region, Extension, SalesPerson, LastModifyUser) VALUES(-1, 'Tim2','Blanton','43 Test','','Indpls','in','46222','317-244-3849',' ', ' ', 'Credit Card','49963612701212013','0301','Tim Blanton',1, 'Annually','Indianapolis',10, 'Internet', 'Internet' )INSERT INTO SubAccounts (CustomerID, Login, Email, FirstName,LastName, PhoneHome, PhoneWork, AccountType, Discount, Description, Password, SystemType, ModemSpeed, NetSoftware, Operator, LastModifyUser, LoginLimit, saCurrent ) VALUES(1062,'test123','test123@midlink.com','Tim2','Blanton','317-244-3849',' ', '56K','Normal Users','32mb','Fo*083','pentium','33600','MS Explorer 3.0','Internet','Internet',2,-1)
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__SubAccoun__Accou__0A489020'. The conflict occurred in database 'Emerald', table 'AccountTypes', column 'AccountType'
>
> /signup/signup.asp, line 1947
>
> Any ideas?

Its the same type of Error. You need to modify the account list to
match YOURS. In the above the AccountType is 56K. Do yuo have a
service type of 56K?

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com