Webmaster Forum / ColdFusion / Database Access / February 2006

I'm running CFMX with Oracle 10g client loaded
My data source is Other; JDBC URL:  jdbc: oracle: oci:@TMS; Driver Class:  
oracle.jdbc.OracleDriver
Everything works well except that when I'm retrieving date fields from my

I'm trying to determine how many distinct "members" have paid in either one of
two tables. In the table 'confirm_tourns', the field 'tourn_paid' will = 1 for
paid. In the table 'confirm_lessons', the field 'lesson_paid' will = 1 for
paid. I'm using the member_id from a members ...

I've updated CF 5.0 over Windows 2000 to CF 7.0.1 and queries over Pick D3 ODBC
conection give an "ColdFusion MX 7 ODBC Server" error: "ColdFusion MX 7 ODBC
Server@LOCALHOST,ErrorCode=3004,ErrorMessage=sched.swschd.1756.Internal error,
an unexpected exception was detected.".

I am modifying the GetSubscribers() function to pull people who have signed up
for specific categories.  It works great when I manually put in which blog post
ID to check for, but when I try to use a variable it fails completely.
 I have tried several different permutations, ...

I have been able to set up a datasource that verifies and connects to the
database.  But when I run queries through coldfusion, I get 'invalid object
name' errors on tables that I create with enterprise manager.  I can run
queries on system tables just fine through coldfusion but ...

Hey all.  I've been pulling my hair out all day today trying to get this to
work.  I can do what i want to do in a straight <cfquery>, but i'm trying to do
it in a SP for better performance etc.  
Basically, I've set up Contribute templates for my client for certain holiday

I have a form where updating a field with a null value works...(thanks to the
forum)... but inserting doesn't seem to work with same technique....
I always still get a "data tyype mismatch" when the the form is empty and the
date field is empty.....

I have one small problem, I want to run a query using <cfquery> to read excel
file data and then save them into SQL data base, its very easy you can preview
it in my attached code. but ...
My files have different sheet name and numeric column names so I have 2

is there a variable that can be accessed from a query that tells the number of records updated?
Thanks
KES

I have coldfusion installed as a multiserver configuration running on both
Apache and IIS.  Is it possible to use coldfusion MX7 to connect to an access
database while running on a localhost Apache 2.0 server?  If not would it be
better to use MySQL as my database?

Just installed the trial version of CF7, accessed administrator, and want to
establish a db i have as a new data source, but when I select the 'browse'
button to do so, I get an "IO Error on Server Communication" message.
Any ideas?

I think it can be done.  But I'm new at this and have only set up Cold Fusion
to work on an Access database.  
So can I do with FileMaker Pro?  And how would I see the tables to query them
for SQL?

i'm using for the first time stored procedures in MySQL 5.0.18 and as database
client i'm using ColdFusion MX7.
The trouble is that the stored proc doesn't executed, the error message is:
The system has attempted to use an undefined value, which usually indicates a

This is not working for some reason it is telling me that ds_products does not
exist. here is the code...
<CFQUERY NAME="products" DATASOURCE="ds_products">
SELECT ProductName

I thought this would be  a breeze, but I cannot seem to get it to work.
I have two tables (Table A) and (Table B).
(Table A) = all productid's   (15,000 records)
(Table B) = Limited # of productid's (12,700 records)