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...

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:
<% List searchResultsList = (List) request.getSession().getAttribute("ResultList");%> <% Result myResult = (Result) searchResultsList.get(0);%>
and then to display the image i try the following,which doesnt work:)
<img src="<%myObject.getImagePath();%>" alt="movieImage"/>

any thoughts?thanks!

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!

my mistake!it is "LOGGED"in both of them!

Hi all!
i would like to ask why these lines of code
<% User user=(User)request.getAttribute("LOGGED");%> <%=user.getUserName()%> 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
request.getSession().setAttribute(ActionHelper.LOGGED_USER_BEAN, user);

does anyone see where the problem is?thanks!
[ September 05, 2006: Message edited by: Bear Bibeault ]

i think this link is the answer to what you need..
http://www.w3schools.com/js/tryit.asp?filename=try_dom_select_multiple

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 <% String lastName=> <bean:write name="myUser" property="lastname"></bean:write> <%; %> doesnt work.
any thoughts?

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!

thank you very much for all the information and the link!