function in DW recordset

[samkry]

Hi..
DW recordset comes with all of these functions, when and how we should use
them?
url_parameter,form_variable,cookie,session variable,application
variable,entered value and lastly request variable.
so far I only familiar with URL_parameter,form variable and session variable..
how about the rest.. can someone explain on me?

[nisav19]

entered value is a static value that you enter directly into the SQL statement.
ususally you have a user submit a form or click a link..get a value from them
and execute a sql statment, with an entered value you dont have to ask the user
for any input, the value is part or the sql statement so you can execute that
sql statement on any page without having to get input from the user. ex. you
want to display # of members who joined before 2005...so the value of 2005
would be the entered value.

cookie you would use if you are saving info on the customers pcs, its
basically the same as using a url parameter, hidden form value or session
variable, but it doesnt get erased when the browser is closed. if only gets
erased if they delete the cookie by using disk cleanup, or a cookie cleaner
software or somethign else. usually you would use cookies if you are tracking
customers web site usage, if you have a login page and they selected remember
my username..

application variables is info that is stored on the server itself that can be
reused by everyone that visits the site, its not specific for any one user. so
the info that you retreive and display for one user is the same as for the next
user. on the modifications that one user does to that info can be seen by the
next because its stored on the server and is not deleted.

also check dreamweaver's help files, they have info on all these items, and
then lead into examples.