Webmaster Forum / ColdFusion / Database Access / March 2006

does anyone know if i can use coldfusion with microsoft access as the database  to stream media? if so, how do i go about doing it?

I am trying to select records based on a date range, this is the query, it
doesn't like the format of the ##form.StartDate## and ##form.EndDate:
<cfquery Name="Requests" Datasource="#AuditSoftDSN#">
SELECT *

Ok,  so I have a problem.  
I work at a college, and we use Banner as our ERP.  Currently, our Banner
software package uses Oracle 9i as its database.  Now I want to pull bits of
information out of that database for our website (course information,

I have a MS SQL stored procedure that simply creates a temp table (#temtable)
and inserts records from 3 other tables selects records from the temp table
then deletes it.  Very simple.  The server is running CF 5 (which I have no
control over) and the scenario works perfect using ...

We have a new Oracle 10g database (upgraded from 8i).  I am trying to create a
datasource to connect to our CF MX7 Professional Edition application.  I am
receiving the following error:
Error Executing Database Query.  

Hi
Is there any way to select Primary key from table . If you do not know your
primary key. I mean can we make any condition or check in which select
statement will only select the primary key.

I'm trying to create a table through Coldfusion, but I keep getting the
following Oracle error:
ORA-01031: insufficient privileges
Is it possible to create a table through Coldfusion using CF 5 and Oracle 8i?  

Good day everyone.
I'm having a problem selecting the ID (autonumbered primary key in table) from
the last record inserted in MS Access. I've searched the forums looking for
ways to do this and attempted the following:

I'm getting this error (below).  I've created a form where once the user clicks
ths submit button they are taken to a page that says "thanks for filling in
this form."  The usrs information is sent to an Access databse table.  ALSO, on
this page is cold fusion code that emails ...

I had the usual issues with driver incompatibility: "null null" error and then,
after installing connector/j 3.0.17 I got "Callable statments not supported".  
I could not find the elusive 3.2 driver on the mysql site, so we installed the
5.0 driver (beta).

I am using CF to extract data from one table to
insert/update another table and I get the following
error : Unable to instantiate environment for 'ODBC.'
Any thoughts on what this means and how to solve it.

Hi, I have a question that I'm hoping someone could help me with. I'm use
coldfusion and microsoft access. I have a database and I'm trying to access
only a certain piece of information from the database, for example, I want to
get the names of the only the people that signed a ...

hi everyone, i need a big help, well i started to do websites in a couple of
years and now one of my clients is asking me to do a website adding a page for
log in of his clients after registration forms, and acquire particular
documents... i figure that i have to create a ...

I am trying to update a DB on a SQL merge replication subscriber.  I get an
error:  Invalid object ctsv_A58DF...  I know that this is some kind of SQL
replication table but how do I tell ColdFusion to ignore these?  I am
connecting to SQL via an ODBC System DSN.

 I've got problem with spaces after text strings in oracle.
 for example query
     select 'text' from dual
 returns with oracle thin driver string 'text' but with macromedia