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>
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>...
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>
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 "Colinsworth" as a parameter and the query would return...
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...
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)...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.