Found my problem. I was passing 4 params. I found an article on Parameter Sniffers in 2005 SQL. Once I added another set or params with an existing value it all worked great.


@param1 int,...

looking in your db i noticed that you do not have any orders in February. This will be one reason why you cant pull anything from the first query. change the date to 6/2/2008 and BAM its full of data...

My pleasure. Ill keep trying to break it for ya lol :)

you are pulling from all rows in the db. your variable will only display the last rows info. but yes that should work for using that var later in the page.

i will volunteer for testing

Your welcome. Glad I could help.

you can get an idea how this works if you look at this article http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=3992&LinkFile=page1.htm
on page 3 it talks about doing this with php/mysql.