Webmaster Forum / ColdFusion / Database Access / January 2007

In Access 2003:
SELECT ADMI_AGR_DEALER_BONUS.DEALER_ID, ADMI_AGR_DEALER_BONUS.CERT_PERIOD_ID,
ADMI_AGR_DEALER_BONUS.BONUS, ADMI_PBR_CERTIFICATION_PERIODS.CERT_PERIOD_ID,
ADMI_PBR_CERTIFICATION_PERIODS.IMA_APPLIED_START_MONTH,

I am using ColdFusion 7 Enterprise, updater 1 with DataDirect version 3.4
drivers and Oracle 8i.  ColdFusion 7 is returning no data for CLOB datatype
columns.  The ColdFusion 5 version currently in production is successfully
returning values for these columns.  I have changed the ...

I am having some trouble updating an oracle db that has a clob field,  this is
the part of the query that is getting the form data:
<cfqueryparam cfsqltype="cf_sql_clob"
value="#trim(form.additional_information_fr)#">

Hoping someone can help. I continue to get this error message when I try to
connect to this page. Error is as follows.
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

I have a problem with SQL Server 2005 system views.  In SQL 2005, system tables
(e.g. sysobjects, syscolumns) are now hidden and their contents are made
available through special "system views".  We have a CF data dictionary
application here we have been using for years with SQL ...

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to
contact the server (Server returned: Connection reset). Please ensure that the
server parameters passed to the driver are correct and that the server is

I am in the process of switching from Access to MSSQL. in order to connect to
the database I have added the following attributes to my <cfquery> tags
dbname="" dbserver="" username="" password=""
Although this seems to work ok I understand that I can also use the

Ok, this is an odd one. In a piece of code, I had an evaluation like this
<cfif 2 IS "01/01/1900">True<cfelse>false</cfif>
And for some reason "2 IS '01/01/1900'" is resolving to true! Why is this?
Does anyone have any idea as to why?

Heya guys
the update statement seems to have a problem..
i keep getting this error
[Q]You have an error in your SQL syntax; check the manual that corresponds to

I am migrating from access to MySQL.  What connector should I use, ODBC or
JDBC, and what is the difference.  The application is already developed, so if
I go to JDBC will I need to make any major changes int he code.
Please help...

Alright, basically, its like this. I'm trying to return the results of a search
from a query and here is whats happening...
[code]
<cfquery name="getNew" datasource="#dsn#">

I am using MySQL. I am trying to retrieve a set of numbers that appear in the
database the most. I have the following columns, digit1, digit2, digit3,
digit4, digit5, digit6. I am wanting the top 6 numbers that appear across each
column, for an example the number 17 could show up ...

I am using an update statement to enter a number into an access databse where
the field is set as an interger format. The syntax used in the update statement
is     order = '#form.order#',
When this is processed I revieve the following error:

I didn't know where to ask this, so I will post it here.
I have been using Cold Fusion for 4-5 years with Paradox tables. The site has
gotten more and more complex. The site is hosted somewhere else and I don't
have any control over their software or drivers.

Hi,
I am using Oracel 10g, Oracle 6.1, i want to use Stored Procedures in my
project. I am getting some problems while using this one.. please help me.. Is
there any configuration setting in the Cold Fusion administration...