reservation form help

[csGIRL]

Hi,,

i had a reservation form .. that had two text box for form_date & to_date..

when the employee enter those dates i want to save them in a var .. then go to a table in mysql .. name Booked .. to check which room will not be booked in those dates ..
and the show them in a list box so the employee can choose one of them ..

i had do the code but i don't know how to complate it .. so i need your help please ..

This is the code:

declare
room_no booked.RNO%type;
from_d booked.from_date%type;
to_d booked.to_date%type;

begin
select RNO, from_date, to_date into room_no, from_d, to_d from booked
where booked.from_date <> :from_date AND booked.to_date <> :to_date;

--- need to put a statment to retreve values in a list to chose one of them --
end;

[csGIRL]

could please help me

i need to finish my project

[Daren]

you need to state what language your doing in and program your using ect... what you wrote looks like many different languages..

[csGIRL]

i am using PL/SQL language ..

[DllD]

Hi CS,

You do not need to worry about your problem whenever I am their to help you.

DECLARE
  bonus    NUMBER(6,2);
  empid    NUMBER(6) := 120;
  hiredate DATE;
BEGIN
-- retrieve the date that employee was hired, the date is checked
-- to determine the amount of the bonus for the employee
  SELECT hire_date INTO hiredate FROM employees WHERE employee_id = empid;
  IF hiredate > TO_DATE('01-JAN-98') THEN
      bonus := 500;
   ELSIF hiredate > TO_DATE('01-JAN-96') THEN
      bonus := 1000;
   ELSE
      bonus := 1500;
   END IF;
   DBMS_OUTPUT.PUT_LINE('Bonus for employee: ' || empid || ' is: ' || bonus );
END;

use like this programming logic for your date requirement.

[csGIRL]

bro. DIID .. thanx alot

i understand your code but i want the output to be in a list or in a window that the user can saw it then choose one of them to put in a text box ..

i had tried to read about LOV .. but i don't understand it very will so i can't wrote it in my program

i feel realy sick

[csGIRL]

HELP

[csGIRL]

i had wrote this code in a button in oracle 10g form ..

cause your code work in SQL server only ..

[csGIRL]

UP UP UP UP UP

[csGIRL]

I realy realy need your help..

the submition is on monday ..

and i still have this problem .. and another one that i am trying to solve it ..

please please give me a key soulotion ..