View FAQ
Frequently Asked Questions
Search
Keyword
Categories
Categories
WebWatchBot General 
NetMailBot General 
Website - General  
NetMailBot Performance 
Watch Item Settings/Configuration 
WebWatchBot Email Settings/Configuration 
NetMailBot Mail Merge & Using a Database 
NetMailBot - Attachments 
WebWatchBot Connectivity - Network - Firewalls 
WebWatchBot Known Issues 
NetMailBot Installation 
NetMailBot Known Issues 
WebWatchBot Installation 
WebWatchBot Errors (Not Relating to Installation) 
WebWatchBot Known Issues - Resolved 
WebWatchBot Performance 
Article
Category NetMailBot Mail Merge & Using a Database 
Question/Issue I'm using Microsoft Access for my database, and I'm getting an error: "data type mismatch in criteria expression". What is the problem? 
Answer/Solution This might have something to do with your database query. Access query values should be encapsulated in pound signs, for example:

-dbquery "Select email FROM customers WHERE purchase_date = #10/7/2002#"

Pound signs are the only thing that should encapsulate a query for Access.
 
Permanent Link 114