| Author |
 Topic  |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
 Posted - 17 July 2001 : 15:49:06
|
this is what i am outputting. each one is going into a text field in access, and ideas whats up with this?
UPDATE CustomersAccounts SET CustomerCC_BillingCycle = '12', CustomerCC_CardType = 'Visa', CustomerCC_CCNumber = '1234567890', CustomerCC_NameOnCard = 'Brad Wickwire', CustomerCC_IssuingBank = 'BankOne', CustomerCC_BillingPhoneNumber = '111-111-1111', CustomerCC_BillingStreetAddress = '111 My street', CustomerCC_BillingCity = 'Dallas', CustomerCC_BillingState = 'TX', CustomerCC_BillingZip = '75044', CustomerCC_BillingCountry = 'United States' WHERE Customer_ID = '22'
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/hosting/signup2.asp, line 42
Brad |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 July 2001 : 15:59:16
|
What datatype is Customer_ID ?
Maybe it should be: Customer_ID = 22 |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 July 2001 : 16:05:40
|
Its a AutoNumber, but I just fixed it, i removed the ' from arounf the ID field and it worked, I swear i did that and it didn't work, oh well, thanks for your help anyway
Brad |
|
|
| |
Topic |
|
|
|
Topic Locked
