Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 05-06-2009
Member
 
Join Date: May 2009
Posts: 15
reservation form help

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;
Reply With Quote
  #2  
Old 05-06-2009
Member
 
Join Date: May 2009
Posts: 15
re: reservation form help

could please help me

i need to finish my project
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: Feb 2009
Posts: 96
re: reservation form help

you need to state what language your doing in and program your using ect... what you wrote looks like many different languages..
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 15
re: reservation form help

i am using PL/SQL language ..
Reply With Quote
  #5  
Old 06-06-2009
Member
 
Join Date: Mar 2008
Posts: 227
Re: reservation form help

Hi CS,

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

Code:
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.
Reply With Quote
  #6  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 15
Re: reservation form help

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
Reply With Quote
  #7  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 15
Re: reservation form help

HELP
Reply With Quote
  #8  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 15
Re: reservation form help

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

cause your code work in SQL server only ..
Reply With Quote
  #9  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 15
Re: reservation form help

UP UP UP UP UP
Reply With Quote
  #10  
Old 07-06-2009
Member
 
Join Date: May 2009
Posts: 15
Re: reservation form help

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

Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "reservation form help"
Thread Thread Starter Forum Replies Last Post
Google Chrome is opening in basic HTML form instead of the Standard form Beatrix Technology & Internet 5 25-05-2011 10:21 PM
how to get items in a form to auto-resize with the form using visual basic deansmylie93 Software Development 2 02-05-2011 07:06 AM
What is CozyRestaurant Reservation for Workgroup Abbie Windows Software 5 30-01-2010 01:33 AM
Problem reloading MDI child form in main form. AFFAN Software Development 3 30-01-2009 09:05 PM
Activating IP Address Reservation sevaanan Small Business Server 3 21-04-2007 02:58 PM


All times are GMT +5.5. The time now is 03:15 PM.