garevn Posted November 7, 2011 Share Posted November 7, 2011 my data page look like this atm and its fine.Now i need a way to saying: //if values t+c+r selected run this querysql_cmd.CommandText = "SELECT dbo.rooms.id, type, image, price, details FROM dbo.rooms,dbo.transactions WHERE dbo.rooms.id=dbo.transactions.roomid and type='" & request.querystring("t") & "' and '" & request.querystring("c") & "' not between checkin and checkout and '" & request.querystring("r") & "' not between checkin and checkout and status='active' "//else display message: complete all information Link to comment Share on other sites More sharing options...
justsomeguy Posted November 7, 2011 Share Posted November 7, 2011 What does it mean if a value is selected? That the variable is not empty? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.