Thanks Doug777, but it did not work. I still do not get any data in the grid. Any Other Suggestions.

The only difference I can see between your code and code I've used is
that I always do all my database interaction stuff before calling
cfform. So the only other suggestion I have if the data returned by the
query is correct, is to move the query so that it comes before cfform. I
don't know why that should make a difference, but it's worth a try.

Another possibility is that some variable you're using is a reserved
word. It wouldn't be a bad idea to change the database column names to
something like AdSite AdDay AdMonth otherwise you tend to get different
tables with same column names which is bad practice and can cause errors.

Other than that you could post the cfdump.

Ok, I got it to work now. I'd just moved the query outside of the form declaration and bam, all the data poulated.

Thanks