forcing string datatype in query of queries

[mocax]

In a query, I have a column of varchar type and the strings consist of numbers
in the form "00000099999"
When I do a query of queries on the result, the column becomes "99999" with
the leading zeroes truncated.

Is there a way to force it to display the correct datatype?

[Iceborer]

Will it work if you use CAST to a varchar in the QofQ?

[mocax]

cast() and convert() don't work in QofQs.....
At least in MX6.1
No idea about MX7

[vkunirs]

Hi

Is this problem is with the query of queries only?

actually i have tried with a single query and it is displayintg the value as
it is in the database onyl.

<cfquery datasource="test" name="s">
select * from test1
</cfquery>
<cfoutput query="s">
#test#
</cfoutput>

this dispaying the value as : 00009999

[jonwrob]

The only solution to this I've been able to come up with is to create the query
with QueryNew and then add a row with default values of the correct type.
After adding the rest of the data, you can delete first row.

It's sloppy I know, but it's all my brain, with it's limited capacity for
parallel thinking has managed to provide me. If anyone has a better idea, I'd
love to hear it.

JR

[eastinq]

In your query of query, you can try tricking it into thinking it is a string by concatenating an empty string value.

SELECT COL1 + '' AS COL1