User Profile

Collapse

Profile Sidebar

Collapse
simba
simba
Last Activity: May 23 '07, 01:29 PM
Joined: Jan 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • simba
    started a topic How to execute more than one database query in a JSP page
    in Oracle

    How to execute more than one database query in a JSP page

    Hello,

    I am having trouble executing more than one database query in a JSP page.
    The first query executes fine but it seems to skip by the second one. Any ideas why?

    Thanks
    See more | Go to post
    • simba
      started a topic JSP problems
      in Java

      JSP problems

      Hi I'm having problems displaying information that I am retrieving from a database through an sql query.

      My jsp code is as follows:

      <%@ page language="java" contentType="te xt/html" errorPage="erro rpage.jsp" import="java.sq l.*, java.util.*" %>
      <jsp:useBean id="connect" class="myBeans. HostelConnectBe an" />
      <jsp:setPropert y name="connect"...
      See more | Go to post
      • simba
        started a topic Online booking system problem
        in Oracle

        Online booking system problem

        Hello,

        I am currently doing a project which requires me to develop an online booking system for hotels and integrate both bed and room booking. I have the room booking working but I cant seem to get the bed booking working. I have dorm rooms with 8 beds in them and I would like to have a query(or something) which allows me to make the dorm rooms bed booked instead of room booked. Anyone any ideas on how to make this happen, anything...
        See more | Go to post
        • simba
          started a topic Help with connecting JSP to Oracle
          in Oracle

          Help with connecting JSP to Oracle

          Hi, I have been trying to connect my JSP file to my Oracle database but the server does not seem to like it and won't connect, I have the following code:

          <%@ page language="java" contentType="te xt/html" errorPage="erro rpage.jsp" import="java.sq l.*" %>

          <html><head><ti tle>Login</title></head>
          <body>
          <% //1. load the SQL JDBC...
          See more | Go to post
          • simba
            replied to Help with displaying information not booked on a certain date.
            in SQL Server
            Yeah I mean reservations. Your completely right tho I dont know what I was thinking wanting to delete them! My head was all confused and I was thinking that I had to delete them so that they didnt mess with my query that shows the availability of rooms on certain dates but it will make no difference because once the check out date has passed it will be in-line with the real date i.e. todays date, which people cannot book prior to todays date anyway!...
            See more | Go to post

              Leave a comment:

            • simba
              replied to Help with displaying information not booked on a certain date.
              in SQL Server
              Thats excellent, worked a treat! thanks! I have one other wee question...I dont suppose you have any idea how to automatically delete an entry from a table once its todate has expired i.e. the date on which people will be checking out of their hotel?

              Thanks again!
              See more | Go to post

                Leave a comment:

              • simba
                replied to Help with displaying information not booked on a certain date.
                in SQL Server
                That doesn't work either sorry. My reservation table contains bookings that have been made but i'm trying to search for rooms that are available and not on the dates that the rooms are booked up on.
                See more | Go to post

                  Leave a comment:

                • simba
                  replied to Help with displaying information not booked on a certain date.
                  in SQL Server
                  No that doesn't work because it just returns reservations that have been made rather than available rooms.

                  Thanks though!
                  See more | Go to post

                    Leave a comment:

                  • simba
                    started a topic Help with displaying information not booked on a certain date.
                    in SQL Server

                    Help with displaying information not booked on a certain date.

                    Hi,

                    I am doing an online booking project and was wondering if anyone has any ideas on how I can display rooms that are not booked on a certain date. The query that I have that displays all rooms that are not booked is:

                    SELECT rooms.roomid, rooms.rtype
                    FROM rooms
                    LEFT JOIN reservation
                    ON rooms.roomid = reservation.roo mid
                    WHERE rooms.hostelid = 6
                    AND (((reservation. roomid) Is Null));...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...