Webmaster Forum / ColdFusion / Database Access / August 2004

Hi all.  I need a little help with what I think is a very simple SQL/Access
question.
Here's the situation:
I have a client that is currently using a POS database in their retail store.  

I am unable to get a verified ds connection to sql database.
OS: XP pro
SQL: 2000
CF: MX (single/developer)

I'm trying to create a DSN  programatically. There is a problem i'm facing
creating the dsn for access database. The dsn is created succesfully but when i
verify it, it gives an error status without any description. Also in code it
gives this error.

I have an access DB and an update page to allow end users to update records in
the DB. I have a select box on my update form and what I want is for it to
display the current value of the record when the end user first displays the
page, but I want them to be able to change the ...

Platform: CF 6.1 Enterprise, Oracle9i v 9.2.0.5, the 3.2 JDBC drivers (the
3.3 ones failed to work on one of our servers so we can't use them).
These have just started being recorded in the cfserver.log file since
yesterday:

This is a basic question for someone.
I just completed reading through"Dreamweaver MX Dynamic Applications", by
Jeffrey Bardzell.
I am attempting to set up a new DB source but have been unsuccessful in

Has anyone used "for xml" in a CF APP?
My problem is the random column name of the result set. the column name is
usually something like:
xml_f52e2b61-18a1-1ld1-b1o5-00805f49916b

Please help!!!!
For the past few days I have been stumped by this problem, and can't find a
solution
I am trying to delete a record from a access db.

I'm trying to produce an ordered list; however, the list I'm producing with the
code below doesn't display ordered.
I think it may have something to do with using IN in the WHERE clause but I'm
not sure. Does anyone know if this is supposed to work, if not, is there

Hello. I have a query that I need to run and I'm having some problems getting
the correct results.
SELECT a.topic, b.subtopic,a.topicID, b.subID
FROM topics as a LEFT JOIN sub as b ON a.topicID = b.topicID INNER JOIN

is there a way to run a query and randomize the order in which results are
displayed using mssql?..or do i need to stick to running a second query,
randomizing the PK order in a list, then sort the query based on the list order

I'm getting this message and I'm sure why. Anybody know why?
Invalid column name for Group attribute.  
The value specified for the group attribute "APA" does not specify a column
name of the query  

I am doing a CFFILE upload, and need to insert the "file.timecreated" variable
into an access database via odbc.
I am inserting the variable into a text field, aka its not date/time formated.
I just want the info from the variable inserted. It will be formated when

Hi, I'm new to coldfusion MX and I'm having problems re-establishing my db
connection after its first time usage. For instance, my database done in MS
Access connects on my first attempt in CF, and I am able to pull data out from
it in a cfm page; however, when I close all my ...

I have a coldfusion database  (cfm ) how can I display this in a ASP or html
page
Im lost now :-((
Regards