Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

cfquery and LIKE problem

Hello experts.
I have a search page with a search form where i can check more than 1 one checkboxes with the same name but different values.

What like must be the query in the result page to get the items with Kat_ID =7 and items with Kat_ID =2
and items with Kat_ID =4 if i would check the three boxes.
The test query i have don't work:(i have no results)
<cfquery name="artikel" datasource="#dsn#">
SELECT Kat_ID
 WHERE
<cfif isdefined("Url.S_Kat_ID") AND Url.S_Kat_ID NEQ "">     
   Kat_ID LIKE <cfqueryparam value="#URL.S_Kat_ID#" cfsqltype="cf_sql_numeric">
      </cfif>
</cfquery>        
<input name="S_Kat_ID" type="checkbox" id="S_Kat_IDvan" value="7" />
<input name="S_Kat_ID" type="checkbox"id="S_Kat_IDPU" value="2" />
<input name="S_Kat_IDPU" type="checkbox"id="S_Kat_IDKB" value="4" />

Open in new window

0
Panos
Asked:
Panos
  • 5
  • 4
1 Solution
 
Andrew MaurerCommented:
Couple things..

I see your three values.. one is not the same name as the other two.. S_Kat_IDPU

Also.. you are checking if a variable is defined and whats its value is... if the variable was not defined, your if statement would throw a error.

AND.. use the IN operator

<cfif isdefined("Url.S_Kat_ID")>
    <cfif Url.S_Kat_ID NEQ "">      
        Kat_ID IN (<cfqueryparam value="#URL.S_Kat_ID#" cfsqltype="cf_sql_integer" list="yes">
    </cfif>
</cfif> 

Open in new window

0
 
Andrew MaurerCommented:
correction... missing right paren )
<cfif isdefined("Url.S_Kat_ID")>
    <cfif Url.S_Kat_ID NEQ "">      
        Kat_ID IN (<cfqueryparam value="#URL.S_Kat_ID#" cfsqltype="cf_sql_integer" list="yes">)
    </cfif>
</cfif>

Open in new window

0
 
PanosAuthor Commented:
Hi again Zadoc.
The IN operator is not working and i have error.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Andrew MaurerCommented:
what is the error?
0
 
PanosAuthor Commented:
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 34: Incorrect syntax near '@P2'.


0
 
PanosAuthor Commented:
The error occurred in C:\Inetpub\wwwroot\car&home7\resultscheck.cfm: line 107

105 : <cfif isDefined ("Url.S_Mobile_Sub_ID")>
106 :     <cfif   Url.S_Mobile_Sub_ID>  
107 :  AND  a.Mobile_Sub_ID = <cfqueryparam value="#URL.S_Mobile_Sub_ID#" cfsqltype="cf_sql_numeric">
108 :       </cfif>
109 :    </cfif>
0
 
Andrew MaurerCommented:
for your second comment.. you haVe this
<cfif   Url.S_Mobile_Sub_ID>

maybe...
<cfif   Url.S_Mobile_Sub_ID NEQ "">
0
 
PanosAuthor Commented:
Stop looking at.
I did the mistace.I forgot the () in the last code you did post in the other question.
Thank you very much
0
 
PanosAuthor Commented:
Thank you again for your help.
I will be back.
I hope you will help me again
regards
panos
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now