0
<%
String user=request.getParameter("LedgerName");
ResultSet rs=st.executeQuery("SELECT RoomMasterID,RoomNo FROM RoomMaster AS RM, LedgerMaster AS LM WHERE RM.LedgerID = LM.LedgerID AND LedgerName = '" & Me.datRoomType.SelectedItem.Text & "' AND  RM.Status <> 'NO' AND RoomMasterID NOT IN (SELECT DISTINCT RoomMasterID FROM BookingMaster WHERE ' " & Me.datarrivaldate.AmericanDate & " 'BETWEEN FromDate AND ToDate) AND RoomMasterID NOT IN (SELECT  DISTINCT RoomMasterID FROM BookingMaster WHERE ' " & Me.datdeparturedate.AmericanDate & " ' BETWEEN  FromDate AND ToDate)");

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by javaAddict
0
<%
String user=request.getParameter("LedgerName");
ResultSet rs=st.executeQuery("SELECT RoomMasterID,RoomNo FROM RoomMaster AS RM, LedgerMaster AS LM WHERE RM.LedgerID = LM.LedgerID AND LedgerName = '" & Me.datRoomType.SelectedItem.Text & "' AND  RM.Status <> 'NO' AND RoomMasterID NOT IN (SELECT DISTINCT RoomMasterID FROM BookingMaster WHERE ' " & Me.datarrivaldate.AmericanDate & " 'BETWEEN FromDate AND ToDate) AND RoomMasterID NOT IN (SELECT  DISTINCT RoomMasterID FROM BookingMaster WHERE ' " & Me.datdeparturedate.AmericanDate & " ' BETWEEN  FromDate AND ToDate)");

Is this javascript or java:

AND LedgerName = '" & [B]Me.datRoomType.SelectedItem.Text[/B] & "'

?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.