Webmaster Forum / ColdFusion / Advanced Techniques / June 2005

I am trying to setup a storedproc that first joins a few tables in order to
pull a select type of member from a master members list.  I then want to take
the loop that result set to get a count of where these members are from I have
the first part down where we group by country ...

1)   If i declare a variable inside the <cfcomponent> and </cfcomponent> tags
it is accessble by all of the functions in the component correct?
2)  Are they also accessable outside of the component or do they have to be
returned?

I am working on creating dynamic home pages with Coldfusion MX on the
server, Dreamweaver for developing and Microsoft Access as the backend
database.
I make changes to the backend database and the changes in data and

I am writing an application and I am keeping all of my components in a folder
called components that is in the root...
root
 + assets

I am currently programming an app and would like to make it so that if the user
leaves the browser open and their session times out, it will kick them back to
the login screen...
Is this possible at all???

I have a collection of documents that are continueously being added to and
revised.  When a user uploads a file, I want to search the collection to see if
the document already exist.   If it does, move the old revsioin to a different
location, then insert the new revison.   How ...

I have the following task:
I display a CF form with several checkboxes (they control which columns to
extract from a database).
Initially I can display them as checked or non-checked.

Hi All, I know this is probably very simple but I can't figure it out.  I have
a checkbox on my forms page.  When a user checks any one of the boxes I want to
submit the name of the field to the database using the value= parameter.  If I
do something like the following I get a -1 ...

Can I encrypt ColdFusion files?
I'd like to make a CF application with encrypted .CFM pages so purchasers
can't see the code.  The purchaser would put the files on their server -- a
server which supports ColdFusion applications -- and the files would work just

I've tried looking for the answer to this question, but i can't find anything
usefull.
Put simply, I want to find out how to round a number up to the next whole
number.

I'm using web based authentication to protect some web pages.
The user-id's and passwords are stored in Active Directory.
I need the user-id an password from the web based authentication
to launch an LDAP Query.

I am trying to dynamically generate a "photo album" output into a table with
corresponding captions:
The out put should be
1      2

I have a form that populates with data from several queries and calcs, it
creates about 70 rows of form data. I need for the form fields to be editable
and then submit the form with all 70 rows allowing the 70 seperate records to
be inserted into my Access DB as seperate records. ...

I have a cfc that calls to PC*Miler using COM.  Here is my cfc:
(see attached code)
I invoke this function with the following  code:
<cfinvoke component="Pcmiler" method="RunMiles" returnvariable="ETA">

I am trying to loop over a list:
<cfquery name="updsyllabus" datasource="#arguments.syl.dsn#">
                UPDATE #arguments.syl.tname# SET
                    <cfloop list="#arguments.syl.cols#" index="x" delimiters=",">