Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jwelch

    Fuzzy Search with SQL?

    this really doesn't help because how am i supposed to know each variation of the user input and then put that into a sql statement? How am i suppose to figure out colinsworth, collins, etc from the user input of 'collinsworth'?<br>
  2. jwelch

    CFMAIL

    are you sure you have the correct smtp information? Is mail forwarding turned on by your administrator? Does your smtp mail have to orginate from a email address from your company? <br> <br> Try putting a from email address that is valid in your tag.<br> <br> Try checking the smtp info.<br> <br>...
  3. jwelch

    ODBC Connection for Access 2000 and CF 4.0: Do you need 4.5?

    No, you just need the latest version of MDAC. get it from <A HREF="http://www.microsoft.com/odbc" TARGET="_new">www.microsoft.com/odbc</A> you need to have version 4.x for Access 2000.<br> <br> The new version of the MDB ODBC driver will work with both 2000 and 97 versions of mdb files.<br>
  4. jwelch

    Fuzzy Search with SQL?

    Using SQL with a ODBC source...<br> <br> Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text), ...<br> <br> A user could enter &quot;Colinsworth&quot; as a parameter and the query would return...
  5. jwelch

    word score

    the underlying result would be a name search that would return the closest name if an exact name isn't found
  6. jwelch

    word score

    The user would enter a first and last name or just one of the two, and the query would return records with a score of how close the fname and lname matched. <br> <br> If there is an exact match of first name and last name then the score would be 100%, if only first name or only last name then...
  7. jwelch

    word score

    Sorry, for some reason the last post got truncated.<br> <br> <br> Using SQL with a ODBC source which is a Access2000 database...<br> <br> Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text)...
  8. jwelch

    word score

    Is there a way that I can create a query that will return a word approximate score such as: (refering to a table with first_name (text), last_name (text), ...<br> <br> A user could enter

Part and Inventory Search

Back
Top