Wierd query of query issue

[Paul Vernon]

I've just discovered that one of my query of query functions is truncating a
particular field in a query and I was wondering if anyone had come across
this behaviour before....


I'm running CF5 on W2k SP4.


    <cfquery name="ReOrder" datasource="#renamedtoprotecttheinnocent#">
        SELECT *
        FROM IMAPServer
    </cfquery>


    <cfoutput query="IMAPServerQuery">
    #notaffectedcolumn#<br>
    #MyColumn#<br>    <!--- everything is present and correct --->
    </cfoutput>


    <cfquery dbtype="query" name="ReOrder">
        SELECT *
        FROM IMAPServerQuery
        ORDER BY internaldate DESC
    </cfquery>


    <cfoutput query="ReOrder">
    #notaffectedcolumn#<br>
    #MyColumn#<br> <!--- this is truncated at 39 characters every time...
    </cfoutput>

TIA


Paul

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---