Strange query of ntext behavior

[Starman9999]

If a query explicitly returns an ntext field, its value is returned. If
however, all fields are returned, the ntext fields don't return anything. Any
idea as to what is going on here? Thanks.

<cfquery name="qGetSchools" datasource="mydatasource">
Select * from guideschools where id=13045
</cfquery>

<cfquery name="qGetSchool2" datasource="mydatasource">
Select faculty from guideschools where id=13045
</cfquery>

<cfoutput>Select * = #qGetSchools.faculty#</cfoutput><br>

<cfoutput>Select faculty = #qGetSchool2.faculty#</cfoutput>

[PaulH]

works for me (assuming you mean sql server).

what ver of cf? if mx, got the updaters? what db driver are you using?

[Starman9999]

Ok, found out the problem. I was using the ODBC SQL driver. Now I've switched to the direct SQL driver. Works like a champ!