Webmaster Forum / ColdFusion / Advanced Techniques / January 2006

I have a query that joins multiple tables.  The key across all the tables is
the SSN column, which I select as Distinct.  When I left join another table
(tblLanguages) where the SSN is found multiple times, the resultset then
multiplies depending on the number of times the SSN is ...

I am trying to access VSS Automation APIs through coldfusion to find out the
version of a file
        <cfobject   type    = "COM"  
                           action  = "create"  

I am trying to create a drop down or url.variable that will define how many
<cfinput type="text"> boxes will be displayed in a form. For simplicity, on my
test server I was using a url.var.
<cfif isDefined('FORM.submit')>

Hi guys, can anyone help a little lady with this coding problem.  I am working
on a Fusebox app which is quite large and has a number of include  files
embedded in each page.  During development is there some code which might
access the name of the include files?

        I am getting the following error when I try to perform some query
operations inside a CFTransaction tag......
       The root cause was that:java.sql.SQLException: Usernames and Passwords
for all the database tags within CFTRANSACTION must be the same.

OK, this is very strange. When startup my browser, and go to the login screen,
type my username and password, and post the form, it doesn't get in <cflogin>.
The session variables I want to set are not set, and things go wrong. However,
if I logout using <cflogout>, and try again ...

I have a structure that logs all the live sessions on my site, normal I would
see if someone was online doing this:
#structKeyExists(Application.UsersInfo, member_id)#
What i need to do is only pull online people from the database, I cant get it

I have a couple paragraph text that need to parse through. Problem is that
there several "#" signs in it. So doing Find/Replaces create problems.  How can
I use cold fusion to simply remove them? #ReplaceNoCase(thetext,'#','','All')#
obviously doesnt work.  Is there are Char() ...

hi i  am usiong cfgrid to show one of tables,
this works locally, but when on the web i get this error
The request has exceeded the allowable time limit Tag: CFLOOP  <br>The error
occurred on line 2153.

i have a drop down list with values of Organisation Names
when a user selects a Organisation Name i need a text box to be automatically
updated with the Organisations ID
what would be the best way of doing this?

/usr/bin/find /filepath -type f -name '*.cfm*' -exec grep -i -l ' ' {} \; works
in unix.
Why doesn't the following work in cf:
<cfexecute name="/usr/bin/find" arguments="/filepath -type f -name '*.cfm*'

I have a comma-delimited list of UIDs in a field (named "planner_uid". This is
NOT the user id field that is used for security). I need to find out if the UID
of the person who is logged in (session.uid) is one of the UID's in the list.
I've tried using REFindNoCase, but it only ...

I am having a problem with site-wide error templates.  In the Application.cfc
file I have the following:
<cfcomponent ......
  ....set the application variables here ....

i am kind of in an emergency situation. a webserver we have crashes very
frequently with no apparent reason for it.
the log has an entry like this:
"Error","scheduler-2","12/16/05","07:45:14",,""

i have a simple form which i am tring to set the values of a column in my
table, i have tried the code below which works, but this gives my a submit btn
for each record, because i have hundreds of records i need one submit btn to
set all the values