Search results for query: *

Hi Dian , What I wanted is in a way to force the submit from within the onChange() method. I'll try with a submit and multiple frames. Thanks.

Hi, I am creating a form using HTML and JSP. I connect to my DB and perform a SQL stmt that retreives , emp_name and emp_id. I then propulate a DDL with emp_name from my resulset above. What I need is that when a value from the DDL changes, I call a new SQL statement , select t.task1 from emp...

Thanks you ! this is exactly what I was after. (fyi contract ids are of string format , I just put integers in my example).

The thing is that i have simplied a huge (to my eyes.) query for the forum. i do fetch the name once for the DSM and once for the acct manager. Why is it not possible to use comma syntax: I don't get any errors but I 'd be more than happy to do it the right way. What i need the query to do...

Right... your answer r937, worked for what was described in my initial question (without the typo!) but... (there is always a but isn't there??): A site can have more than one contract and i only want to get the most recent one. So i need all sites (whether they have a contract or not ), when...

Sorry for the typo!!.. thanks for your help.

I am not too much of a SQL person so it might be really easy for you guys.. I have 3 tables (site s,contracts c and detail d). Not every site has a contract but when a contract exist for a site there also and always exists d.status. I need to list every sites regardless of them having a...