Webmaster Forum / ColdFusion / Database Access / January 2005

I'm totally new to CF. I'm now converting from ASP. In ASP, I've managed to
call the database from a single source (Include File) and supply the username
and password only once. Can CF do the same? It's somewhat a pain to always
supply the username and password everytime calling ...

When the pop-up "Configuration and Settings Migration Wizard" appears it asks for my "ColdFusion Administrator password.  Question: Where do I find my password, or how do I create one?

What are the thoughts about how many cfquery's you should use per page?  I am
using multiple queries to reduce the size of my stored procedures and make them
more managable. I then group the result sets with queryNew in my controler
circuit of fusebox, and then forward the ...

Hi - when running this query (a rewrite of an UPDATE FROM in SQL Server) Access
2000 displays a popup box asking 'Enter a parameter value:  table2.title'.  How
do I amend it so the query recognises it should be using the data from the 2nd
table?  Any advice much appreciated ...

I am building a dynamic sql statement stored into #sql# variable. When
I put it inside <cfquery>:
<cfquery datasource="#arguments.dsn.name#"
username="#arguments.dsn.user#" password="#arguments.dsn.pass#">

Hi, can anyone help me out with this;  Have installed the latest recommended
MySQL server, it works fine - i can create databases' etc in it. The problem is
when i attempt to setup a data source in the coldfusion administrator for the
databases. it throws me the following error : ...

I'm attempting to extract data from four different tables and produce a single
results set. So far, nothing but SQL errors.
Table d: PLACEMENTS (I only need distinct rows from this table, and I need the
rows whether or not data exists in the other tables. The criteria for ...

Hello all, I am trying to perform the following query:  SELECT  DISTINCT
toriswebed.v_SI_WIR.cname,  SUM(TORIS_CDR.dbo.cdr_foncard.call_cost) AS
TOTAL_COST,  SUM(TORIS_CDR.dbo.cdr_foncard.call_min) AS TOTAL_min   FROM
toriswebed.v_SI_WIR INNER JOIN TORIS_CDR.dbo.cdr_foncard ON

I am developing a database application,using coldfusion mx,ver6.1.I want to
use Connectionless database connectivity.I know the syntax in coldfusion
5.which is
<CFQUERY NAME="rs"

I need to combine 2 tables from different databases.  They both have the same
structure.  I need all rows from Table 1.  I need ONLY the rows from table 2
where the primary key is not in table 1.  Columns other then the primary key
may differ.  EX - Table 1 Key   Value AA     ...

I don't know if this is right or not, I'm quite new to this, but it seems that
I'm having problems with microsoft access making the mdb file.  I see the mdb
files for cfsnippets, cfexamples and company.
I go to the coldfusion administrator then to data sources.  Then I type in ...

Does anyone have any ideas about how I would insert mulitple records into a SQL
database based on a quantity field in my form. For example, I have 20 new
computers and would like to enter a new record for each computer. The number of
rows being added to the database would be ...

I know the question must have been answered, but I searched the forum and
couldn't find it.
I'm using MS Access and have a main table(tblRecord) that uses lookup
queries to populate serveral fields. Examples of two tables the lookup

I am responsible for a marketing database held on the host server and relating
to URL1.  There is a second database relating to URL2 which is held on another
server elsewhere on the internet.  This server has (can have) a fixed IP
address.  At its simplest my marketing activities ...

I am displaying a single record in CF from a Memo field in Access.  I have
confirmed the Access column is set to Memo, not Text, and the CLOB/BLOB in CF
has been checked, I am still only getting 255 characters returned.
I have confirmed that the data in the Access column exists.  ...