Webmaster Forum / ColdFusion / Database Access / February 2007

Hello
Having followed a tutorial I wanted to try a connexion to a MySQL database
which was well configured.
I am using coldfusion mx 6.1

Post #1 so you may guess that I am new to this.  I have CFMX 6.1 and have set
up a link to a data source (Access file).  Now when I click on Browse Services
(because I want to change the path of the target) I get an IO Error on Server
Communication message.  I've looked at the ...

I'm calling a stored procedure within a CFC. I'm getting this error:
Procedure 'sp_AddCustomer' expects parameter '@newKey', which was not
supplied.
<cfstoredproc datasource="#ARGUMENTS.dsn#" procedure="sp_AddCustomer">

I thought the concept was straight forward but I cannot figure out how to write
the code for a table where one field, Category, may have several values.
Category is set as an nvarchar field and typical data in this field may be
2,3,8. Here is the code I have written that does not ...

I can't seem to connect to RDS on my new computer.  Here's my setup:
Windows Vista Business
I installed CFMX 7.02.
Eclipse 3.2.1

I need some help. I'm doing an application which is using CF MX 6.1 and MSSQL
2000 Server. I need to create an online application which can generate Student
ID number for the student among registration. Roughly, the procedur will be
seem like this. I'll receive the student ...

I need to create a drop own box for all the databases on the server.
What do I use for a datasource?
<cfquery name="getdatabases"  >
select * from sysdatabases where dbid > 5 order by name

I have an Access database with a particular table with 63 columns and 434
records. For some reason I am unable to access that particular table using
cfquery. The error message I am getting is "Syntax error in FROM clause" with
stack trace "com.inzoom.adojni.ComException: Syntax ...

Hi, I am currently trying to get CFMX 6.1 to talk to MySQL 5.0.27 on Redhat
3.0. I was able to get it working on our development environment using SuSE,
but not on our live servers.
We have been using MySQL 4.1.15 with JDBC 5.0.4 for awhile now with no

Dear Colleagues:
Greetings from BC. I have had this problem before with a previous XP platform
but forgot my fix for it :-(
SETUP:

I am new to cold fusion and have been practicing with some basic SQL on a
database.  I have it working locally but when I run it on my web host it
doesn't work.  They are telling me the issues are coding issues (probablly
right) but I cant find them.  I am calling procedures with ...

I have built a dynamic survey questionaire and am now trying to figure out how
I insert the results into the required columns in my access database.
there are a total of a 137 questions, I am displaying 30 per page dynamically,
the questions will be the same for each survey, just ...

Regarding to the Message Title, if it is possibles, please show me the SQL command (using MS SQL 2000) to do this operation. Thanks a lot.

Is SQL Server 2005 compatible with CF MX 7?  It is not listed on the MX 7.0.2
complete systems support matrix of August 2006. Has that list been updated? Do
any MX 7 users have experience with migrating to SQL Server 7?

I'm start using ColdFusion and whant to use MySQL DataBase.
I have a MySQL (3.x) Datan Source Connection configured on the ColdFusion
server.
On DreamWeaver I can access and retreive all the tables data but with a