Webmaster Forum / ColdFusion / Database Access / August 2006

I have a query that returns from the table name a module name a score and a
maximum score. There are 2170 rows the query returns. I want to be able to
write a query which will enable me to just select the 10 names of those who
have accessed the most modules. The query I am using ...

I have a cf page that pulls a list of our cpu inventory.  I need to find a way
to take the id of multiple items from that grid and update their status.  
Ideally, I would like to double click on an row in the grid, which would add
the item id to a list that was viewable and then, ...

I have an old FoxPro database that I am working with and I am trying to look
for NULL dates.  When using DBFViewer they appear as "  /  /  ". When passed
through ODBC they come out as 1899/12/30.  I have not been able to search for
these blank dates successfully using the normal ...

  New to coldfusion ... paddling hard under the water...
 Created a login site. Tested on my computer .. works fine...
Uploaded to my webhosting provider. I keep getting the error message
"Datasource could not be found".

I have a query below that gives a list of all items in the DB:
SELECT DISTINCT NAME
FROM dbo.PPS_SCOS
WHERE NAME LIKE 'MTM-%'

Any idea how to get all table names, pkeys and types of columns (i mean counter, varChar and etc.) from Access db? And another one - is it possible to use value from 'caption' in Access db?

How to connect to godaddy.com database using ColdFusion MX?
How to connect to MySQL in the godaddy.com shared hosting account using
coldfusion.
Guys I am seriously going crazy. I cannot belive that I cant find a place on

I am working on my laptop on developing a web application for my company. I
have installed ColdFusion Developer Edition and have Dreamweaver. I am trying
to connect my Data Source to my Access Database which is on my z: network
drive. This drive links to my network folder in the ...

I'm building a Web application locally on a Mac running 10.4.5 and my Web
hosting company only uses Access databases. Since Access isn't available on the
Mac platform, I'm wondering if there's any other way to create Access databases
on a Mac, or port another database over to an ...

I am running CFMX 7; I have an ODBC connection to an Informix 9.40.uc7 DB.  I
can link to the table through MSAccess and see the data in the table; but when
I try to see the data in CF it returns no data.  Any ideas?

Im trying to pull data from a breeze database, the information i need i have
to use 3 tables.  I have what i need in sql but i need to know the best way to
do this in coldfusion.  here is the sql
select principal_id from pps_principals where [name] = 'Lee Duncan'

I have a column that can contain none, one or many recordIDs  (from another
table) stored as comma-delimited text strings (i.e., a list).    I need to
retrieve all records that match a single value within that list.  
For example, if I want to match all values that equal ...

I'm a total CF nub ... Do I need to format this text?  Conver it somehow or
wrap it in more tags?
<CFLOOP INDEX="rsm" LIST="#Form.whichRSM#">
    <cfquery name="qAddLeadRSM" datasource="nextgen">

I'm creating a ColdFusion Web applicaiton and need to create a database to use
with it. Someone recommended MySQL. My quesiton is, is MySQL a database server
or a database application, or both?
I'm on Mac OS 10.4 and want to be able to create a database and test the

I have a piece of code to update the database:
<cfquery name="rs_updateUser" datasource="#Application.datasource#">
UPDATE f_users
SET password='#FORM.newpassword#'