I am feeling stupid, I have the following <cfquery> in my page, but it is showing up blank. I don't think that there is anything wrong here, or at least I am not seeing it. Why would the page be blank, instead of showing the table of users in the database?

<cfquery name = "members" datasource = "cfhawaiiDBmain">         SELECT user_id,first_name,last_name, joining_date
    FROM users
    ORDER BY user_id
</cfquery>

<table>
    <cfoutput query="members">
        <tr>
            <td>#members.first_name#</td>
            <td>#members.last_name#</td>
            <td>#members.date#</td>
        </tr>
    </cfoutput>
</table>

could be a silent error you're not seeing. i see you have joining_date in the sql but members.date in the cfm.

thanks, I didn't see that. I made the change to

<td>#members.joining_date#</td>

but the page is still blank. Thanks so much for your help.

try putting a

<cfdump var="#members#">

to make sure you have records.

good idea about te cfdump, I will try this. I know there is one record in the database. The view source is completely blank.

I don't quite understand why having a 0-date in the DB would cause no error / no output..? Did you check the logs to see if there was anything being logged, even if not to screen?

not that it matters, but your datasource should be wrapped in pounds for cross-compatibility. second unless you only want the very first record to dump from your database, that should be in a cfloop, such as<cfloop query = "members"><td>#members.firstname#</td> </cfloop></tr></table>