(missing operator) in query expression

AARRGG!!! Help! Please! I'm at my wit's end...

strRaceID = Request.QueryString("RaceID")
'Plus a check that sets strRaceID = 0 if it's blank / null / non-numeric

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

strSQL = "SELECT tblResultHeaders.* FROM tblResultHeaders WHERE tblResultHeaders.Date_ID = " & strYearID & " ORDER BY tblResultHeaders.Race_ID ASC;"

rsResultHeaders.Open strSQL, strCon

Do While NOT rsResultHeaders.EOF

If rsResultHeaders("Race_ID") = strRaceID Then

'(amongst other variables set)
lngHeaderID = rsResultHeaders("HeaderID")

rsResultHeaders.MoveNext
Loop

'Then later on...

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

strSQL = "SELECT tblResults.* FROM tblResults WHERE tblResults.HeaderID = " & lngHeaderID & " ORDER BY tblResults.Position ASC;"

rsResults.Open strSQL, strCon

Result?

I have set up response.write statements that indicate that, at least once in the run through the recordset there's a match, for example:
TEST rsResultHeaders("Race_ID") = 0
TEST strRaceID = 0

However, lngHeaderID is never set (indicating the IF statement ignores the match), so I get:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tblResults.HeaderID ='.

Doesn't seem to matter whether xxxRaceID is str, lng or int, likewise with xxxHeaderID.

Please, someone point out my stupid mistake before the monitor matches the Wright brothers for air time...

have you simply tried

strSQL = "SELECT tblResults.* FROM tblResults WHERE tblResults.HeaderID = " & lngHeaderID & " ORDER BY tblResults.Position ASC;"

Response.Write strDQL
Response.End

rsResults.Open strSQL, strCon

too make sure your logic works? becuase the error doesn't lie, it IS missing an operator (read: problem with SQL statement)

Thanks for this - I hadn't tried the R.W strSQL, but adding it gives:

SELECT tblResults.* FROM tblResults WHERE tblResults.HeaderID = ORDER BY tblResults.Position ASC;

i.e., the part where the lngHeaderID number should be is blank (which corresponds to the variable never being set).

This ties in with the fact that R.W'ing the lngHeaderID gives a big fat blank, because it's never assigned a value; again, I'm guessing because the IF statement never picks up the match - within that IF statement I've set a R.W statement to write "I've found a match" when it does.

It never does, unless I put in the "0" as per above.

Thanks for the function above though, I'll try that as well.