My personal point of view ...
It all depends on what you are doing. I don't use dynamic queries now as
often as I did on my last project, but I still do occasionally. One thing
they are nice for is reporting and statistics. Say I have a set of related
of UniqueIDs, Names, Emails, Dates, and Numbers that I am generating
dynamically (not from a query). Sure, there are two easy ways to do this: a
structure (keyed by UniqueID) or a dynamic query. Each has its good points
(+) and bad points (-):
Structure
+ Quick random access to any row
- Hard to sort by any key/column
Query
- No random access
+ Easy to sory by any key/column (CFX_QUERYSORT)
+ Nice built-in CF functions (ValueList(), etc)
I also imagine that a query would be more memory-efficient than a structure
containing the same data, but I don't have any data to back that up.
-Rick
-----Original Message-----
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 12, 2000 9:58 PM
To: [EMAIL PROTECTED]
Subject: Queries as Structures
I see people using Queries to store data, not simply as receptacles of a SQL
command.
How is this different from just using a structure? Why would you want to use
a query this way?
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
