I have a general query set up for a page
If certain parameters are not met, that query named, for example, Query1
is used
If the parameters are met, then a second query called Query2 is ran and
the contents of that Query are joined with a Union statement to the
first query and Query3 is produced. (so there's more data on the page)
So in effect, either Query1 or Query3 is going to be the query that will
be used to produce the data on the page.
In some cases I can do this with no problem because I just set a
variable called #query# or whatever and set that variable to be the name
of the query that is loaded, then on the page used <cfoutput
query=#query#>
For something where I need like the recordcount of the loaded query,
query1.recordcount or query3.recordcount I don't know how to do this
For this I was thinking I need something like #(#query#).recordcount# -
but I can't get the syntax right
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
