Webmaster Forum / ColdFusion / Database Access / July 2006

Hi
I get the dreaded error message "Error Executing Database Query. Timed out
trying to establish connection "
However the page/line number causing the error doesnt always correspond to a

I have a CF page that lets a user upload an excel sheet, which has been set up
as a cf datasource via CF admin, and also as a system DSN via windows. I have a
couple questions concerning this (although it works great so far)
1. can a CF datasource be set up without going into CF ...

I have a self-referential table, but I cannot figure out the query to output
the hierarchical list.  
The table contains the following columns:
category_id (PK)

I am trying to build s select list of team names for a sporting club website.
The select list should include teams if the currently logged in user is a
coach, team manager, assistant coach, player or a parent of a player.
When I have only one group of conditions in the where ...

When I go to the homepage of my companies website I am receiving an entire
error report as is anyone else that goes to the site.  The [problem is such
that I cant even get to the backend control panel because the authorization of
my database is all messed up.  

I am working with an existing table that has a bit field.
SQL server will let you specify 'YES' or 1, and 'NO' and 0 ....
I need to be able to have CF update these fields, but when I try
UPDATE myTable SET bitField = 'YES' (which works fine in SQL query analyzer)

i'm trying to create a .cfm site that is connected to access.  my problem here
are listed below,
1.  how to search the database and view it in another cfgridcolumn
2.  once in the cfgridcolumn, if i click on it it should go to another area to

Ok, this is what I have set up and you get the idea on what I am trying to
accomplish.
I have a table of my database called 'members'
Amongst other items I have columns called:

I've just switched to mySQL from Access. When I add a new News Article to the
site using my CMS extra characters are added to the beginning of the "longtext"
columns. You can see it here after the published date.
http://www.ncadfed.org/news/?loc=news&n_id=24

I have three dates field in form, 1 Today 2 Start date 3 End date.
I know for how to put default today's date but  dont know how to put default  
as of 7 or 10 days after now().
Will you please give me code for that?

What I would like to do is enable the user to upload an excel spreadsheet with
one column and many row of IP's. Then put the ips in a list or array and loop
through the list and query a table to get the IPs that match the list.
Any help would be greatly appreciated.

Hey you guys I have ColdFusion running under Apache 2 and I also have MySQL 5
running, however I can't get CF to work with MySQL. Do I need to take the .jar  
file from MySQL's website and place it in the lib folder of Apache. For example:
C:\Program Files\Apache Group\Apache2\lib

I have sql server 2000, and CF 7.0 running on server 2003 standard R2.
I set up sql server to use windows authentication, and created a system user
name SQLService for it to use.
Everything is all on the same machine, and I just want to make a datasource. .

I have a new development machine I have set up that has the same environment as
my current machine. The database gives an "ok" status in the CF 7 admin and I
can run queries just fine through the query analyzer. However, CF pages won't
execute any queries whether they are ...

I've used this same code countless times in CFMX 6...
  <cfquery  name="MM_rsUser" datasource="fikestudioDB">
  SELECT myUsername,myPassword FROM adminInfo WHERE myUsername='#FORM.uname#'
AND