Webmaster Forum / ColdFusion / Database Access / August 2005

Hi,
I'm trying to set up a datasource connecting up to a mySQL db from within the
CF administrator (cfmx version 6) and I get the following message.

I have an application that does a ridiculous number of queries -- its purpose
is to extract records from one database and insert them into a different
schema. It runs very long, is admittedly very clunky but was intended as a
backend, batch type of process run infrequently.

I am working on an application,that requires the records to be displayed in 2
columns..
So i need something like this..
<tr>

I am trying to access a foxpro 5 database in order to migrate its data into sql
server 2000 usign coldfusion.
i created a system DSN on the CF server pointing to the folder containing all
the dbf files and then created a CF DSN (ODBC) using the system DSN.  the CF

Has anyone connected to a SQL Server 2k named instance from CF 4.5? Yes believe it or not we are still using 4.5. I do not see a place in the Data Source for the SQL Server port.
Thanks,
Brian

All,
I have an Oracle(9) stored procedure that my application calls, and my current
session is set to time out in 15 minutes. On occasion the procedure does not
return in this time, (and since I've got a page that basically will log a user

I'm getting this error:
"Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Transaction (Process ID 63) was deadlocked on lock resources
with another process and has been chosen as the deadlock victim. Rerun the

Is there something like IsDefined that tests for a cached query? If yes, I
can use that to avoid going back to the DB. thanks in advance
-brian

I've read all the posts about this problem, but still can't find an answer that
works.
It shouldn't be so hard.   But, for the first time, I now want to connect
(ODBC) to a database (Access) on another server on our network. Before, the

when I insert a record with the "insert" behouviour everything is okay. When I
later want to update this my web application get confused and switches around
with the comma(,) or point(.).
What is the best way to insert and update numbers?

    <CFQUERY NAME="EMP_DATA" DATASOURCE="EMP">
        select a.*, b.locname, c.ou
        from emptbl    a, loctbl b, outbl c
        where a.ouid = c.ouid and a.locid = b.locid

I?m trying to get a SQL query to return data from 3 tables.
I need all the data in my tbl_producs table to be returned, the other two
table are linked but some fields are empty i.e. product 1 might only have a
cat3ID and not a brandID. Product 2 might have both etc.

I am using an MySQL database with utf-8 character set. When I check the data
through phpMyAdmin, the data looks fine (I am using hebrew chars). but when I
try quering for the data from a coldfusion page, I get chars that looks more
like thai.

would welcome help in connecting Coldfusion MX 7.1 to MYSQL on a
system running:
  XP Service Pack 2
  Coldfusion MX 7.1 using the inbuilt server for development

Hi Guys, first of all thanks for your help.  Can someone please help me find a
ColdFusion component or custom tag which will allow me to import a CSV file
into one of my tables. Does anyone have a script like this?  If you don't have
a script then perhaps a premade utility which ...