We're building an app that allows a user to query a library SQL Server 2000 database. The SQL syntax uses the MS SQL T-SQL COLLATION qualifier, which allows users to type in things like "Montreal" or "Montr�al" and get all records that match, regardless of whether you use accented characters or not in your search criteria, and whether or not the data itself is accented.
This works really well, the only problem is that what we wanted to do was use query caching and run the user's query against a cached Select * type of query (stored in memory via CF). This would dramatically speed up the performance of the app. The querying a cached query works really well performance wise, unfortunately, the extended character neutral search breaks, because CF (naturally) doesn�t support T-SQL extensions. Does anyone know a way to get CF to ignore extended characters when using the Query a Query feature? Might it be a character encoding thing? Sean Kozey CTO, cybergod | ecentricarts Inc. email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
