Webmaster Forum / ColdFusion / Database Access / April 2006

I have a variety of sites on my server all accessing the MySQL database.
Whenever I restart MySQL and attempt to access one of the sites via (IE)
browser the attached error is encountered. After that, when I refresh the
browser, all is ok... the connection has been established ...

I'm building a where clause as a string based on submited form variables.  As
long as the form variable is an INTEGER the query works fine. If it is a
charcter or character string I get the error:  "Incorrect syntax near 'n'  "
where "n" was the content of the form variable.

Im trying to compare the records of 2 different tables in the same database,
using cfif  statement(s) and/or coldfusion or sql. If they're the same > output
results, if they're not the same > output different results, if field is empty

at the moment is am trying to create a page to update a database.
i select the a company in a list which the gets forwarded to the next page. On
the next page i tell the page that the it has to display all the information
from the selected company by telling it that    "Where ...

We're moving from CF5 Ent to CF MX7 Std.
We'll be losing the built-in support for Native Datasources.
Is there still a way to use/have Oracle80 drivers work on a Std verion?

I am trying to connect to a MySQL database that is on another network. The port
has been opened, and I am able to connect to it via telnet (to test). I cannot
connect to it from my CFML MX7 admin when I am trying to create a DSN. I get
the following error.

I've been working with Oracle Stored procedures for a short time and have run
into a glitch
when working with data types of integer.  I have a form that I use to collect
data from users

I am getting the following error when trying to query an Access database: (see
attached code)
I have done some research and have tried using quotes, but that has not
helped. Any help would be appreciated.

I've tried both mapping a drive on the server and using a UNC link, but my
Access Unicode datasource won't work with files on another server.  I have the
domain "logon" account rights embedded in the CF application service, so that
should be set.  

Hi
I am working on one project which involve multiple function site, such as
Company Product Catelog, Customer Support Forum, Document Exchange Engine and
etc...

I am creating triggers and stored procedure on ORACLE data base using
<CFQUERY>.
<CFQUERY DATASOURCE="CRM">
create or replace trigger AWC_ACCOUNTINGPERIODSID_TRI

I did not write this code and please excuse me for my beginner questions?
?    Is there a way to make this code cleaner.  Code it where its less lines of
code?
?    Can we make the 2 conditions separate rather than a one after the other?

I have a number of articles that I have applied a css sheet to. I have close to
twenty articles.
Each article has a couple of pictures - headings and text and they all differ
in lenght. Is it possible to store them as cfm pages and pull them  from the

I just reinstalled ColdFusion (Developer Edition) and I had to reinstall the
mysql-connector-java-3.1.12-bin.jar file into the WEB-INF\lib directory for
added connectivity with MySQL 5. Problem is, I can't find that directory
anymore...

Registry entry:-
HKLM\CCS\Services\Coldfusion\
db\slserver52\bin\swagent.exe "ColdFusion MX ODBC Agent"
db\slserver52\bin\swstrtr.exe "ColdFusion MX ODBC Server"