Keeping with the theme.... got a problem with QoQ....
I have a column in the 'qQuestData' query that holds the user input from
a Text Area, if I look at it in the dump before it, the text is all
there.
When I look at it after perfuming my grouping (qReport)... the Query of
Queries seems to cut the column data off at around 200 characters if it
happened to hold more than that (all ok if under that)
-------------------------- code --------------------------
<!---- qQuestData is a valid query that can be dumped out! I am
creating it using queryNew, queryAddRow, querySetCell but it dumps out
ok and validates as a query ---->
<cfddump var="qQuestData">
<cfquery name="qReport" dbtype="query">
SELECT
QUESTION_ID, QUESTION_TYPE, QUESTION, ANSWER,
COUNT(ANSWER) AS ANSWER_COUNT
FROM
qQuestData
GROUP BY
QUESTION_ID, QUESTION_TYPE, QUESTION, ANSWER
ORDER BY
QUESTION_ID, ANSWER
</cfquery>
<!--- After the QoQ, all textual colums over a certain length are
truncated --->
<cfddump var="qReport">
---------------------------- end code --------------------------
Any help would be appreciated...
Cheers,
-dc
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
