472,127 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.


SQL Value:
Expand|Select|Wrap|Line Numbers
  1. "COUNT(tbl__UserLog._UserLog_ID) AS Count_Logins "
Returns as varchar which is killing me, because my user interaction is loaded w/ sort features. Unfortunately the count_logins var getting posted to the script is an integer.
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.
Nov 10 '06 #1
0 1394

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Jozef de Veuster | last post: by
30 posts views Thread by junky_fellow | last post: by
5 posts views Thread by lancer6238 | last post: by
5 posts views Thread by Edwin | last post: by
5 posts views Thread by Edwin | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.