Webmaster Forum / ColdFusion / Database Access / April 2008

I need to port a CF8 Enterprise applcation off an MS Access DB to an existing
MS SQL Server database/environment (I guess I am technically piggy-backing my
database into an existing 'instance').  I have created my SQL Server database,
loaded it from the old Access database, and ...

Operating System: Linux Red Hat v5 (kernal.os release 2.6.18-8.e15)
Cold Fusion: Trial Developer Version 8
MySQL version: 5.0.51a
MySQL connector (installed in /opt/jrun4/lib):

setup: coldfusion mx 7.0.2, sql server 2000 db
i have a weird problem:
- the page is multilanguage and everything is programmed in utf-8 as charset.  
database fields are nvarchar.

Earlier my application was developing and running on CF 5, Oracle 9i
Recently it was upgraded to CF 8.
My code was developed in CF 5 to insert/update Traditional Chinese characters
into the database.

Help please...
How can I get the my custom RFCal function to work within this select
statement??
My Error:

Hi,
Can anyone help me with this no doubt simple query.
SELECT Authors.authorID, Authors.lastname, Authors.firstname, [firstname] & "
" & [lastname] AS fullname,

I'm hoping I'm just doing something very stupid. I have CF8.01 and SQL Server
2005. I have a simple table for which I recently added a column, with the
default value of NULL. When I do a query of all fields from within SQL
Management Studio the results include all fields, ...

While processing a script I get the following error:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'forum=1 and zip IN ()'.

If I use a hard-coded set of string values in an IN expression, the query
returns the expected data.  
If I then replace the hard-coded expression with an equivalent CF variable
embedded in a cfqueryparam tag, the query executes but returns no records.  A

I have built a database in Access which allows me to import a list of file
names hundreds at a time into a table. My ultimate goal is to import that table
in to Coldfusion, and allow users to be able to make changes to that list (for
example, make a note who updated that file and ...

Here's my scenario. I am running SQL Server 2000 SP4 on a Windows 2003 Server
running IIS 6. Using ColdFusion MX 6.1 Updater version.
I am storing HTML page code (some complete, some just clips) in a text type
field.

Running CFMX 7 on a 2k3 server. Trying to access  MS SMS data in an SQL 2k5
server on 2k3...
My system odbc tests successfully using the sql server driver. And with my
admin account credentials.  In cf Admin datasources, using an ODBC socket

I've been troubleshooting a slow-running Oracle (9i) proecdure call, which
was coming in at 4sec.  When run via a Oracle SQL Developer window, it runs
in 0ms, which is more like what I'd expect form the amount of work it's
doing.

I have built a database in Access which allows me to import a list of file
names hundreds at a time into a table. My ultimate goal is to be able to allow
users to make changes to that list (for example, make note of who updated that
file and when they did so). What command do I ...

My understanding is that CF is unable to set up a datasource to Oracles "Bolt
On" Calendar solution.
Because the calendar runs a Unison dB.
Anyone have any experience w/ connecting//reading/writing to Oracles' Calendar?