Hi,

I fixed the data and ensured it wouldn't happen again by setting a default on the field (0).

How embarrasing!

The Outpatient column containd some NULL's.

Of Course 1+1+NULL is NULL.

Thanks,

Hi,

Yep, This works :

SET ROWCOUNT 5

SELECT * from PATIENT

However this :

SELECT top 5 * from PATIENT

returns the following error

Server Message: Number 102, Severity 15

Server 'hhie', Line 1:

Incorrect...

Thanks,

That helps a lot.

Hi,

On the logging tab, the option at the bottom, "Error Handling" has a file location and name specified,

but there is no file at all in the location when...

Hi,

Reposted in the DTS forum, where it is more appropriate.

Please look there for more info.

Solved.

I was't careful enough about where I placed SET @INTERRORCODE = @@ERROR, the error code was being overwritten (perhaps the dealloation of the cursor)

Hi,

Rather then Views, you probabally should use Stored Procedures. ColdFusion can utilise these quite well.

eg

<CFSTOREDPROC PROCEDURE="dbo.NEWS_ITEM_EDIT" DATASOURCE="NET_NEWS">

<CFPROCPARAM TYPE="IN" DBVARNAME="@NEWSS_REFNO" VALUE="#URL.NEWSS_REFNO#" CFSQLTYPE="CF_SQL_NUMERIC">

<CFPROCRESULT NAME="NEWS_ITEM">

</CFSTOREDPROC>

turning email option on, sorry for double post

Hi,

Although Domain Accounts do not seem able to work, it WILL work with SQL accounts. It doesn't have to be SA.

Thanks,

Hi,

I now have it working.

I performed a Windows Update, rebooted, and then installed Service Pack Two for SQL Server Client tools. I am not sure exactly what step it was...