Win a copy of Microservices Testing (Live Project) this week in the Spring forum!

natasa jones

Ranch Hand
+ Follow
since Aug 20, 2006
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by natasa jones

i used it,but it keeps bringing results of same category id...
Hi!
i will describe my tables in more detail!
my first table,tableOne lets say a,has rows a.id(primary key),a.product_id,a.year,....
the second table ,tableTwo,b has rows b.product_id(primary_key),b.description.
i want my application,each time,a registered user loggs in,to suggest to him 3 products,according to his preferences.so list in(3,6,5)where 3,6,7 are ids for preferences is an example,and different perhaps for each user.but i dont know how to make it show one product of each category!so three products of different categories.
hmm you are right then!distinct isnt even the correct expression to use!
it doesnt matter which of two! i just want the results to have different ids.after that it could just pick which row with that id it will bring!even better if everytime it picks a different row!!any ideas on how to do that?
well yes it is a simplified version:)no i would like to have 3 results from this query,not one,but its of them i would like to have a different id,(but this id should have a value from the list of three possible values each time)..
Hi all!
i have this query:

select a_id, a.description,a.year from tableOne a,tableTwo b where b.id in (3,6,5) and a.id=b.id limit 3 .

what i get is some rows which all are of the same id.from example are the returned products are of the id 3.but what i really want,is to get three results and each of them should have different id.so the first should have id 3,the second id 6 and the last 5.i want to ask how i can take the rows i want,using distinct for one of them...
something like :

select a_id, a.description,a.year distinct a._id from tableOne a,tableTwo b where b.id in (3,6,5) and a.id=b.id limit 3 doesnt work!

any thoughts?
thanks!
when i use <img src="<%=myMovie.getImagePath();%>" alt="movieImage"/> then i get an error.so i use <img src="<%=myMovie.getImagePath()%>" alt="movieImage"/> but my image doesnt appear...
15 years ago
JSP
hello all!
i am having an application in which after search some results are available and need to be displayed.what i dont know is how i could display an image in my jsp page..i have this code:

and then to display the image i try the following,which doesnt work:)


any thoughts?thanks!
15 years ago
JSP
Hello!
i would like to know what is the correct syntax for a query which takes as parameter a String and then fetches all the rows which have this String or part of the String!
i use String SQL_Movie_Results="select id from myTable where name like '%"+searchTerm+"%'"; inside my fuction,whose signature is

public List searchByName(String searchTerm)throws Exception.

my problem is that i have tried several different approaches in syntax but i could not put the value of searchTerm betweet %%.it always says :
select id from myTable where name like '%null%'".
what is wrong with my query?
please help:)
you are so right!thanks!
15 years ago
JSP
my mistake!it is "LOGGED"in both of them!
15 years ago
JSP
Hi all!
i would like to ask why these lines of code
dont work!
from what have understood,reading a similar question in this forum it should show the username in my jsp page,but it doesnt!not only that but the page doesnt load,as it says that the tile is null,or empty..
in my action i have this line


does anyone see where the problem is?thanks!
[ September 05, 2006: Message edited by: Bear Bibeault ]
15 years ago
JSP
Hi all!
i would like to ask how i could assign the value of
a bean write tag to a String named for example lastName in my jsp page.
something like doesnt work.
any thoughts?
15 years ago
could you please tell me how i could fill in the input fields using html:text?
the form appears but the input text fields dont fill in with the values....any solutions???
thanks in advance!
15 years ago
thank you very much for all the information and the link!
15 years ago