Query with parameters

[anaylor01]

I am trying to run a query with two parameters something like this:
question = SQL1.ExecQuerySingleResult2("SELECT question FROM trivia where ID = ? and category = ?",Array As Object(NewNumber,category))

But I am not having any luck. Any help would be greatly appreciated.

 

[Merlot2309]

Hello,

What happens when you change Array as Object to Array As String?

Helen.

 

[Erel]

But I am not having any luck.

Do you get any error message?