I have a query that queries a SQL 2000 database. If I put the "date" value that I want to query on in the query it works as planned. If I set the "date" to a session variable that has previously had the same date put in it I only get 8 records. As you can guess I have more than 8 records in it. It doesn't matter what date I put into the session variable I always get 8 records displayed in the page. Once again if I hard code the date into the SQL statement it works fine.
Any Ideas?

Are the 8 records random or are they all from the same date? Chances are there is a data type problem. -- Like it reading the session date value as a string !?!

You could also change the session value to the date data type using cDate: www.devguru.com/Technologies/vbscript/quickref/cdate.html

All 8 records are from the same date. I will check the data type.
Thanks!!

I set the data type using cDate and it had no effect on the results of the query. Now I'm really confused.

can you show your SQl statement here?

Here is what I have:

SELECT ID, pickupdate, total_product, grand_total, verified, check_numb, form_of_payment
FROM dbo.total_purchases
WHERE pickupdate = 'dateselect'
ORDER BY ID ASC

Here is my session variable:
dateselect = Session("datelist"

This code will print out the SQL statement. Whenever I have problems like you're having, I print the sql then paste it into Query Analyser to test it. This helps me debug my problem.

<pre id=code><font face=courier size=2 id=code> ' set the session to a default value to prevent an error in the SQL
if (Session("datelist" = "" then
Session("datelist" = "01/01/1900"
end if

Dim dateselect
dateselect = Session("datelist"

' Build SQL statement
Dim SQL
SQL = "SELECT ID, pickupdate, total_product, grand_total, verified, check_numb, form_of_payment"
SQL = SQL & " FROM dbo.total_purchases"
SQL = SQL & " WHERE pickupdate = '" & dateselect & "'"
SQL = SQL & " ORDER BY ID ASC"


' print SQL statement for testing
response.Write(SQL)</font id=code></pre id=code>