Is it possible to have a select statement for different user roles?
Currently Individuals can log on and view a report but when the Corporate
Entity logs in they can't see anything. Here is an example of what I want
to do but it doesn't seem to be working so I thought maybe I could ask
someone who has a been to this rodeo before! Please if I am doing some
wrong or out of the ordinary let me know as this is a learning experience
for me!
Dim ThisRole As String = Session.Contents("AccessType")
If ThisRole <> "CORP" Then
strSQL = "SELECT * FROM eIndLic WHERE (UID =" & Session("UID") &
") AND (RegionCode =" & CLIENTID & ") AND (Status IN ('R', 'RR','N','NN'))
AND (ServiceType = 'R') ORDER BY State"
Else
strSQL = "SELECT * FROM eIndLic WHERE (RegionCode =" & CLIENTID &
") AND (Status IN ('R', 'RR','N','NN')) AND (ServiceType = 'R') ORDER BY
State"
--
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
---
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
