Webmaster Forum / ColdFusion / Database Access / October 2005

I need help with some CF code that will target the users tables with in the DB
and make copies of them, I think the best idea is to copy them into a seperate
DB. I have a master DB that services MANY different customers, all have tables
with the same name, but each table includes ...

I am trying to configure the IBM Informix JDBC driver so we don't have to use
the ODBC connection between Windows 2000 box and the Informix database resides
in a Sun box which hangs from time to time.
http://www.macromedia.com/support/coldfusion/ts/documents/config_ibm_informix.ht

Can a cold fusion page on an Intranet connect to an Oracle database on another server?

I'm using Informix 9.3,  If I run the query in Informix it works, when I run
the same query in ColdFusion I get a string to date conversion.  I'm using the
Informix JDBC that comes with ColdFusion 6.1.
SELECT uid, sdate

I made a Store locator with ColdFusion MX and a MS Access Database and it works
great except for one thing. There are a bunch of fields to search by, like city
name, State name, etc.  But if someone enters in say, "Virigina" and there are
no stores in Virginia in the MS Access ...

HI, I am trying to join a bunch of queries together so that I can convert an
html table into a cfgrid, and having problems. The query is:
<cfquery name="getteams" datasource="#ds#">
SELECT  teams.teamname

I'm new to this.. and cannot for the life of me figure this out.  Please help.
This is the error I am receiving:
Attribute validation error for tag cfoutput.  

I have an Events Calendar application that I want to automate a bit more. I
need a way to have coldfusion delete a record if its "Expiry date" is past
today's date.
I have tried a conditional statement with limited success.

I have an employee table, and an organization table. The employee table
contains an ouID link which always has a match in the org.table. The employee
table also has ouID2, ouID3, and ouSubID fields which do not always have a
match in the org.table. How do I create a query to ...

I have asked the professional here yesterday about the stored procedure
problem but it is still not solved.  I use the query analyzer to test the SP
and it got exactly what I want. However, I duuno how to get it back to my
webpage, I have the code here:

I'm currently using MySQL 4.1 with Cold Fusion MX 7 and everything is working
fine.
Now, MySQL have released the 5.0 version which contains several additional
interesting features which I'd like to try it.

I have been trying to upgrade my server from CF 5 to CF 7. I have a table as
keywords with the attributes as follows:
ID int (primary key)
keyword char

I would like to run one query that would return the records in a alphabetized
asc  listing but I would like it grouped like this:
A
at

I am running the Developer version of CF and I am trying to make one simple
connection to MySQL database, however, i keep getting an error message when I
try and set up the connection. This is the message I get:
Connection verification failed for data source: mysqlcf_jbspeckh

Hi Folks -
I was wondering if anybody knows how to get a single value result from 2
previous calculated results...
Here's my query...