Webmaster Forum / ColdFusion / Database Access / August 2008

if a have a field of part numbers that was entered in random order like:
62A-1212
62A-44
62A-33

I am working with a database table that has a list projects. Some of these
projects have sub-projects. There is a column with weekending dates with
corespond to manhours associated with that week. Here is an example.
JobNum SubJobNum WeekEndingDate Manhours

If I have a cf function that returns a query, what should I return if no rows are found?

I have a function that returns a struct:
<cffunction name="getChartData" access="remote" returntype="struct">
        <cfargument name="userID"        required="true" type="numeric">
        <cfquery name="chart" datasource="#datasource#">

I'm getting an error on the syntax for my SELECT statement in a Query of
Queries.  The code is:
      <cfquery name="OnOrderLogData" dbtype="Query" result="result3">
            SELECT *,

I can't seem to get a simple update cfquery to work (update a table row)
without throwing an error in access. I've gone over the code several times and
don't understand why it's throwing an error. I want a user to be able to remove
themselves from a mailing list, with having to ...

How would I parse a timestamp MS SQL column so that flex would understand when I send it to the client?
Query is written in Cold Fusion.

In CF5 we were able to make a datasource connection to a TXT file, I think we
could also do it in 7, but in CF8 there appears to be no option to do this? I
set one up within Windows ODBC but CF8 does not see it, it seems that all
datasources must be set up within CF8 ...

All of a sudden I can't connect to SQL server databases from my local machine.  
The databases are on a web server.  It just started happening, and I never had
a problem with it before.  I can't connect to them in the coldfusion
administrator, and I can't connect to them using ...

I'm getting the following error:
The error occurred in
C:\Inetpub\R3Staging\Htdocs\qadmin\questionnaire\questionnaire.cfc: line 220
218 :      <CFFUNCTION NAME="getresults" HINT="get questionnaire results"

I am working with a database table that has a list projects. Some of these
projects have sub-projects. There is a column with weekending dates with
corespond to manhours associated with that week. Here is an example.
JobNum SubJobNum WeekEndingDate Manhours

I have a table (vendor) that holds vendor ID, Contact Name, Contact Phone, and
Contact Email fields.  I have another table (master) that is holding many other
fields, but includes the Contact Name, Contact Phone, and Contact Email fields.
I'm populating the master fields based ...

Re: this example page
(http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html) it seems
that with a stored procedure (sql server 2000)
a.) the cf function returntype must be set to any -- what are the implications

my hosting service provided me with this connection string.
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=p50mysql231.secureserver.net;
PORT=3306; DATABASE=mgidata; USER=mgidata; PASSWORD='your password'; OPTION=0;
i can fill in all the blanks but i don't know how to us it in cfquery.

I use cfqueryparam extensivily in all my code with MSSQL. It always worked and
NEVER errored in CFMX 6.1. I recently upgraded to 7.01, and I get intermittent
errors about once a day (on different random queries). Looking at the error
emails I get, the queries should work. One ...