queries truncates some data?
Queries of queries are not a panacea and are full of flaws.
I think the problem is that in a query, the type of columns is lost, and when a new query
is made on it, some assumptions about the type of columns are made by CF,
probably from the way the first row looks, and not always in the right direction.
For instance, I've seen that, if a column in a first row contains only digits, it is assumed
of numeric type, and any other row containing letters will cause an error.
If a column in the first row is null, it is also assumed a certain type (don't remember which one),
and susequent rows may have problems.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
