Forum: Coldfusion Database Access

I'd like to be able to automatically store the date and time that a record gets updated. I currently stamp the record when it's first created by...

I am working on a search page for my work and my results are not comming out right. I know what is going wrong, but I don't know how to fix it....

Here is the bit causing problems: create table tempTAble (case_id) as SELECT case_id from feedback where feedback.status=1 Its giveing me the...

I've got a stored procedure which is called from a VB application on the clients machine. This SPL takes about 2-3 seconds to run. I can run this...

I have a Querey that select patients based upon there appointment being two days ahead of today..which means it selects all patients appointment two...

I've set up a local MS SQL 2000 database for development yet coldfusion MX 6 refuses to see my database tables. My datasource verifies ok in...

would anyone take a few seconds to give some extremely newbie info... I want to take a few form fields (Name, phone, etc)... take those form...

I want to create a verity search collection by indexing the contents of a Union Query. My Union query collects data from multiple databases/DSNs. ...

What causes this process to run? delete FROM CGLOBAL WHERE CGLOBAL.lvisit < :v0 Is there a time setting in the CFADMIN?

I need help with an error I am getting; I am calling an Oracle DB procedure in a package(people) PROCEDURE version_info (version OUT VARCHAR2)...

What is necessary in the setup to save non-Latin characters to SQL Server via CFMX form? The ColdFusion data source has the Unicode option enabled...

I am using a PC with Windows XP, ColdFusion MX 6.1, MySQL 4.1 Server, DreamWeaver MX installed. Also works with a PC with Windows XP, ColdFusion MX...

Hi All.... As the topic summary states: I am a "newbie with no clue!" I own, (and play site administrator) for an online e-commerce business...

I have created a page in DW using CF the database seems to be working fine because it will redirect to the page if Login is unsuccessful. Can some...

1) I have a copy of Coldfusion MX 7 developers edition running on my system. So my computer is acting as my local server. 2) I used Coldfusion...

Well, first of all mirroring is not yet officially supported in sql2005. And microsoft has a JDBC driver that supports mirroring that should work...

I keep getting the following error: Event Type: Error Event Source: ColdFusion MX 7 ODBC Server Event Category: None Event ID: 0...

I've tried all night to figure this one out..And I can't seem to find the answear on the forums.. I've made a CustomTag-file that need these...

I am trying to find the average call length in our database of support calls by using "SUM(calltime) AS time_total" and then dividing that by the...

I have been using this code to grab the column headers from a select * statement. (I never know what table will be queried out of 12,000 or so. I...