Webmaster Forum / ColdFusion / Advanced Techniques / October 2007

Hi All,
I have just moved into Coldfusion technology. My expertise is predominantly on
Oracle and PL/SQL development.
In the application i am working on, we are currently facing, an issue. We have

Our application has about 150-200 concurrent users at any given time.  We're
using session management with the basic CFID and CFTOKEN, which is a UUID.  We
have an exclusive CFLOCK around the bit of login code that sets their session's
user id.  We also provide a login option to ...

It appears that when I try to union two queries, something is reordering
everything.  I have 2 separate queries that need to be unioned, but with the
first query's results showing first, then the second queries results.  This is
ending up in a select list, so order is important.

I'm an old-school coder.  I've been trying to figure out the new AJAX controls
to see if they could save me some time, but I'm running into headaches.
At the moment I'm building a tool to reconcile a table full of firstname
lastname and organization records (strings, no id's) ...

I have a CFC (obviously) that works fine if I instantiate it during onRequest.  
But since everyone uses it a lot, I thought it would be better to have it as an
APPLICATION.CFC instead.
However now I get the error

I am trying to invoke a web service but keep getting:
Web service operation "Login" could not be found.  
I tried stopping and starting cold fusion. I tried going into data service and
deleting the web service.

I think that it is impossible to use flashforms together with the new cool
coldfusion ajax functions.
But what to do when I want's to use the cool UI components of flashforms like
<cfformgroup type="panel">.

I'm currently trying to spy a slow part of my code and I face a problem : the
GetTickCount() function does not seem to be precise enough to tell me where is
the slowest part of the code.
As there is many things linked, I can't just remove a part of the code and see

this is from the  fbx_Settings.cfm
what is this for ?
fbx_Settings.cfm - in home circuit
These settings apply to my whole site, not just this application:

Okay, a newby question, I'm sure, but here?s one.
I inherited a website, and now need to start updating and maintaining.
Managed to connect to the DB host and set up the ColdFusion DSN 100% fine -
DSN verifies 100%.  

I created a cfc using the tutorial at
http://www.adobe.com/devnet/coldfusion/articles/creating_cfcs.html
Unfortunately, I can not get past seeing the CFC in the Application>Components
window panel. I hit refresh and I get an error stating:

I am getting error message unterminated string.
document.location.href='getname.cfm?buffer=#buffer#';">
Any idea. thankx

The following query (CFMX7) is working fine with my MS SQL database.  However,
if I go in and add a field to the table the code then generates an error.  If I
remove the use of cfqueryparam and just use #calID# for my variable, then I can
add the field without error.  I've had my ...

I have an application where a user fill in a form, then they click on
?preview? and the form user (using camped tag) create a dynamic PDF  file.  
(The puff is open in its own window outside of the form)? the PDF is for
viewing purpose only.)

i've an issue with <cfpod>, <cfform> and firefox
i'm calling  display.cfm file from <cfpod source.
and display.cfm has a <cfform> tag in it and I've <cfajaximport> on the top of
the main page.