Strange Issue with ASP displaying records

[J P Singh]

We have a small application to track holidays of our employees.

strUserId = session("UserId")
strSQL = "SELECT * From holidayrequests where UserId="& strUserId &
" ORDER by Status"

I run the above query which for most part returns the results fine but
occassionally it omits records. i check in the database and these records
are present and when I view the details of the same user through the admin
section of the script all the records are returned.

It only happens with just one user.

Has anyone seen this happen? Any Ideas how to resolve this.

Regards

 

[Evertjan.]

J P Singh wrote on 23 feb 2004 in
microsoft.public.inetserver.asp.general:

strSQL = "SELECT * From holidayrequests where UserId="&
strUserId & " ORDER by Status"

"... WHERE UserId = '" & strUserId & "' ORDER by Status"

A litteral string needs to be quoted in SQL.

 

[Bob Barrows [MVP]]

We have a small application to track holidays of our employees.

strUserId = session("UserId")
strSQL = "SELECT * From holidayrequests where UserId="&

Evertjan is assuming that UserID is a character field. If it's numeric, then
quoting the search criterion will result in a type mismatch.

I think you need to use some basic debugging and "response.write strsql" so
we can see the actual statement that is resulting in the faulty results.

Bob Barrows

PS. Please read this: http://www.aspfaq.com/show.asp?id=2096

 

[Evertjan.]

Bob Barrows [MVP] wrote on 23 feb 2004 in
microsoft.public.inetserver.asp.general:

Evertjan is assuming that UserID is a character field. If it's
numeric, then quoting the search criterion will result in a type
mismatch.

Right, Bob, not quite bright of me.