Type mismatch: 'CLng' Error

[theflyingminst]

Hi I am using Classic ASP and Access. I keep getting this error:

Type mismatch: 'CLng'

Is my SQL statement syntax incorrect?

strSQL = "SELECT * FROM Table WHERE id = " & CLng(string)


Thank you

[Kuriyama]

SQL is correct it's the ASP/VBScript that is crashing

CLng will crash if you pass it a blank/null/non-numeric value. Also, I believe it will crash if you try to pass in a number exceeds CLngs number range.

[theflyingminst]

Ok. Thanks for clearing that up, that really helps alot!!