Webmaster Forum / ColdFusion / Database Access / September 2006

When we moved from CF5 to CFMX, we saw the read speeds on our MS SQL2000
database increase by 1500%.
A simple read coded as shown below, ran in less than 1 second in CF 5, but
takes 30+seconds in CF6.

I am testing my CF MX7 apps which are currently running atop Oracle 8i and
migrating them to 10g. I am unable to establish any
connection at all and not finding much in the way of documentation. Currently
setup with ODBC socket but would like to change to Oracle JDBC on the new

I am having a problem inserting records into a SQL database. I receive an error
message on the server side. It may be the brackets in the fields. I need to
insert form fields into a table that has spaces in most all of the fields. I
put the brackets around the fields to insert ...

The query enclosed times out and I can't put my finger on the problem.   Looks
like it needs serious optimization.  Does anyone see a way to improve this
query.  I then run a loop on it which times out.
<cfquery datasource="#request.dsn#" name="getVacancys">

Hello.  I'm not really sure what is wrong with this.  I've passed field
variables by URL to a next page and it has worked.  However, on my last page I
get nothing...not even an error message.  Maybe I've looked at it too long and
can't see the problem....

  I'm a midlevel DW programmer, and low level CF programmer, and very low
Flash programmer.  I have a client that wants to have about 5 vertical menu
buttons.  Each button needs to have a flyout submenu that could have 20 or so
selections, and each of those could have 20 or so ...

I am creating search and reselt page with session.
Members are with birthdate in field, I did convert birthdate in to number with
datediff().
It converts, But when I use this it gives error.

Hi everybody, I'm totally new to ColdFusion, and creating a sample project,
where a user would enter in a person's info and upload a picture of that
person.  I trying to get my app to save that image to SQL Server database and
then to display that pic.  Currently, it "seems" that ...

I am trying to setup a datasource in MX6.1 to connect to sql server 2005 using
nt authentication.  I installed the jdbc driver for sql server 2005 according
to the steps listed at
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b&pss=rss_coldfus

We are migrating from CFMX6.1 to CFMX7.  We are using Oracle 10g.
We have been getting the following errors, most of them point to simple stored
procedures (see attached):
Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Object has

I am trying to run Oracle 10G Stored procedure in with cfstoredproc tag. And it
almost works.... I got the procedure to execute properly...BUT the ColdFusion
page that runs it... is "hanging"... or takes forever to do anything but show
the progress bar that indicates that it's ...

in one program i have this lines of code:
<cfset fil="select * from si02catdoctos where si02_estatus = 'VI' ">
<cflocation url="muestra.cfm?filtro=#fil#">
in the program muestra.cfm show this problem:

I have a stored procedure that returns properly when run from ColdFusion 5, but
not ColdFusion MX.  Under MX, it returns an empty string.  The execution of the
procedure by itself works as it should, but for some reason I can't get it to
execute right under MX.  The procedure is ...

We have just run into an instance where any query to a SQL2000 db locks up the
SQL server (by consuming all the resources), which eventually causes the server
to crash.
Our web host (intermedia.net) told us that the problem is selecting a field

I'm new to ColdFusion, but not to database or web development.  I'm wondering
if there's anyway I can run a SQL script on a database from my CF server.  I'm
running CF 5 on a 2003 Windows server with a couple Oracle 9i DBs on the
backend.  I want to move data from one DB to the ...