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?
- Tim
---------- Original Message ----------------------------------
From: "Don Barron" <don@world-link.com.au>
Reply-To: emerald@iea-software.com
Date: Thu, 15 Apr 1999 18:16:22 +0930
>Howdy
I think we are getting there but now I get this error ;
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
/signup/signup.asp, line 2193
Any idea Dale ?
>> Ahh cool, I got the same error when trying that signup server. Do you
think
>> you'd be able to supply a fix for it Dale ?
>
>In the signup.asp file, change the section:
>
>> <b>Type of credit card</b> <br>
>> <select name="ccard" size=1 tabindex="2" value="">
>> <option selected> <% = ccard %>
>> <option value="AMEX"> American Express
>> <option value="Discover"> Discover
>> <option value="MasterCard"> MasterCard
>> <option value="Visa"> Visa
>> </select>
>
>to:
>
> <b>Type of credit card</b> <br>
> <select name="ccard" size=1 tabindex="2" value="">
> <option selected> <% = ccard %>
> <option value="Credit Card"> American Express
> <option value="Credit Card"> Discover
> <option value="Credit Card"> MasterCard
> <option value="Credit Card"> Visa
> </select>
>
>
>Your other options are to take this completely out and hard code
>"Credit Card" in the insert statement, or replace this section with a
>hidden field with the same name, and "Credit Card" as the value.
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com