And in case you wanted some code, here's the way that I used it:
---- Main page that uses autocomplete:
<script src="/lib/jquery.js" type="text/javascript"></script>
<script src="/lib/autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#sku").autocomplete("searchskus.cfm", { minChars:3, matchSubset:1,
matchContains:1, cacheLength:10, selectOnly:1, lineSeparator:"~",
cellSeparator:"|", onItemSelect:selectItem });
});
function selectItem(li) {
var v = li.extra[0];
$( "#sku" ).val( v );
}
</script>
---- CFM Called by AutoComplete Ajax method:
<cfsetting showdebugoutput="no" enablecfoutputonly="no">
<cfquery datasource="#request.ds#" name="product">
select title, sku
from products
where (title like '%#url.q#%'
or sku like '%#url.q#%')
and parentSKU = ''
order by title
</cfquery>
<cfcontent type="text/html" reset="Yes" />
<cfheader name="Content-Type" value="text/html; charset=UTF-8">
<cfsavecontent variable="prods">
<cfoutput
query="product">#trim(product.title)#|#trim(product.sku)#~</cfoutput>
</cfsavecontent>
<cfoutput>#trim( prods )#</cfoutput>
Priest, James (NIH/NIEHS) [C] wrote:
> I'm working on an administration tool and I'd like to use jQuery to
> populate a user field - IE the user would type in a few letters of the
> last name and have it find the matching names...
>
> I know there are lots of ColdFusion folks on the list - I'm looking for
> some examples :)
>
> I've used jQuery quite a bit in the rest of this application but it's
> all been for display/UI - no Ajax - so now I want to give that a try.
>
> Thanks!
> Jim
>
> _______________________________________________
> jQuery mailing list
> discuss@jquery.com
> http://jquery.com/discuss/
>
--
BrightLight Development, LLC.
954-775-1111 (o)
954-600-2726 (c)
[EMAIL PROTECTED]
http://www.iambright.com
_______________________________________________
jQuery mailing list
discuss@jquery.com
http://jquery.com/discuss/
