I dont succed to call to a table from the DB!

[karelor]

What is wrong here?

it shows:

Microsoft VBScript (0x800A03EE)
')'

set msgs = oConn.Execute("Select * From msgs where read='"no"' and touser='" & Session("username") & "' ")
 

And can I execute twice?

cuz i also have the line:

set details = oConn.Execute("Select * From personal_D where username='" & Session("username") & "'" )
 

Do i have to open the DB again?

Thanks!!

[Arnold Schuur]

Remove the double quotes (") around "no"