You are probly puting your SQL string together with ' ' around the variable.
get rid of the single quotes and you should be fine.

For Example:
strQuery = "SELECT * FROM SomeTable WHERE TableIndex = " & intRecordIndx
& ";"

This should take care of the problem that you are running into.

James

>Re: hi, i have an access database which generates auto numbers >which is
of long integer type. i want to pass this vlaue from >one asp page to another
asp page, but it is passes only as a >string . i tried referencing the table
by converting it back >using clng and cint functions but i still get the
data mismatch >errors. pls help me to convert string to long integer.thanks
>"prakash" <qlop@hotmail.com> wrote:
>
>