I've just got my hands on a new W2k3 server and installed the MX6.1 trial.
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]
- Single quotes, CF5, and MS Access Thane Sherrington
- Re: Single quotes, CF5, and MS Access Charlie Griefer
- RE: Single quotes, CF5, and MS Access Ian Skinner
- RE: Single quotes, CF5, and MS Access Thane Sherrington
- RE: Single quotes, CF5, and MS Access Ian Skinner
- RE: Single quotes, CF5, and MS Access - resolve... Thane Sherrington
- Wierd query of query issue Paul Vernon
- Paul Vernon