Webmaster Forum / ColdFusion / Database Access / June 2007

Is there a better way to write query?.
People  Table
pid     name    state
10       sam       ny

I am using MX 7 and PostGRESql locally on the same dev machine.
When i connect to the database with in the website for the very first time, i
get the following error msg.....
[b]The system has attempted to use an undefined value, which usually indicates

Is there a way to run a query on two separate datasources?  I would like to compare the data in two separate MS Access databases.
Thanks.

I am buiding a new eCommerce store and part of this is an import function to
update products with distributors stock levels and also to import new products
and delete discontinued ones.
One distributor's part numbers are numeric and this whips through the update

I have an application that allows the user to open MS Access database files.  
The files are launched through the cflocation tag and when they are launched,
the user receives "You do not have exclusive access to the database at this
time.  If you proceed to make changes, you may ...

I got a sorting asc and desc in my page...works fine.
I am planning to change my query to stored procedure.
What is best way to handle sorting using stored procedure.
do i need to pass sort parameters inside stored procedure as input parameter?.

I have some CF5.0 code which uses the dynamic ODBC feature to connect to
different XLS files, SQL them for various data, read them in and then process.
If I upgrade to 7.02 I believe that these feature has been removed.
Is anybody aware of any workaround, custom tag etc that can ...

Does anyone have any experience extracting the "Enum Values" from a MySQL db
column of a data type ENUM? I inherited a huge database for a project which is
chock full of  ENUM and SET data types, which I personally have never used. I'd
like to dynamically populated SELECT lists ...

Greetings all!
I'm getting an error from MSSQL 2005 on the query below, the DB was just
converted to SQL2005 from Access by the hosting company over the weekend. I'm
sure about the change in Syntax I need to make this work.

i recently had a sever system rebuild (msUpdate methinks) and when i got my
computer back from my tech guy, all seemed fine msSQL, cf server etc. Localhost
works fine.
problem is trying to get homesite to find my datasources. i don't remember

Title and summary says it all...
I've read over and over that stored procedures are more robust, but I've yet
to use one (Knowingly).
So, if I have query such as

The UTF-8 encoded data in my MySQL database does not retain the unicode format
in cfoutput. I was able to copy unicode data from the database and paste it
directly into a test HTML page that had the appropriate meta/content tags to
verify that original language displays properly ...

Hi, I'm a student working in my University's Library. They are looking for a
coldfusion solution to send e-mails directly from their website. Here's the
catch, in my database (which I haven't set up yet) I'm thinking of giving each
e-mail address an ID number, then in a separate ...

Hi all,
I have been trying to troubleshoot this for a few weeks now, I have looked
high and low and tried multiple solutions that worked for other people, none
have worked for me.

I have a query that seems to be hanging up, and all indications point to a CFMX
problem, not a SQL problem.  I tested executing the stored procedure three
times (non-concurrently) via CFQUERY and SQL Query Analyzer using the same
command, and the runtime results are as follows: