Webmaster Forum / ColdFusion / Database Access / June 2008

Hi folks,
I'm considering the idea of migrating my development environment from Linux to
Mac for a variety of reasons which we'll stay away from here.  I see that both
CF and MySQL have Mac versions:

We have an Access db on another Web server we are trying to use for
queries/select statements only on another Web server.  We create a mapped drive
and enter the path to the mapped drive in the connection string.  The
connection verifies and the Web pages function correctly.

i cannot figure this out. its been going on for weeks now. i have the
datasource correctly setup to a Oracle database. a simple "select * from
web_adm.coordinates" on my PROD box returns results in 1 second. on my DEV box
the same thing takes 60+ seconds. they are both querying ...

It should be returning results where whatever was entered into the search box
can be any part of the title. If they don't enter anything all search results
should return everything. Also the hours should return results as well. Various
should return all of the different hours and ...

I am writing a CF application that queries a Centura SQLBase DB--not my DB of
choice, its an interface partner's DB!  Some of the fields in the SQLBase DB
are of type FLOAT, which for some reason CF is returning in scientific notation
(i.e. 1.23653E7) rather than as a whole ...

I work with CF MX V7,
I use this code, and the SQL update failed : (with a single quote in the text)
                  <cfset des=" test test ' test ">
    <cfquery name="insert_prod" datasource="#boutique_datasource#">

I have my laptop set up and running CF MX7, CS3, and SQL 2005 Express.  All
programs have been up and stable since install, but I cannot seem to set up a
datasource within the CF Administrator.  I've exhausted every avenue I was able

Thanks for any help you can give..... but I'm working on creating an SQL
search statement of an Access Database.... (Using CFM 7).
Now, I have two(2) criteria that must to be met in the SQL statement ...listed
at the beginning of the SQL statement below.... but then in additon ...

We are running Cold Fusion MX 7.0.2 on a Windows 2003 server.  We are having
problems with the HTTP service on this server shutting down.  A re-boot fixes
the problem but then it fails again in about a week.
The data sources for our web sites are stored in SQL Server 7.  Does ...

I'm am using dreamweaver 9.0 coldfusion 8 and access 2007. I can get all the
text info onto dreamweaver just fine from access. But when i use the atachment
feature and try to include a picture all i get is a red x or an error message.
I cannot figure out why!!!!

In sql server 2000, what data type do I use for a field that needs to show two
decimal places?  It is a weight field, so the weight in ounces could be
something like 12.25 and it needs to store it this way in the database.  I'm
kind of new to sql server, so any help would be ...

I have an Oracle stored procedure I call that opens a cursor:
CREATE OR REPLACE procedure trialProc(c_test out sys_refcursor)
is
begin

I would like to create a database with a region table, country table, and city
table for some countries including australia, new zealand, japan, and canada.  
is there a pre-written script of .csv file that is available for free.  Looked
at the geodatasource website, but it is ...

I have been connecting to a FoxPro database for years now with the ODBC
Connector. It works OK, but would like to know if there is a JDBC connector
available these days. My searches have uncovered ODBC-JDBC Bridges, but I am
not sure if that buys me anything.

We have recently upgrade to coldfusion 8.01 from cfmx 7 and have noticed
something different in the behaviour of temporary tables. We sometimes create a
global temporary table which is unique to a user and then access the same
temporary table from a different cfm page within the ...