Expand|Select|Wrap|Line Numbers
- "COUNT(tbl__UserLog._UserLog_ID) AS Count_Logins "
So I recieve :
Syntax error converting the varchar value 'Count_Logins' to a column of data type int.
When the post var gets compared to the AS Count_Logins var (in a Dynamic WHERE clause)....
If I convert the post var to a string - it returns no results?!?!
I have tried unsuccessfully to use CAST to convert the type w/ in the sql statement.
I don't even understand why the heck COUNT(tbl__UserLog._UserLog_ID) AS Count_Logins is not an INT by default!?!?
Any advice is so appreciated as I have researched/experimented now for hours unsuccessfully and need to go home like 1.5 hours ago.
thanks 2 you.