I have a question....

[Elahe Shafie]

Hi Friends,
I try to find in all bugs description and get the list of bugs that "for" word is on it butI guess my query is not correct.
Could you help me on this?
Many thanks,
Elahe

select
  s.text,
  b.bugNumber,
  b.bdesc,
  b.submittedDate,
  u.name 
from 
  bug b, 
  user u, 
  statusDesc s 
where 
  b.ID=s.ID 
  and b.userId=u.userId
  and b.bdesc = 'for' 

wrapped long query line
[ July 13, 2002: Message edited by: Frank Carver ]

[Frank Carver]

Your query will only return records with the exact description 'for', and I guess there aren't many of those. Try something like:

...
where
  b.ID=s.ID
  and b.userId=u.userId
  and upper(b.bdesc) like '%FOR%' 

[Elahe Shafie]

Thanks a lot Frank

[Elahe Shafie]

Hi friends,
In my query, I like to simulate my where condition part based on what I have:
upper(bdesc) like '%for%'

strWhere = "upper(b.bdesc)like'"+"%"+Desc +"%""'";

But there is some thing wrong in puting double code or single code... could you please help me how can I do it?
Eventually my query would be like:

  "select s.text,b.bdesc,b.fixedDate,b.contact,u.name from bug b, user u, statusDesc s where b.ID=s.ID and "
+ "b.userId=u.userId and " + strWhere + " order by "+ strOrder);

Many thnaks,
Elahe
[ Edited by Dave to reduce the length of the line ]
[ July 16, 2002: Message edited by: David O'Meara ]

[David O'Meara]

I'm not sure if this is your problem, but you are missing spaces

strWhere = "upper(b.bdesc) like '"+"%"+Desc +"%""'";

Dave

[s basetti]

i guess u made the query bit complex..
select s.text,b.bdesc,
b.fixedDate,
b.contact,
u.name
from bug b,
user u,
statusDesc s
where b.ID=s.ID
and b.userId=u.userId
and " + strWhere + " //strWhere = "upper(b.bdesc)like'"+%Desc%"+"'";
order by "+ strOrder);
..may be space problem..

[Elahe Shafie]

Dear Friends,
Yes the problem was space and something else that still I couldn't figure out so I break it in two lines to make sure it is working:
strX = "%"+ strX + "%";
strWhere = "upper(b.bdesc) like'"+strX+"'";
Can you please help me to make it just one line? since I don't want to have two lines...I really have no idea how can I make it one line...
Thanks a lot,
Elahe

[Jamie Robertson]

Originally posted by elahe shafie:
Dear Friends,
Yes the problem was space and something else that still I couldn't figure out so I break it in two lines to make sure it is working:
strX = "%"+ strX + "%";
strWhere = "upper(b.bdesc) like'"+strX+"'";
Can you please help me to make it just one line? since I don't want to have two lines...I really have no idea how can I make it one line...
Thanks a lot,
Elahe

how about:

strWhere = " upper(b.bdesc) like '%" + strX.toUpperCase() + "%' ";

you should probably escape illegal characters in your string like single quotes. I threw in the String.upperCase() function on your compare string just in case you forgot to do it earlier. I also added spaces so that you don't run into spacing problems when you concatenate the String to your query( you can always have more than one but need at least one before the string and one after ).
Jamie

[Elahe Shafie]

Jamie you are great like always. It works!!!
Thaaaaaaaaaaaanks
Elahe