Webmaster Forum / ColdFusion / Database Access / July 2005

<CFQUERY NAME="ticket_info" DATASOURCE="HelpDesk">
        SELECT *
        FROM Help_Desk_List a, NotesTbl b
        WHERE a.Entry_ID = #Close_Ticket# AND b.Ticket_ID = #Close_Ticket#

Is it possible to detect the data type of a column in an ODBC Select CFQuery with MS Access or SQL Server?
This solution will save me a lot of effort.
Thanks

"deleteID" in the following query could be either alpha or numeric.
How to modify the query to accomodate both cases?
<CFQUERY datasource="#dsn#">
delete from #table#

In my CF form I have created a date object using #DateFormat(Now(),"MM/DD/YY")#
which displays the date as: 07/29/05.  
When the date is  inserted into a Date/Time Field in a SQL table and I view
the resulting entry in the table looks like: 7/29/2005.

I need a little bit of help, heres my problem: I successfully developed a
database and website in ColdFusion on my local server. I then went to a hosting
company that offers ColdFusion Database Support as a service. I uploaded my

*disclaimer* -- I'm a CF n00b.
Hello all,

I am using a simple query against a MySQL table with a selection based upon two
columns.
SELECT *
FROM   clog

If  one database with several tables. The fileds are populated by a form.
A second table called "regionmail, does have three collumns. "Region"  
"Products" "Spares"
When the ROW of the region is selected,( from "regionmail) i would like to

Does such a thing (ODBC/JDBC Driver) for peachtree exist?
Im writing a project tracking app for an intranet that I would like to
update a couple tables in peachtree on command so we don¹t have to key the
info again later...

help!  I'm using coldfusion mx ver. 6 on windows 2000 and I could not connect
to Informix 7.22 I've read that coldfusion mx only support informix 9.x...how
would i connect to lower versions of informix??? :frown;

Okay, stuck with CF4.5.  No biggy.  I just want to pull data from a db and make
an xml file out of it.  BUT I want it to be generic and fast. to code.
I know by the time I get an answer I could have it coded the long way so this
is for future reference.

Hi, I am trying to create a new DSN on a CF web server hosted with our ISP.  My
problem is that the actual SQL Server database is located our local network.  
The local server is running Windows 2000 Server with MX7 and SQL Server 2000,
the web server is running on Windows Server ...

I need to read from a progress db put i ma having problems reading fields named  with special chars like in Element1% and flux-ecd (% and -)
how should i read them
thanks

I created a .cfm page using various queries to output a company phone list (1.
lname alpha, 2. dept, 3. branch). I then have it create a .PDF using the
<cfdocument> tag.
Now I am trying to recreate this site but allow the user to manually choose

I have some Performance Problems in my Database Query.
I had to Join 8 Tables for this Intranet-phonebook (department,
superdepartments, functions, ..) in one Query.
So I think this is why the Query is so slow.