> WHERE whateverid = <cfqueryparam
What is the value of #url.id#? I had no problems with either
> The weird thing is cf_sql_int is not even listed as
IIRC, when you pass in an invalid sql type CF just uses the
default: cf_sql_char, which accepts just about anything. MS SQL
probably does an implicit convert() to the right type and that is
why it works.
Yes, bigint can handle 64 bit and integer 32 bit. I had no
problems with either using CF8 and the built in driver. Assuming
your setup is the same, my guess would be the value as the most
likely cause of the problem.