ASP session and Query Problem

[asifqua]

Deer All
i m working on a project. i m facing two problems.
1) i want to select rendom records from the table. plz send me the sql query for selecting rendom records.

2) i have different session variables.if a user access the ASP page then i m storing some values in these variables.but it is working only for a user. if multipal users accessing the same page then it is working only for a user.

it displays these value only for a user and other users cant see these values.

any help will be appricated.

Asif Hameed

[Bullschmidt]

<<
1) i want to select rendom records from the table. plz send me the sql query for selecting rendom records.
>>

Generating Random Records from the Database
http://www.stardeveloper.com/asp_rndrec_1.asp

How do I return a random record from Access or SQL Server
http://www.adopenstatic.com/faq/RandomRecord.asp

<<
2) i have different session variables.if a user access the ASP page then i m storing some values in these variables.but it is working only for a user. if multipal users accessing the same page then it is working only for a user.
>>

That's how session variables are supposed to work. Sounds like you want to be using applicaiton variables:
Application("MyVariableName") = "Whatever"