Search jQuery

jQuery Forum

How do I add parameters to autocomplete call?

in Using jQuery Plugins • 5 years ago

I currently use Autocomplete with Coldfusion to run a DB2 Stored procedure. The user starts to enter a part number and autocomplete returns a list of matching part numbers. This works fine but I now need to add a couple of parameters to the query and have no idea how to change the autocomplete call to achieve this. I will admit that while I think jQuery is brilliant but I find it all very confusing and don't understand it enough to go beyond very basic usage.

Here's what I have now;

In the page where the user enters the part number (PARTENQ.cfm) -

<HEAD>
<link rel="stylesheet" href="../jQuery3.1.0/jquery-ui-1.12.0.custom/jquery-ui-theme-base.css">
<link rel = "stylesheet" href = "/agconetTplTest11/styles/DaveStyle.css">
<script type="text/javascript" language="javascript" src="../jQuery3.1.0/jquery-3.1.0.min.js"></script>
<script type="text/javascript" language="javascript" src="../jQuery3.1.0/jquery-ui-1.12.0.custom/jquery-ui.min.js"></script>
<script>
$(function() {
$( "#PARTPASS" ).autocomplete({minLength: 3, source: 'partEnqAutocompleteQuery.cfm'});
});
</script>
:
</head>
:
<body>
<form>
:
<td><div class="ui-widget">
<INPUT type = "Text" name = "PARTPASS" id = "PARTPASS" SIZE = "15" MAXLENGTH = "15" class = "partsAutoComplete" >
</div>
</td>

In partEnqAutoCompleteQuery.cfm

<cfparam name = "url.term" default = "">
<cfstoredproc procedure="SPGETPARTENQAUTO" datasource="#Application.MVXDS#" returncode="yes">
<cfprocparam cfsqltype="cf_sql_varchar" value=#Application.MVXDT#>
<cfprocparam cfsqltype="cf_sql_integer" value="501">
<cfprocparam cfsqltype="cf_sql_varchar" value="#url.term#">
<cfprocresult name="parts">
</cfstoredproc>
<cfset session.partslist = ArrayNew(1)>
<cfloop query = "parts">
<cfset p = StructNew()>
<cfset p["label"] = "#parts.mmitno# - #parts.mmitds#">
<cfset p["value"] = parts.mmitno>
<cfset ArrayAppend(session.partslist,p)>
</cfloop>
<cfset json = SerializeJSON(session.partslist)>
<cfcontent reset="true" type="application/json"><cfoutput>#json#</cfoutput><cfabort>

I need to add two String parameters to the Stored Procedure. The values for these parameters would not be entered by the user, but would be variables determined by the coldfusion code.

What changes do I make to the autocomplete initialisation script?
How do I access the parameters in partEnqAutoCompleteQuery.cfm?

Thanks for helping a jQuery tyro.

Replies(5)

jakecigar

Re: How do I add parameters to autocomplete call?

5 years ago

I would use

$("#PARTPASS").autocomplete({
minLength: 3,
source: function(request, response) {
$.getJSON('partEnqAutocompleteQuery.cfm', {
term: request.term,
something: "foo",
otherthing: "bar"
}, response)
}
});

And, as for how to access parameters in CF, you may have to find a CF forum.

JΛ̊KE

Ron Ventu..

Re: How do I add parameters to autocomplete call?

5 years ago

Hi Jake.

Thanks for the quick response.

I tried that and it works - up to a point. I was able to determine that "something" and "otherthing" are set up as url variables with values of "foo" and "bar" respectively. the question now is: how do I get real-life values into those variables from my web page?

If I was to set up hidden text boxes like this:

<input type="hidden" name ="something" value = "foo">
<input type="hidden" name ="otherthing" value = "bar">

How would I refer to them in the call? Do I have to add id= and/or class= to the input tag?

jakecigar

Re: How do I add parameters to autocomplete call?

5 years ago

something: $("[name='something']").val(),
otherthing: $("[name='otherthing']").val()

That assumes there is only one name='something' and one name='otherthing'.

JΛ̊KE

Ron Ventu..

Re: How do I add parameters to autocomplete call?

5 years ago

Thanks Jake.

That's the answer. I now have the issue that one of my parameters is a string with embedded quotes in it. I need to find a way to pass that to the url. but that is not a jQuery issue so I won't burden this forum with it.

Once again, thanks very much Jake.

jakecigar