The problem as described in the original message no longer exists.... Must
be a CF5 issue only... ho hum.
Paul
_____
From: Paul Vernon
Sent: Wednesday, 10 March 2004 11:50
To: CF-Talk
Subject: Wierd query of query issue
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]
