[thelist] More VB Scripting/ADO madness.....

What's wrong here????

Via Query Analyzer
-------------------

SELECT * FROM FeedbackForm Where DateSubmitted > (GetDate()-1)

Returns everything I could want.


Via VB Scriping/ADO
--------------------

strQuery = "SELECT * FROM FeedbackForm Where DateSubmitted > (GetDate()-1)"
objDB_RecordSet.Open strQuery

 if not (objDB_RecordSet.BOF and objDB_RecordSet.EOF) then
    objDB_RecordSet.MoveFirst
    while not objDB_RecordSet.EOF

         ... blah blah ...    
        
        TempVariable = objDB_RecordSet("Comments")

	 ... blah blah ...    

        objDB_RecordSet.MoveNext
    wend    

 ... blah blah ...    

 end if


I don't get the data from the Text Field in the database. TempVariable comes back
"null" or blank - everything else comes back fine. Its gotta be that damn text field
in my SQL Database. What am I forgetting??

-- 
Anthony Baratta