Webmaster Forum / ColdFusion / Database Access / November 2006

In 6.1 after I initiate a query, i would like to see the generated SQL.
I know in 7 you can get the resultname.sql is there anyway to do this in 6.1?  
Even if its ugly, it will be better than having to do what I hope I don't have
to do and concatenate a bunch of ugly strings ...

Ok.. this is the first time I have tried using the cfgrid command and I am  
getting insane errors.  I googled the error and found millions of posts on this
with not one solid answer.
Two pages of code exist for this problem:

I have an admin page for a secure site where I am trying to add a function
using a checkbox to create a true-false condition on each record in a database.
What I have is a webpage with several records (pulled from the database using
the cfquery loop, and assigned an ID that is ...

I am trying to find the upper octile of a table and to do this I get the number
of rows in a table, divide by eight and multiply by seven.
<cfset upperOctile = round(getRatings.RecordCount/8*7)>
Then I loop through getRatings (order by rating, of course), and if the

I am trying to read from an Excel file and display the result in a CF Template.
I did use CFFile action="read"  and it's shows bunch of funny looking
characters.
Can anyone help me?

Currently I am using two queries to send 2 different emails. Problem is I
would like to combine this into one email. However this is giving me problems.
The first query checks that all the appropriate fields have been filled , if
not they get an email telling them their ...

Hi, can some one tell me what this error is trying to tell me:
 Error Executing Database Query.
No value specified for parameter 12
Its happening when the data is passed to the action page to be inserted into

I have been trying to figure out how i can upload an image to a specific folder
and also have that same upload linked with an insert statement into my sql
database.
An example would be i want to add a user to my database and the insert record

My network has dynamic IP addressing. My CFMX7 is
a developer's version that needs to connect to localhost (127.0.0.1)
and 192.168.0.2, and 0.3.
My router still says my 3 computers are at those IP addresses. However,

I've got a mssql database with records that have been timestamped using
coldfusions #now()#.
How do I go about running a cfquery to get the last 12 months of records???
In other circumstances the following statement would suffice

I have a table (Table 1) that list all of my data where the unic identifier is
a code that we have generate. This code is referenced on a different table
(Table 2).
ex:  REST - from table 1 = Restaurents - from table 2

We use the attached stored procedure within an ASP application to do basic
password obfuscation.  Am I able to use this same procedure in CF without
modification?  Right now I am trying it with cfstoredproc but am getting
"Procedure 'dt_External_Encrypt' expects parameter ...

I need to filter a query by whether or not a date field in my table is NULL.
This is the SQL I have, that doesn't work ... because it tries to convert from
smalldatetime to text.
SELECT     Lead_ID, ISNULL(Date_Lead_Closed, '12/12/1222') AS Expr1

I'm trying to fix an appliaction created using ColdFusion MX and Oracle 9i.
The application worked fine until our IT department reinstalled the oracle
server. As far as I've been able to see.
The CF application calls to a stored procedure in a package on the Oracle

I have a text file I need to use as a datasource. This setup is working on
another server but fails on this one.The only difference is that this server is
running ColdFusion MX7 with JRun vs the other server just running CFMX7
I think it has something to do with the JDBC driver.