Forum: Coldfusion Database Access

I am trying to pull all records that are set for mailing and are from every state except for Nebraska and some counties in Iowa. It isn't pulling...

I've just upgraded from CF 5.0 to CF MX 7.0. One of my CF scripts that includes looping through a DB query does not work well anymore. Under CF 5.0...

I'm trying to write a SP that ignores a blank parameter in a where clause like this. create procedure blah @myvar int AS select * from companies...

Hi, I am attempting to do a simple update query using the cfquery tag. The code is: <cfquery datasource="test" name="testers"> update tablename...

Is it possible to access/query Lotus Notes with Coldfusion? How can I create the DSN in Coldfusion Administrator Successfully? I have searched...

I'm new to coldfusion, and have run into a problem when trying to insert data from a basic HTML form into an MS Access database. The problem is...

Hello, I have a field in a database table that contains a comma separated list on numbers. In my CFQUERY I am attempting to extract records from...

How do I trigger the ORACLE 10g Bulk Loader from within CF? I tried with the following code but am told it is an invalid SQL statement. thanks! ...

Greetings: I am primarily an MS SQL programmer and I am wondering how to run multiple query statements inside a single cfquery block. For...

Hi, I am really stuck and have a project to hand in tommorow, I created a web site in dmx and linked it to the following access database ID, SEE...

in a previous thread a I wrote that i had a problem with the display of japanese characters after uploading <a target=_blank...

Hi, I am really stuck and have a project to hand in tommorow, I created a web site in dmx and linked it to the following access database ID, SEE...

HI Im creating a site that generates leads. When a lead is generated it will select a broker in the list based on certain criteria. The thing i...

I have an Oracle package with 2 procedures. The 1st one is just an insert statement and the 2nd one takes care of updates/deletes. I can run the...

I was recently part of a Macromedia online training session, and someone (I'll keep names out of it for now) made a comment that CFMX and Oracle...

Hi Everyone, For simplyfying things, let's assume that I have two tables MAIN and USERS USERS contains the fileds ID, FIRSTNAME, LASTNAME MAIN...

Can anyone tell me how to get a list of Data Sources from CF server using cfml? Thanks: Phil

Hi Everyone - Finally got to the upload stage. uploaded to my host - mx7 ok. www.healthhokkaido.com I get this Element DS is undefined in...

I have been doing some testing with CF MX7, IIS and Microsoft SQL Express. Everything is on my development Win XP PRO computer. 2G RAM installed...

What MySQL JDBC Connectors are confirmed working with MX 6.1? I'm using 3.2.0-alpha which is very unstable. I've heard that 3.0.17ga works. ...