Webmaster Forum / ColdFusion / Database Access / March 2005

I want to 2 link to drop down menus together so that the options from the
second will be filtered according to the option chose in the first one.
This page is meant to Insert information and for the user sake, I would like
to do this without reloading the page.

I recently upgraded from Coldfusion5 to MX7 and changed one of my datasources
from an Access db to a MySQL one.  I'm using the same datasource name as in my
coding previosly with Access.  
I'm getting " Error Executing Database Query".  Here is my code for that line:

statement to do the following operation.  I have two tables:  Participants
(p_id, p_fname, p_lname)  Participants_Keywords (pk_p_id, pk_keyword)  I want
to write a query that matches participants based on ...

Hi all.  Need a little help getting my WHERE right.  I have a short date field
in my Access database called eventdate.  I need to form my WHERE statement to
only use the month portion of that value and compare it to a form value called
form.month. The value of form.month is: 01, ...

I have some CF code that I want to execute when a user leaves a page.  I put it
in a javascript OnUnload routine.  However the code seems to be executing when
the page loads as well.  I set the agent status = 'I', then load the page, and
the status is set to 'O'.  Does anyone ...

Hi
I am learning  cold fusion , some body help me last time for this query, thank
you so much, I am using the query below to get health information from
HEALTHFORM table by user login name and password, when I run this query it

I'm having trouble connecting from ColdFusion5 to MySQL.
I've already downloaded and installed the Myodbc 3.51 driver and still
nothing.  When I login to the CF Administrator's page and go to data sources
under odbc I'm left with these choices:

I thought something would be easy, but I'm lost.  Quickly, I'm making a form to
sign up employees for a training course. The selection is 1 of 4 dates, then a
box for completed (Y/N). First trying to update dates. I read the employee name
(Access primary key) and have a string ...

My ISP used to have Cold Fusion 5 running on their servers, allowing me to
connect to databases via OLEDB connection:  <CFSET DB='C:\Web\Files\DB.mdb'>
<cfquery name='Get_Files' datasource='#DB#' dbtype='OLEDB' username='Admin'
password='' provider='Microsoft.Jet.OLEDB.4.0' ...

On our Solaris Test server running CF5 we have Native Driver connections to
several test Sybase servers.  During testing, our connections all work, but
when we tried to connect to a database that was down, we got an error, now all
our connections to any Sybase server do not work. ...

I'm getting the following error in my CF page when trying to call a stored
procedure in an Oracle package:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06564: object
HSC.PKG_SR_TEST.SP_TEST_IT does not exist ORA-06512: at "SYS.DBMS_UTILITY",

I've the following code that is supposed to upload an image as a BLOB in the
oracle 9i db (I am using cf mx 7)   <cffile action='readbinary'
file='C:\projects\java\insertblob\tiger.jpg' variable='aBinaryObj'>  <cfif
isBinary(aBinaryObj)>     comes here     <cfset base64 = ...

    Any help here would be most appreciated. I have a table, one field of
which is type BLOB. I wish to extract this data using a Coldfusion page and
have the user be able to save it (similar to an attachment). I have my reasons
for not placing the data elsewhere and linking it. ...

Hi all, well this is my question:
I want to show 2 or more different sets of record sets but one or more of them
have to be nested on the first, since I cant do
<cfoutput query="query1">

I am in a way at this moment where I have to find records from tables where
date are the primary field to be validated. In another word, I tried to
recuperate records by using StartingDate >= '#myDate#' but it seems that the
MS-SQL Server never return any records. But if I tried ...