This topic is locked
[SOLVED]

 Simple database connection

8/30/2017 4:12:58 AM
ASPRunnerPro General questions
F
Frank Erik author

I've had success doing this in version 7, but so far cost a lot of time in ver.9
The task is pritty simple, after suksessful login I want to add the value of a database field to a session-variable.
The field "Consern" defined in the same SQL tabel as user/password.

Do I need to open a recordset (this is what i've done in simular applications) - or kan I use a ASPRunner-function?
Anyway, here is the code I'm trying with no success.
Dim strSQL

strSQL = "select Consern from dbo.RingSept where username = 1234;"
Dim rstDBEdit

Set rstDBEdit = Server.CreateObject("ADODB.Recordset")

rstDBEdit.Open strSQL, Conn,1,2

consern = rstDBEdit.fields("consern")

rstDBEdit.Close