>Is this indeed true that MySQL doesn't seem to like the cfqueryparam >tag? If so, does the same hold true for MySQL 5?
Pete, In using several databases, I have found that only dates and booleans have ever given me trouble with cfqueryparam in any database (though I can't now remember which one where). Using CreateODBCDate() and 1/0 has worked for every database I have used and cfqueryparam has worked in every other case. Hopefully that will help you in your search. HTH, Steve Bryant Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4