Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Data type mismatch in criteria expression
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 17 July 2001 :  15:49:06  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
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  Show Profile
What datatype is Customer_ID ?

Maybe it should be: Customer_ID = 22
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 17 July 2001 :  16:05:40  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07