[De.camm]

<p>
<cfquery datasource="RegStudent" name="DisplaySearchingData" >
select * from student
WHERE 1=1
<cfif #Form.SName# NEQ ''>
AND firstname LIKE '%#Form.SName#%'
<cfelse >
AND mykad LIKE '%#Form.MyKad#%'
</cfif>
ORDER BY firstname, lastname
</cfquery>
</p>

Is it any wrong with my coding? if i put else between if command, should i close it with </cfelse>???