Question
Problem with CF code in JavaScript
Hi,
I am using <cfquery> tag in my javascript code , but I am getting a syntax error , because I am not able to assign the javascript value in my SQL where clause. Can you please correct my following code (particularly where condition)
Here is my function
function test () {
var licHolderState = "<cfoutput>#state#</cfoutput>";
with (document.testFrm) {
if (licHolder.value == '')
{
alert("You must enter a licHolder.");
licHolder.focus()
return false;
}
else if (licHolderState == 'XX')
var licHolderName = trim(licHolder.value);
<cfquery name = "licDetails" datasource = "Aftershock">
select * from licenceTbl where
name = ????? (should be licHolderName value)
</cfquery>
<cfif licDetails.Status EQ 0>
{
alert("Not a valid entry.");
licHolder.focus()
return false;
}
</cfif>
else
return true;
}
}
Thanks
I am using <cfquery> tag in my javascript code , but I am getting a syntax error , because I am not able to assign the javascript value in my SQL where clause. Can you please correct my following code (particularly where condition)
Here is my function
function test () {
var licHolderState = "<cfoutput>#state#</cfoutput>";
with (document.testFrm) {
if (licHolder.value == '')
{
alert("You must enter a licHolder.");
licHolder.focus()
return false;
}
else if (licHolderState == 'XX')
var licHolderName = trim(licHolder.value);
<cfquery name = "licDetails" datasource = "Aftershock">
select * from licenceTbl where
name = ????? (should be licHolderName value)
</cfquery>
<cfif licDetails.Status EQ 0>
{
alert("Not a valid entry.");
licHolder.focus()
return false;
}
</cfif>
else
return true;
}
}
Thanks