I first want to thank all the pros who have taken time to answer my previous
questions. After 6 months of development our CF based site is 90% complete.
THANK YOU!!

Now to the new questions (I am running the CF MX 6.1 developer version on a
local testing machine)

1. <cachedwithin>:

I have a user registration page with the following query:

FIGURE 1:

<cfquery name="getCountries" datasource="db_global"
cachedwithin="#CreateTimeSpan(30,0,0,0)#">
SELECT *
FROM tbl_countries
</cfquery>


Subsequent pages on my website make calls to this query "getCountries". So my
questions is, for the caching to work is it suffice to call this query on
subseqent pages using:

FIGURE 2:

<cfquery name="getCountries" datasource="db_global">
SELECT *
FROM tbl_countries
</cfquery>


OR, must I again explicitly include the
cachedwithin="#CreateTimeSpan(30,0,0,0)#" command in each subsequent query
call?

I've actually loaded the main page that contains FIGURE 1 with debugging on.
After reloading/revisiting that page the debug log indicates that query time
goes down to 0ms and that the query is cached. BUT on the subsequent pages
where I use FIGURE 2 the query ran as if it were never cached, there was no
improvement in performance (query time =300ms), and no debugging indicator of
being cached. It seems that the only way the query gets cached is if I
explicitly state cachedwithin="#CreateTimeSpan(30,0,0,0)#" on every page with
the query exists.

2. <cfqueryparam>:

Does MySQL 4.1 really support this? On adding this to various queries with
dynamic variables I've notice no improvement in performance as per the
debugging log. Here is my code:

FIGURE 3:

<cfquery name="GetProfile" datasource="db_global">
SELECT *
FROM tbl_users, tbl_salutation
WHERE tbl_users.username = <CFQUERYPARAM cfsqltype="cf_sql_varchar"
value="#Session.MM_Username#">
AND tbl_users.salutation = tbl_salutation.genderID
</cfquery>


3. <cftransaction>:

Is this persistent across multiple pages and sessions? For example, if 10
users are registering at the same time, will <cftransaction> enforce data
integrity for each user's INSERT request? Or does <cftransaction> only work for
multiple queries taking place within the same page during a given session?


Thanks,

Blue spoon