Webmaster Forum / ColdFusion / Advanced Techniques / February 2005

I have a database query which returns me multiple columns. However at compile
time I do not know the column -names of the query result set. (I am using
report builder Coldfusion MX-7 's query-builder in advanced query mode.)So I
can not put the names of the columns in the ...

I ran into a major problem lately where <CFDIRECTORY> returns the
following value in the datelastmodified column: 'January 25, 2005
2:28:57 o'clock PM EST'.
Where the heck does the "o'clock' come from and why does IsDate return

I am trying to take a CFSCRIPT that I wrote and putting it into a web service.  
The CFSCRIPT works perfectly standing alone - it dumps a string of information.
When I copy and paste my SCRIPT into a new CFC - I get errors:  Anyone have
any idea why this is happening?  Standalone ...

We have one user who is able to log in and is able to continue to other parts
of application without session variables disappearing.  But another user who
also is able to log in successfully but were kick out of the application doing
the same thing due to their session variables ...

I am trying to modify code developed by someone else that imports an excel file
using CFFile upload.  Then, the previous programmer used a <CFQUERY
DATASOURCE="importexcel" NAME="Excell_Data"> to somehow manipulate the excel
data so that it could eventually go into our SQL server ...

Hello:  I posted this code in the general forum, no answer yet (it might be too
advance?).  I am trying to send messages to every user in the form field list.
I tells me how many messages i sent, however, my code fails! And it wont even
set a variable in the cfloop. My variables ...

display  outage for a give day if same as calendar day. So for example: I have
the month a feb calendar. and on the 5th and 8th there was an outage. outages
are entered into the db the type= 'outage'  ...

I need some help displaying a record count if it's possible. Here's what I got.
Events Table : eventID, eventCategory, eventType Event Type Table : typeID,
typeName  Here's what I want to do. Return a record set consisting of rows from
Events where eventCategory is 2 and ...

I downloaded the new cf version this week and am trying to build a form with
the cftree to select an image and display the image. I decided the best
solutions was to show the picture outside the flash form using javascript.  
Unfortunately I can't get the flash to pass the image ...

I have having troubles passing variables thu URL. The line below run well and
the value is passed:
template.cfm?p=3
But with this I got an error message Element p is Indefined in URL:

Have been using CFUSION_DBCONNECTIONS_FLUSH()  on a CF 5.0 server...just tried
it on 6.1 and got an error saying it  is no longer supported. Is there
something similar I can use do flush all Access DB connections in MX 6.1?

We have a commission that should calculate to -2.475 and round to -2.48.  
When we display the commission, i.e. #comm# it displays as -2.475,
#NumberFormat(comm,"999999999.99")# displays as -2.47
however #NumberFormat(lclCommAmt,"999999999.9999999999999999")# displays as

Is there a way to get a complete listing of the existing dsn's configured in CF
4.5 server?
I'm wondering if there is a file or something that I can print out that list
the name of the dsn, the directory path to the database, any usernames and

Here is my problem....I have a shopping cart where users can choose photos for
purchasing. Once their credit card is processed, the id for the photos they've
chosen, along with the amount of each photo ordered, are entered into the
database. After that, I need to be able to match ...

I got the followin code:
queryaddrow("application.user", ArrayLen(application.xmluser.user.item));
inside a <cfscript> tag in a cfc. As you might see, I'm trying to convert a
XML into a query object.