Rich
|
| Posted: 02/28/2002, 7:32 PM |
|
ok... hmm how do i explain this. lets talk ASP.
on a login page say I am coming from a table with these fields
[key][user_name][password][security][cust_code]
So, when they login instead of redirecting them via the security field which is somewhere on this site I want to limit the data that they can search for so a hidden field [cust_code] would be in any of the following forms say I have this table for my search and grid.
[cust_code][in_date][unit_number][cd][size][type]
my search would be [unit_number] <----SEARCH and goto grid
my grid would be
[in_date][unit_number][cd][size][type] *note no [cust_code] which is hidden
Im sure this isnt that hard but i cant get it to work. :) Im new.... but im learning...lol
My next question.... anyone know any good ways to get say the data from above or all for that cust_code on a table to upload to a remote user :)]
Thanks for any help or a point to the right direction.
Rich
richn@xgraphics.com
|
|
|
 |
Nicole
|
| Posted: 03/01/2002, 2:14 AM |
|
Rich,
you should create default WHERE clause for result Grid form. Note, to be able to access grid page user should be already logged in, i.e. page security level should be higher than "0". Sample code:
//get the value of unit_number field for logged in user
u_number = dLookUp("user_table", "unit_number", "cust_code=" & ToSQL(Session("UserID"), "Number"))
//build WHERE caluse
if sWhere = "" then
sWhere = "WHERE unit_number =" & ToSQL(u_number, "Number")
else
sWhere = sWhere & " and unit_number =" & ToSQL(u_number, "Number")
end if
|
|
|
|
Rich
|
| Posted: 03/01/2002, 3:00 PM |
|
thanks Nicole, Ill try it later.
|
|
|
|
|
