Ok, here's a link to a test page;
http://www.taxsearchinc.com/test/index.cfm
If you type charles w you will see one of the problems
On Aug 22, 5:13 pm, "Jörn Zaefferer" <[EMAIL PROTECTED]>
wrote:
> Yes, reformulating your question could help a lot. Usually a testpage
> with a short description of the context and the issue is best.
>
> Jörn
>
> On Fri, Aug 22, 2008 at 11:27 PM, larksys <[EMAIL PROTECTED]> wrote:
>
> > Guess I should have asked it
> > differently.................................
>
> > On Aug 21, 10:07 pm, larksys <[EMAIL PROTECTED]> wrote:
> >> I finally am beginning to understand some of this. It took a little
> >> bit for the fact that variable "q" was being passed and not the id of
> >> the input element. And it's right there in the documentation. I've
> >> tested my query and it give the results I want. But the results passed
> >> to the autocomplete are strange. If I type "charles w" I get "Charles
> >> Wade" but there are 7 more matches in the backend query. And,
> >> following the one item returned, I get code like;
> >> .debug
> >> {
> >> color:black;
> >> background-color:white;
>
> >> Am I not delimiting the list properly?
>
> >> <link rel="stylesheet" type="text/css" href="/js/jquery/
> >> jquery.autocomplete.css" />
> >> <script type="text/javascript" src="/js/jquery/jquery-1.2.6.js"></
> >> script>
> >> <script type="text/javascript" src="/js/jquery/
> >> jquery.autocomplete.js"></script>
>
> >> <script type="text/javascript">
> >> $(document).ready(function(){
> >> $("#NewCandidate").autocomplete("panels/panelCandidates_1_db.cfm",
> >> {
> >> width: 460,
> >> selectFirst: false,
> >> cacheLength:1,
> >> mustMatch:true
> >> });
>
> >> });
> >> </script>
>
> >> <cfinput name="NewCandidate" type="text" autocomplete="off" size="80" /
>
> >> <cfif #find(q,",")#>
> >> <cfset Fname = "#listfirst(q,",")#">
> >> <cfset Lname = "#Listlast(q,",")#">
> >> <cfelse>
> >> <cfset Fname = "#q#">
> >> <cfset Lname = "">
> >> </cfif>
>
> >> <cfif #find(q,",")#>
> >> <cfset Fname = "#listfirst(q,",")#">
> >> <cfset Lname = "#Listlast(q,",")#">
> >> <cfelse>
> >> <cfset Fname = "#q#">
> >> <cfset Lname = "">
> >> </cfif>
>
> >> <cfquery name="QsrchIndivs" datasource="#request.dsn#" maxrows="10">
> >> SELECT ui.firstname + ' ' + ui.lastname + ' -----' + c.name + ' ' +
> >> c.city + '------ ^' + cast(ui.id as varchar) as
> >> Iname,ui.firstname,ui.lastname,ui.current_company_number,c.name,c.city,ui.id
> >> FROM users_info as ui
> >> left join companies as c on
> >> c.id = ui.current_company_number
> >> WHERE upper(ui.firstname) like
> >> '#ucase(Fname)#%' <cfif #Lname#
> >> gt " ">And upper(ui.lastname) like '#ucase(Lname)#%' </cfif>
> >> </cfquery>
>
> >> <cfoutput query="QsrchIndivs">
> >> #QsrchIndivs.Iname#
> >> </cfoutput>
