Webmaster Forum / ColdFusion / Database Access / October 2008

Guess I'm losing it.
I have a table of locations - key field = location_ID.
Another (lookup) table has fire code violations - a location can have no or
many violations (many to one).

I am trying to update multiple records in one table with multiple values. I
have a feeling that I am going in the wrong direction with what I am working
with but I have tried numerous attempts. I am hoping you can help me. What I
have is a column of "Week Ending Dates" (all ...

I have a form page that displays information to be edited with several DD
select boxes. All have numerical values (CF_SQL_INTEGER).
I don't want to display the first option from the results query in a box,
because if the user makes no changes to that field, the value of that ...

The following codes executed correctly when it was run in sqlplus.
DECLARE
  P_COM_ID VARCHAR2(30);
  P_STATION VARCHAR2(30);

I developed some templates using cf 5.0 and ms sql server 2000 and all worked
well.
 Now i migrate the same set of templates to cold fusion MX and oracle 9i. Now
i am getting this message where ever i used query in the template

All - we are planning on upgrading from ColdFusion MX 6.1 to ColdFusion 8
Enterprise.  The installation went fine, but we are now running into a strange
issue which we think is caused by a driver issue.
We have this Query:

I am getting the following error when trying to run an Oracle stored procedure
that returns a ref cursor using CF MX 7.0.2.142559:
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to

I have a table that contains 230 unique records and another with 20000. I want
to update the second table using a comparison between a common fields in both
tables. My query is shown below.
However, when I run this query I get the following error:

I am trying to update an Access database table that includes a date/time column
labeled "StartDate". When I insert the date, it is inserted properly. When I
come back to update the date in the same form, the date that is entered in not
the same date. It is sometimes years off. I ...

I am trying to graph number of males and females per year for a specific
conditon...However my query doesnt work properly....Numbers shows on the wrong
year....
For sample please visit nexium-vs-joints.com

I am on a slavage mission with a short time frame.  I have a database w/50
tables all with the same structure, I need to display the contents of the
tables base on a user click on an image map.  My problem is that I am trying to
dynamically set the table name to be used in the ...

Hey guys,
I've just finished installing our CF 7 environment on Windows Server 2008. It
was a bit of a task but nothing major. What I would REALLY like to see is Adobe
step up to the plate to provide support for Windows Server 2008 for ColdFusion

This is probably more of a SQL Server question than a ColdFusion question, but
I'll ask anyway.  
I'm trying to connect a SQL Server 2000 database (name: RSA) on server RSA to
CF8 on server Earth.  I'm pretty sure I have everything correct on the CF side.

If I have a query result in cold fusion, how do I send out emails only if the
row in  column area is equal to test?
What I'm looking for is the code to loop through the query and send out emails
like this:

noob...I have a few SQL queries defined as filters to select todays info, yest
info, tomoro info, all info.  My form works well using the output query
ACStatus, ACStatus2Day, etc.
 I put in a radiogroup like this: <input type="radio" name="RadioGroup1"