Hello, I know probably this is restricted to ASP.Net, but oes anyone know where I can learn more about complex SQL queries? Details: I have 2 tables: Property and Room Room tables have PK: roomId, and FK: propertyId, roomStatus Rooms attributes: roomId, propertyId, maxcapacity, roomStatus(free or booked) Property attributes: propertyId, numOfRooms, .. I want to design a query to be able to check the availability of a property that suports the entered capacity. I have first to check the number of free rooms, then come up with their capacities.. the user enters the desired: capacity, number of rooms. Thank you so much for your help and time. any sources are very welcome regards Imane
imane elfechtani <[EMAIL PROTECTED]> wrote: Thank you friends, that was helpful ;) regards Imane Charles Carroll <[EMAIL PROTECTED]> wrote: http://tinyurl.com/oihw has what you need to know and also clarifies HTTPcontext -- a very important idea in all of this. On Fri, 25 Feb 2005 13:55:41 +0100, Chad <[EMAIL PROTECTED]> wrote: > Imane, > > > I have a question, would anyone explain to me the difference > > between the session variables and Application variables, with > > concret examples? > > An Application variable when set can be read by all sessions running in > that > application scope. Lets say you have a Application Variable that stores the > current temperature. > > Application("Temperature") = "12.5" > > ALL sessions coming to your site will see the SAME value for that > application variable as 12.5 > > A session variable is different in that it can only read the value set for > the single session. So if you set a session variable to some value, ONLY > that session can read it, no other sessions can see the value you set for > this session. > > Example: > Let's say you generate a unique number for every visitor that comes to your > site. You could then put that number in a session variable like this: > > Visitor A comes to the site > Session("MySessionVariable") = 1234 > > Visitor B comes to the site > Session("MySessionVariable") = 6789 > > Visitor A and B have both access to the SAME Session variable > "MySessionVariable" but the contents of the variable is different for each. > > Hope that helps. > > --Chad > > > > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Sports - Sign up for Fantasy Baseball. [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Mail - You care about security. So do we. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
