Solved

a strange problem

Posted on 2006-07-21
6
181 Views
Last Modified: 2008-02-26
hi all,

i have a very strange problem. i have query like this

select
a.id as queue_id, b.*, c.text
from xxx a left join yyy b on (a.SMS_ID = b.id)
left join zzz c on (c.content_id = b.content_id)
where
is_send = 'N' and
day in (-1, to_number(to_char(SYSDATE, 'D'))) and
(minute = -1 or
minute  <= to_number(to_char(sysdate, 'HH24')) * 60 + to_number(to_char(sysdate, 'MI')))
and
c.text is not null and
(b.last_sent_sms is null or b.last_sent_sms != c.text) and
(c.content_date is null or (to_char(sysdate, 'yyyy/mm/dd') = to_char(c.content_date, 'yyyy/mm/dd')))
and (
b.comparison_operator is null or
(b.comparison_operator = '=' and b.comparison_value = c.price) or
(b.comparison_operator = '>' and b.comparison_value > c.price) or
(b.comparison_operator = '<' and b.comparison_value < c.price)
)

when i run this from toad it works fine and return 2 row but when i want to run in my java project it work very strangely and return only 1 work.

i couldnt understand anything why it behaves like that. it problem cause of java.

if you help me, i will be pleased.
thanks in advance.
0
Comment
Question by:komputer
  • 2
  • 2
6 Comments
 
LVL 2

Expert Comment

by:RoyalNepal
ID: 17155378
Try to use brackets..after "Where" clause and after two "and".
0
 

Author Comment

by:komputer
ID: 17166200
i' ve just realised the problem cause of to_number(to_char(SYSDATE, 'D')) to return the day of week. it changes depend on the regional settings. for american it returns 2 for monday while returns 1 for UK.

is there any function that runs independent of regional settings to return the week of day in oracle.

or any solution to be independent of regional settings to calculate the week of day.

thanks...
0
 
LVL 6

Accepted Solution

by:
valipotor earned 125 total points
ID: 17276953
Hi
I think this solves your problem
http://www.experts-exchange.com/Databases/Oracle/Q_21460136.html

valipotor
0
 
LVL 2

Expert Comment

by:RoyalNepal
ID: 17280427
Is your problem solved? Please let me know.
0
 

Author Comment

by:komputer
ID: 17496375
earthman2's solution seems work.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now