Search Criteria case sensitive when using ODBC   Logged in as: Guest   Printable Version All Forums >>Taking FrontPage Further >>FrontPage and Databases >> Page: [1] Name: Message << Newer Topic  Older Topic >> chungchau   Posts: 15 Member since: 1/18/2005   Search Criteria case sensitive when ...  I used FP2003 to connect MS Access DB. In MS Access some of the datasource are static (import from .xls) and some dynamic (via ODBC to Oracle db). When I create a FP db template using Database Interface Wizard and create search criteria, the search criteria that are using ODBC is case sensitive, meaning user must type EXACTLY to show result. Is it possible to make the search filed not case sensitive?? The one using static source is NOT case sensitive by default. I have tried to convert the back-end and convert the field to UPPER(field_name), then I create uppercase style on the search field. Well...now the search field convert to uppercase and getting result but in some instance when the 'Caps Lock' key is turn off I do not get result. It appear the css style, even thought it's converted search text to uppercase, it has no affect on the database side. Sorry I understand this is very confusing. _____________________________   Report Abuse |  Date: 7/19/2010 6:49:49 AM TexasWebDevelopers Posts: 7242 Member since: 9/24/2002 From: USA RE: Search Criteria case sensitive w... (in reply to chungchau)  If you are connecting to a database server through ODBC the server configuration determines whether it is case-sensitive or not. Change the setting at the server. < Message edited by TexasWebDevelopers -- 7/19/2010 9:47:32 AM > _____________________________ Follow us on TWITTER   Report Abuse |  Date: 7/19/2010 9:47:06 AM Page:   [1] All Forums >>Taking FrontPage Further >>FrontPage and Databases >> Page: [1] Jump to: Select a ForumFrontPage Talk Forums     About FrontPageTalk.Com     Forum Rules     The Water Cooler     FrontPage Talk Moderators     Critique My SiteExpression Suite Talk Forums     The Suite Spot     Expression Web Questions Talk and Chat     Expression Web Tips and Tricks     Expression Web Critiques     Expression Graphic Designer     Expression Interactive DesignerFrontPage Specific Issues     FrontPage Newbies     FrontPage Experts     FrontPage Themes and Templates     FrontPage Graphics     Specific Server / Server Extension Issues     FrontPage Tips and Tricks     FrontPage 2003     FrontPage 2002Taking FrontPage Further     FrontPage and FrontPage Cart     FrontPage and SharePoint     FrontPage and Site Build It     FrontPage and Databases     FrontPage and E-Commerce     FrontPage and "Other" Editors     FrontPage and Scripting     Newsletters You Might Enjoy     Tools You Can Use     HTML     Great Links     Making Money with FrontPage     Popups!!!???     Freelance Work     Dear Microsoft ...Product Specific     FrontPage Power Meta Toolkit New Messages No New Messages Hot Topic w/ New Messages Hot Topic w/o New Messages Locked w/ New Messages Locked w/o New Messages  Post New Thread  Reply to Message  Post New Poll  Submit Vote  Delete My Own Post  Delete My Own Thread  Rate Posts

Visit the other Sites in the FrontPage World Network: FrontPage World, FrontPage Audio Manual, FrontPage Tools, FrontPage World Hosting, FrontPage Cart, FrontPage Power Edit Version 2.0, FrontPage Secrets and FrontPage World Directory. Best Podcast Book Is Here | Zune Is Here | eMedia and Audiobooks Are Here