How to validate input tag with onchange event which check database record?

[kasturi207]

I want to validate input (text) which i have to check with databse record is exist.
the code something like that:-

<cfscript>
function checkkp() {
if (rscheck.recordcount NEQ 0) {
    writeoutput("Rekod telah wujud");
    return false;
    }
}
</cfscript>
<cfif isdefined("form.tnokp") and #from.tnokp# EQ "">
    <cfquery name="rscheck" datasource="tryxx">
    SELECT *
    FROM dbo.oxy
    WHERE NoKP = '#Form.tnokp#'</cfquery>
</cfif>
 
....
 
<input name="tnokp" type="text" id="tnokp" onchange="checkkp(this.value)" value="<cfoutput>#rsKemas.NoKP#</cfoutput>" size="16" maxlength="12" />

i have try this. but stil update the value even the record is exist.

[acoder]

This is not going to work. You're trying to combine Coldfusion and JavaScript by calling a Coldfusion function via a JavaScript way.

To solve this, either use Ajax (call the server-side code via JavaScript) or validate on the server-side only.

PS. please use [code] tags