Webmaster Forum / ColdFusion / Database Access / February 2005

When I enter my Admin password in CF Administrator, nothing happens. I know the
password is correct. I must open this to set data sources, etc.  I have
installed CF7 after cleaning out the registry. Installation completed with one
error so I ran wsconfig to set 127.0.0.1 as ...

I manage to download data fields from the Database in to an Excel file. Now i
would like to have the collomm names downloaded as well. Here is the code i'm
currently having. I  <cfquery name='laden' datasource='issue'> SELECT * FROM
tbl_issue ORDER BY issue_number ASC  </cfquery> ...

Even I create an empty a.cfm contains only <--- test --->, the IE browser still
return the below error
Error Occurred While Processing Request  
Element LOCALE is undefined in REQUEST.  

Can I use CFML with MySQL? at the moment I am using CFML with MS Access.
Can I use the same CFML code with MySQL?
Dario

Has anyone seen this before and if so how did you resolve the problem?
Connection verification failed for data source: (Data Source Name)
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect

I have a form control called 'Nominee'. It is a list box. It is dynamically
populated by | #FirstName# #MiddleName# #LastName# | retrieved from the
'Employees' table in my Access database . How do I pass the individual
variables via the CF process page into the corresponding ...

I have three forms:
Choose Login
Enter company information
Enter financial information

I have been using query of query a lot and the SQL is limited, it has been trial and error seeing what works.
Does anybody know where I can find an online reference for the SQL syntax? :confused;

I am having trouble inserting two queries...I am trying to insert an new
item(pk) into a table in one query, and then inserting an item(fk) in another
table that relates to the other item just created in the first. The problem is
that in order for the second query to work, the ...

I am having one website in coldfusion. But not able to connect database with
application. I am getting following error.
I created Database in MS-SQL and try to connect from Coldfusion admin manager
->Data & Services > Datasources and uses driver as "ODBC socket"

I have a table named therapists with a field named modalities which contains a
comma delimited list of id #s.  I need to loop through a list of modality id #s
and return results for each id #.  Explanation - I need to find the
therapist(s) whose modality field contains the ...

I've got a table with a bunch of sql statements that I need to run and cfdump
the results to the screen.  I have one <cfquery> tag that pulls the sql
statement out of the database based on an ID number given:  <cfquery
name='retrieveSqlStatementToRun'> SELECT sql_statement as ...

can anyone tell me how to format a very long database field when output it to
page. everything works fine except it is one very long string and i'd like to
make it into several paragraphs. is there a way to put some break in the Db  or

but I get  an error  which does not make sense because the line indicati ng the
error is properly compiled.  Please help
My code is attached:

I have a Win2K box with CF 5.0 and am trying to create a DSN to a new box
running SQL 2000 on Win2003 - and it won't.  I can make an ODBC connection OK,
however. Checking elsewhere I saw mention of using an "ODBC Socket" data type -
but don't have that in my drop-down.  I also ...