Webmaster Forum / ColdFusion / Database Access / May 2008

Ok so I am really a newbie when it comes to CF.  I know how to add DSNs in the
CF admin locally.  The problem I am having is connecting to a database on a
different server.  I know I have the correct IP address, so the problem has to
be the port.  Using the default port will not ...

I changed hosting companies and now I'm having issues with query errors.
Here's the first one:
Error Executing Database Query.  
Syntax error in UPDATE statement.  

I'm trying to delete record from table with about 2000 records which has ID as
a primary key.
DELETE FROM Table WHERE ID = 1
I get this error:

We're moving to Informix 11 and find that the Informix support in MX 7 can't
quite make it work ("end of stream" errors). The JDBC drivers that come with
Informix seem OK, but I  would rather not redo all our datasources for a new
driver.

Providing there is only one or no SELECT statement, can I issue multiple
statements to a database inside a single cfquery?
For example will this work correctly:
<cfquery datasource="myDB" username="myUserName" password="myPassword">

I'm having trouble with the syntax for comparing one database field to another
using the like statement. I've found plenty of examples using db field to
variable or string, but can't find any with db field to db field.
For example

I am trying to connect to MySQL (I just downloaded and implemented it). In the
past, I have only used Access and SQL. I cannot seem to connect. Can someone
point me in the right direction please?
Here is the message I am receiving...

Hi there, having some trouble updating my tables when submitting data from a
dynamically generated form that uses cfloop query.  I could really use some
help.  
When I dump the form, I get the correct output ? so I believe it is my SQL

I am creating a "Class" table to hold training class information for my
company. Some classes are held on a single date. Others are held on multiple
dates like 5/12 - 5/16. Some are held over a two week time frame. All are held
on business days, no weekend dates. How should I ...

Cold Fusion 8 fully patched on Windows Server 2008 fully patched
Oracle 8.1.7.1 on Linux as DB with Network Option (encryption)
Oracle Client 10.2.0.3 Thin Client (tried with ojdbc14 and ojdbc12 classes)
SELECT, DELETE, UPDATE statements all work just fine.

Hi, I just have a pretty simple Access question, but I can't seem to get my
query to run correctly! I have two tables, reqStats and intent_pws. The
intent_pws table has two fields, Practicum_ID and banner, that uniquely id each
record. In reqStats, I only have the bannerID field. ...

Does anyone know if there is a limit to the number of data sources that can be configured through CF Admin. If not at what number might I see performance issues i.e. 1000 data sources??

I'm new at CF.  I have an access database that is taking in form data.  That
part I got working fine, but what I'd like to know is there a way to use cf
(6.1) to extract the data and format it into either a word document, or
excel spreadsheet, then either email it and/or dump it ...

I like to see who is available on Sunday to take this shift that starts from 12
AM to 5:15 AM... The below query returns 0 even though there is a person who is
available from Saturday 9:15 PM to Sunday 5:15 AM... How would I modify the
query the pick that person ??

Hi,
I have 2 tables(below),  I need to pull out all the rows in the videostream
table where the videostream.movieCat list contains the ID of the category in
the moviecat table. Normally I would just use the IN query: