Solved

Using 'IN' operator in ColdFusion Query of Queries throwing error

Posted on 2009-07-15
4
597 Views
Last Modified: 2013-12-24
Hi,
I have the following query which is throwing an error:

<cfquery dbtype="query" name="getAtt">
select *, upper(lname) as ulname, upper(fname) as ufname from getAttendees
where breakout_id = '#trim(url.ids)#'
and id_register_status IN (1,3)
and id_rate_type NOT IN (1,2)   (this is the line that's breaking it.. causing error)
order by date_signup
</cfquery>

The datatype for id_rate_type is VCHARAR2 - Oracle DB.

Here's the error message:

Query Of Queries runtime error.  
Comparison exception while executing IN.
Unsupported Type Comparison Exception: The IN operator does not support comparison between the following types:
Left hand side expression type = "STRING".
Right hand side expression type = "LONG".


Any help resolving this will be greatly greatly appreciated.
Thank you  ~ Wendi
0
Comment
Question by:wkolasa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 500 total points
ID: 24862292
as the error says, you can't compare a string and an int

but this should work

and id_rate_type NOT IN ('1','2')

0
 

Author Comment

by:wkolasa
ID: 24862474
Thank you Fishes...  I tried  NOT IN ("1","2")   didn't work... tried  NOT IN ('1','2') and it did work.  What's the difference?   ((by the way, thank you for your answer.  and thank you for pointing out the obviousness too (funny))
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 24862715
afaik QoQ's need '

it may be they were copying t-sql which uses ' (not sure about oracle)
maybe it looks at (" as the start of a list
maybe CF  just doesn't -like- "

not really sure
0
 

Author Closing Comment

by:wkolasa
ID: 31603843
thank!  youre aces!
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question