Thanks!
On Monday, April 22, 2013 1:28:08 PM UTC-5, Karl Smith wrote:
>
> 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.
