Webmaster Forum / ColdFusion / Database Access / August 2007

I'm moving from 6.1 to 8.0 and have found a query which works in 6.1 but not
in 8.0, and I'm just wondering if there is a workaround for it.
What I'm doing is inserting multiple records into a table and using @@rowcount
to find out the number of records inserted, this code ...

Is it possible to insert into 2 different datasources within the same script?
It seems as if Coldfusion will only process the first query.
<cfquery datasource="PhoneBook" name="saveBuildingSQL">
    INSERT INTO tblRole

I want the registered users of my site to send each other messages.
I have a database with 2 tables for the messages: the first is for new
messages, the second is for saved messages. When a user logs on & goes to their
message inbox the page lists 2 catergories from the 2 ...

I need to do a query similar to this one:
SELECT * FROM t1 WHERE id NOT IN (SELECT id FROM t2);
The problem is that t1 is in a MySQL datasource and t2 is in a Foxpro
datasource.  I tried bringing everything I need under the for of queries and do

First off, let me clearly say, I DID NOT DEVELOP THIS APPLICATION LOL. I'm the
one who's stuck trying to upgrade the piece of garbage.
I am working with a datasource which is a Access DB . The DB Table names are
surrounded by parenthesis, and when i go tell cfquery the table, CF

Hi --
I am building a database driven RIA and one part of my application is the
main menu. This is pulled from my DB as the menu options presented to the
user are based on the users security level. Currently my <CFQUERY> tag is as

Good day every body.
Im sure this is possible but i dont know how.
I need to connect to a mysql database without creating a datasourse.
I need the query code please.. if i need to install a driver on the server or

I am working with a pre-existing database in which many of to column names
contain a # sign. Does anyone have a good solution for this scenario aside from
renaming the column?
Example Column Name: Last_CTR#

CF8 and MySql 4.1.10 MyISAM on windows 2003 webed
Some of my DBs have 0000-00-00 dates.
This was no problem in CF7, but now in CF8, after doing a basic select it
errors invalid date / time.

I'm trying to insert data into two in MS SQL server. I get the following error
Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native
Client][SQL Server]Incorrect syntax near '-'.  
The error occurred in C:\ColdFusion8\wwwroot\Rayanne\customerinsertsql3.cfm:

I have 2 issues
first: I need to have the information automatically sorted "descending".
second: ineed the information to wrap.
been working on this for a while and can't seem to resolve these 2 items.

Using ColdFusion MX 7.  Able to convert the BLOB into a string when the data
source is in UDB (Our development Database) however when the data source
changes to MVS DB2 (Staging and Production Databases) the template no longer
renders the data to the screen.

I'm trying to insert data from one web form into two Access 2007 (set up as
2003.mdb ) tables.
Iget the following error message by using the attached code.
Just wondering what's missing

Hi --
I would like to build an accordion by iterating through a record set and
create the open and close tags for the accordion based on a value in my
database. However, when I try using the <cfif>/<cfelse> tags with

I am attempting to call a stored procedure using the cfstoredproc tag and no
matter what I try I get  "The request has exceeded the allowable time limit
Tag: CFSTOREDPROC" I have tried several different stored procedures. Each
procedure works when called from SQL Plus. This is ...