Type mismatch error

[egun]

Error I get:
Type mismatch: 'Output'
Line (25): "Output Query.GetString".

My code:

Code:

valueHID = Datatable.Value("HID_out")
sql = "SELECT rev_id FROM bh INNER JOIN clue ON bh.clue_id = clue.clue_id WHERE h_id = " & valueHID

set Query = dbexample.execute(sql)
Output Query.GetString
msgbox Output

I'm trying to output the value via msgbox that is received from the sql statement above. The rev_id returned is of type Int. Thanks! Would appreciate the help...

[egun]

I also tried to compare Query to another integer, which is not working either.

For instance:
If Query = 380 Then

I'm just trying to get the value that the sql statement returns to use elsewhere. Seems like everything I've tried I get a Type mismatch error. What is the datatype of Query that contains the output of the sql?

[Saket]

I observed that you are missing '=' in the statement where you are getting the error.
I believe, you are taking 'Output' as a variable in which you are trying to get the output of 'Query.GetString'

Try this in your code

Code:

Output = Query.GetString
msgbox Output

[egun]

Thanks, that part is working now. But then I do a comparison and I'm getting a different error now.

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Line (29): "If Query.GetString = "380" Then".

[basanth27]

What is the returned row count of the Query ? or try this,

msgbox Query.EOF ? what does it return ?

[Saket]

check whether any record is there in your recordset or not prior to your statement of comparison. try

Code:

if Query.EOF <> True then

[egun]

The row count should be 2, so maybe this is where the problem is!? How do I handle multiple results?

---

My issue has been fixed, thank you for your help.