Member Avatar for shah_dolly1985 
<%
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 because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by javaAddict
Member Avatar for javaAddict 
<%
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] & "'

?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.