[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?

This post has been edited by Craig328: 07 March 2012 - 06:31 AM
Reason for edit:: Please use CODE tags when posting code samples

[Craig328]

Um...that would depend. What does the error message say?

[De.camm]

The error message said that line no 8

AND mykad LIKE '%#Form.MyKad#%'

is the problem,
the coding cannot execute.

[Craig328]

Can you copy/paste the exact CF error message?

In the meantime, right above the CFQUERY do this:

<cfdump var="#form#"><cfabort>

Make sure you actually HAVE a form element called MyKad and that is has a value.

[De.camm]

The exact error message is like attachment given.

[Craig328]

No attachment.

Your original query looks to be okay as far as I can tell. The SQL syntax is correct and I'm assuming you've spelled the table names and columns correctly (if it's MySQL you may want to make sure the case spelling is identical). The exact error message text will tell you what's wrong.

[De.camm]

Craig328, on 07 March 2012 - 07:17 AM, said:

Can you copy/paste the exact CF error message?

In the meantime, right above the CFQUERY do this:

<cfdump var="#form#"><cfabort>

Make sure you actually HAVE a form element called MyKad and that is has a value.

The exact CF error message is given in jpeg file in attachment named "message_error.jpg" , after i do the code

<cfdump var="#form#"><cfabort>

, i got the small table like image given named "error_msg_after put new code.jpg".

i do have a form element called MyKad, i enclose the coding with

 <br/>
<table width="30%" align="center">
<form id="form1" name="form1" method="post" action="">
<tr>
<td>Student Name :</td>
<td width="20%"><input type="text" value="" size="35" name="SName" id="SName"  style="text-transform:uppercase;"/></td>
</tr>
<tr>
<td>MyKad No. :</td>
<td width="20%"><input type="text" name="Mykad" size="35" value="" /></td>
</tr>
<tr>
<td colspan="2"><div align="center">
  <input type="submit" name="Search Student" value="Search" onclick="DisplaySearchingData"/>
  &nbsp;<input type="Reset" name="ResetForm" value=" Reset" />
</div></td>
</tr>
</form>
</table>
<br/> 

Attached image(s)

• 
• 

[Craig328]

Well, the error message and the CFDUMP of the form scope say it all: you don't have a form.Mykad available to use in the query.

There's a few ways to remedy this (using a few CFPARAMs, adding a CFIF block in your code specifically referencing "form.Mykad" before you try and use it in the WHERE statement) but your best bet is to figure out and understand why, if you're putting a value into that field, that it's not appearing on the form processing page.

Absent both the form and form process page I can't tell you what's causing your problem but the problem itself is that form.Mykad doesn't exist as far as CF is concerned when it's trying to run your query.

[De.camm]

Thanks Craig~ my search button can detect any number element in Mykad text field input already..
Firstly I try to declare the "form.mykad" one line in "form.sname" declaration, but its not work. After I separate the declaration then its working... Thanks for guide me to success...