Avatar of Darkejo1

asked on 

Sql Servery Query in .ASP

I have a database called Schedule. Inside that database, I have two tables. One called LogonUser and another called Date. I'm trying to query the LogonUser Table so I can figure out what type of security the logged on user should have. This is what I have so far.

objConn.Open "Driver={SQL Server}; " & "Server=;Database=Schedule;Uid=Intranet; Pwd=Password123;"

StrSQL = "Select [Security] FROM dbo.LogonUser where [LogonUser] like 'MyuserId'"
Set objConn.Execute (StrSQL)

Open in new window

What i have so far works, but what I need is to be able to do something like the following:

Response.write Security

Open in new window

(So I can output the type of security the user should have)

This code is in VBS. Hopefully I was able to describe what i'm trying to accomplish.

VB ScriptASP

Avatar of undefined
Last Comment

8/22/2022 - Mon