newbie SQL statement help on taskmanager

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

newbie SQL statement help on taskmanager

Author

Message

James

Posted: 02/19/2002, 7:41 AM

This is what I like to see...
In taskmanager, the person who is logged in only be able to see its own tasks and not everyone elses. But the Admin see everyone elses.

Ken Hardwick

Posted: 02/19/2002, 8:12 AM

In the form open event, add something like

if session("userid") <> "admin" then
if sWhere = "" then
sWhere = "Where USERID = " & toSQL(session("userid"),"Text")
else
sWhere = sWhere & " USERID = " & toSQL(session("userid"),"Text")

end if
end if

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login