SQL Problem

[Will21]

** No Worries sorted it out **

Having some problem passing an integer value into an SQL String,

I have something like this

"SELECT * FROM table WHERE id=IntVarible"

Now this works when i stick in a number like so...

"SELECT * FROM table WHERE id=1"

But get an error with the former

Any suggestions? Thanks

 

[JohnH]

would guess that

"SELECT * FROM table WHERE id=IntVarible"

and

"SELECT * FROM table WHERE id=" & IntVarible.toString()

is not the same thing