Problem displaying record-set

Hi all,
I am having trouble getting a record-set to display on a web page.
I have checked: The SQL statements in "expression builder".  The SQL Test environment - This is where I found  a number of SQL statements are NOT retuning a value..the statements are constructed correctly however, only two of these "Get" statements are returning data.
Now this is where it gets a little confusing, as the page is being constructed, The attributes dropped on tne table ARE returning the correct values!
I am really scratching my head over this, what is happening?? I have serched the documentation for clues - No luck.
Your welcome to see this page at
Any help is very much appreciated.
Thanks in advance,