Webmaster Forum / ColdFusion / Database Access / July 2007

I'm sure this is an easy one, but after a long day it's eluding me completely.
I have a simple query as follows;
<cfquery name="searchq" datasource="#datasource#" maxrows="15">
SELECT ID,price,merchant_id,feedname,feed_description,feed_img

I am working on a site and I have two databases. I used the Request.DSN in the
application.cfm for the first data base...but how can I do something similar
for the second? I would rather not have to go back and rename everywhere the
database is listed in the site to make it match ...

I am not sure this is the appropriate spot to post this, (if at all), however,
I am desperate. Currently I am hosting a site, running on Linux and cold fusion
at godaddy.com. I have many other sites with PHP. However, Cold fusion has been
a nightmare from day one. Anyway, can ...

I am creating a website results page (in Macromedia Dreamweaver) that yields
records from my database depending on what checkboxes a user checks on the
search page.  I am using a MS Access database and Coldfusion.
Basically, my database has a field for each checkbox I have on my ...

I'm constructing a webform to take in information and store it to a Access
database.  The error that I've been getting has something to do with my Values
after the INSERT INTO statement. I have been getting the same error for the
past 3 days and I'm don't know what the problem ...

I have three tables, photos, comments and prices.  Their structures
(abbreviated) are as follows:
photos
---------------------

Can anymore tell me if its possible to create dynamic datasources in MX7 I know
it existed in 5 but was removed. I have remote machines on a local network
running Sequel Server, I need to be able to dynamically pass in the server name
in the querys.

hello, I have a data feed of comma delimited values coming into coldfusion.
Cold Fusion cannot run my SQL search with these commas present.
How do I use "List Qualify" to allow Coldfusion to interpret this feed
correctly.

I have two Oracle stored procedures that are overloaded.  Each returns a
reference cursor and works fine independently, so long as the other procedure
is removed from the package.  I am passing the IN parms in the CFProcParam tags
named with the dbvarname attribute and am ...

Had to re-instIall SQL Server Express 2005. and now when I try to make an ODBC
connection. I get the following error.
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that

I'm getting the following error
Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native
Client][SQL Server]Cannot call methods on varchar.
I've been given database, I can see what the problem is that the IDs have been

In my database connection i can`t see the plus sign on the database tab.
My local root folder is:
C:\CFusionMX\wwwroot\cafe_townsend\contact\coldfusion\
remote: C:\CFusionMX\wwwroot\

Ok, I'm trying to inner join three tables and when I do, I get an error telling
me I am missing an operator. Here's my code:
SELECT *
FROM Systems s

I'm not sure whether this is possible or not, but worth a shot -
I need to be able somehow output only rows where the text field of a column is
less than (for arguments sake) 30 characters (including spaces).  I know I can
use CFs Left() function to trim the string, however I ...

hello. I have a website that needs to get data from a sql datasource on another
webserver... what is the best way to connect to this remote database server...
I am sure there are many ways to do so, so any help or tutorial on this would
be very helpful... thanks...